The issue is that I have with me a 1.5GB SQL dump from Postgres 8 which I extracted using pg_dump.
Restoring it seems to be an issue on this PC. I've tried modifying memory directives in postgresql.conf as well as the kernels SHMAX value but no go.
I tried a bunch of other things such as gzipping the file so that it was only 100mb and doing:
Code:
gunzip -c dump.sql.gz | psql my_db
But I recieved many errors saying "invalid command N" and I also got a syntax error notice and the process terminated.
I tried to at least try and enter some data manually but vim is incredibly slow since this is a 1.5GB file.
Is there a way I could perhaps split up my db dump and then import them into the db one by one?
i had to do a file system back up because of the size of my database.
i shutdown postmaster and tar'd the files.
i recently reloaded my OS and now i'm attempting to restore the backups. i first shut down postmaster, restored the backups to the data folder and restarted postmaster.
i then su'd from root to postgres user:
Code: [postgres@austin1 pgsql]$ psql service_2_3 psql: FATAL: database "service_2_3" does not exist DETAIL: The database subdirectory "base/16385" is missing.
the backups had a database named service_2_3 but upon restoring the backups, it doesn't seem to be available.
my data directory is /var/pgsql/data.
Code: [postgres@austin1 pgsql]$ ls -lahR /var/pgsql/ | grep 16385 but that yielded nothing.
have i done something wrong while backing up? i don't think i have since i followed the postgres manual when backing up. but the administrators have not been very thorough with how they've set the system up for me.
how i can resolve this issue if you have the time.
I have a server running Cpanel and I have added postgres through /scripts/installpostgres, also I have set it over WHM and can access phppgadmin but I got this error when connecting throug a script
Fatal error: Call to undefined function: pg_connect() in /home/rer1223/public_html/process/Connection.php on line 4
I checked and postgres is not listed in phpinfo output.
I just reloaded the OS on our production server and I'm having issues configuring postgres.
the user postgres exists in the system (i.e. 'su postgres' switches me to that user) i attempted to connect to my database 'service_2_3' via CLI:
Code: $ su postgres $ psql service_2_3 and i recieved the following error:
Code: psql: FATAL: IDENT authentication failed for user "postgres@service_2_3" the database is installed on the machine on which i was attempting to connect to it with.
therefore, i edited my pg_hba.conf so that it looks like this:
Code:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: host all all 127.0.0.1/32 ident sameuser # IPv6 local connections: host all all ::1/128 ident sameuser host all all 0.0.0.0 0.0.0.0 password
I love my current host. It's fast, has excellent support, uptime is great, and I get a lot of features. I'm paying $10 a month for it, though.
I'm thinking about moving to 1&1. Is this a bad idea? I had 1&1 about a year or two ago, but canceled it because I didn't end up building the website I ordered it for. Didn't have any issues, but the cancellation process was a pain. Nothing major, though.
The thing that 1&1 has going for is it is the price. $4 a month is a darn good deal.
That's 2.5x cheaper than my current host. I could save a lot of money. I know, you get what you pay for...
So am I being stupid? I don't use a lot of bandwidth (I used 1.5GB last month, and average less than 1GB), and my website hosts my software that I sell, so a lot of downtime is obviously bad. The only thing I see that's bad about the $4/month plan is no ssh access, which is really only convenience for me (I don't require it).
I am having a hosting account with old host which is limited to 10 GB, and there i am having a mysql Database which is of 2 GB, i want to move it to new host via SSH ... as that Database can not be downloaded via phpmyadmin due to its size.
So i want to "tar" the mysql directory and ssh/scp to new host!...
I am applying this command...
tar -cvf r.tar /var/lib/mysql/in_supp | ssh user@newhost.com
But i am getting errors,
Please give me a command which can move my entire Database dump to new server, without creating any copy at old server "as i do not have any space there"
I have a domain that used to have a huge members list with thousands of email addresses. Now that I enabled its web site, the server attempts to relay email meant for those harvested addresses. Also, spam relayers picked up that the DNS is live and try to use the domain to deliver spam What can I do with the MX records in order to dump all email without the server handling it? Currently all email is set to :blackhole:
Files such as core.12762 keep appearing in the root web directory. Amount of core files appearing seems to be proportional to traffic. On average one core file per few million php requests.
Will appreciate advice on how to troubleshoot this issue, or how to disable the core dumping. As it is one error per few million requests it does not seem significant enough to spend several hours troubleshooting.
I am trying to configure CPLinks, anyone know where can I find such category dumps or do I need to key in one by one? Tried to contact cplinks side for the dumps but no response. Do let me know if anyone had prepared such dumps.
recently I had problems with backing up my ~150mb database through PHP. And I know some people are backing their databases to a dump file through terminal.
My database contains UTF-8 and other characters. I have tried simply dumping with mysqldump but I doesn't seem to work, when restoring all the characters are messed up.
Is there any command to tell that the database is UTF-8?
After successful creation of a full backup, pmm-ras hangs forever (100% CPU) while trying to export the dump to FTP. I have two identical Plesk 12.0.18 installations and this happens only on one of them.
I see the following in /opt/psa/PMM/sessions/*/.stderr:
Use of uninitialized value in numeric eq (==) at /opt/psa/admin/bin/plesk_agent_manager line 827.
That is emails that are waiting to be sent which are not going to be sent since they are bad emails so they are just stuck in the queue and are killing cpu resources, how does one tell Qmail to dump all unsent emails waiting in the queue?
how to create Dump File for Apache Crash in Windows.We are using Apache for Reverse Proxy with OpenAM Module for Sign-in.Apache Version : 2.4.9.0...We are very frequently facing Apache Crash Issue.
Also in logs we do not get much information.when submitted logs to ForgeRock, they asked us to look into below error and provide Crash Dump.
[Sun Jun 15 23:00:10.153908 2014] [mpm_winnt:warn] [pid 2376:tid 424] (OS 64)The specified network name is no longer available. : AH00341: winnt_accept: Asynchronous AcceptEx failed. [Sun Jun 15 23:02:21.609557 2014] [proxy_http:error] [pid 2376:tid 6544] (OS 10060)A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. : [client 10.XXX.XX.XX:XXXX] AH01095: prefetch request body failed to XX.XXX.XX.XX:XXX (teampark.sogeti.com) from XX.XXX.XX.XX (), referer: https://teampark.sogeti.com/blogs/roller-ui/authoring/weblog.do?method=create&weblog=VeckobrevIntegrationSyd&lang=sv_se
under Plesk 12.0.18 PHPMyAdmin is failing to import a 3 MB SQL dump of a simple Joomla website. "Error 505 Bad Gateway", it says.It happens with other dumps too, some as small as ~500 KB. The format (SQL or ZIP) of the file uploaded doesn't seem to matter, because the upload itself seems to work; it seems it's the post-processing what is raising the error.
The funny thing is that the import itself seems to work (the contents of the SQL dump are imported), but the error message appears and causes confusion and support requests from our clients./var/log/sw-cp-server/error_log says:
2015/05/15 03:19:31 [error] 10215#0: *5 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: XX.XX. XXX. XXX, server: , request: "POST /domains/databases/phpMyAdmin/import.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "xxxx. xxxxxxx.com:8443", referrer: URL.....To me it sounds like a timeout.
This seems to be a "popular" error among Plesk users, and I have tried this, this and this with no luck.
All domains were offline this morning. Plesk showed the following error message. It seems we are beta testing the software. I am on Suse 13.1, clean install.
Unable to rotate dump: The dump rotation is failed with code '1' at /usr/local/psa/admin/bin/plesk_agent_manager line 1041.
Warning: domain "abc.com"
The domain 'abc.com' may be inaccessible after backup. Please, resume it manually!
Every time a backup task finishes (full server or a single domain) i get the following error:
The operation you were performing failed. You can retry the operation with or without changing its parameters. You may also want to report this problem to our support.
Unable to find Backup dump object ---------------------- Debug Info ------------------------------- 0: backup.abstract-repository.item.php:63 __backup__abstract_repository__item->getDump() 1: backup.abstract-repository.item.restore.php:38 __backup__abstract_repository__item__restore->accessItem(string 'GET', NULL null) 2: UIPointer.php:600 UIPointer->access(string 'GET') 3: plesk.php:50Click to expand...
After upgrading from 11.5.30 to 12.0.18, when make backup see next message:
<?xml version="1.0" encoding="utf-8"?> <execution-result status="error"> <object name="example.com" type="domain"> <message severity="error" id="167b9714-3e33-4863-861d-69c4f559afe6" code="InformationalException"> <description>Unable to dump IP addresses for mail service</description>
Code: # plesk bin pleskbackup server UNIVERSAL->import is deprecated and will be removed in a future perl at (eval 13) line 3. UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run.pm line 1060. UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/IO.pm line 78. UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/Timer.pm line 161. Runtime error: Could not run make dump with pmmcli[Illegal seek]
Code: # /usr/local/psa/admin/sbin/pmmcli Traceback (most recent call last): File "/usr/local/psa/admin/sbin/pmmcli", line 5, in <module> import pmmcli File "/usr/local/psa/admin/share/pmmcli/pmmcli.py", line 21, in <module> import pmmcli_session File "/usr/local/psa/admin/share/pmmcli/pmmcli_session.py", line 15, in <module> import pmm_migration_handler File "/usr/local/psa/admin/share/pmmcli/pmm_migration_handler.py", line 16, in <module> import migration_handler ImportError: Bad magic number in /usr/local/psa/admin/share/migration-handler/migration_handler.pyc
