Restoring 1.5GB SQL Dump (Postgres)
Jan 23, 2007
This seemed like the most appropriate place so I decided to post here.
SYSTEM:
Fedora Core 4, 3GHz, 2GB RAM
Postgres 8, Apache 2, PHP 4
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?
View 2 Replies
ADVERTISEMENT
Feb 19, 2007
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.
View 6 Replies
View Related
Feb 4, 2015
I have enabled the backup rotation of some websites to my "Personal FTP Repository", the problem is that Plesk is unable to do it due this error:
Code:
Unable to rotate dump: The dump rotation is failed with code '121' at /usr/local/psa/admin/bin/plesk_agent_manager line 1041.
I read here [URL] .... that it should be solved but I have the version 12.0.18 Update #33, why does it persist?
View 5 Replies
View Related
Feb 19, 2008
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.
View 5 Replies
View Related
Feb 20, 2008
I have installed postgres over my cpanel account but I am unable to find php_pgsql.so file
I am running Centos 4 Apache 1.3 PHP 4.3 Postgres 7.3
View 4 Replies
View Related
Jul 9, 2007
PostgreSQL (Cannot add new user or database). It will return "User/DB added successfully" but no new user or database is added.
root@server [~]# rpm -qa | grep postgre
postgresql-devel-8.1.4-3PGDG
postgresql-contrib-8.1.4-3PGDG
postgresql-8.1.4-3PGDG
postgresql-server-8.1.4-3PGDG
postgresql-libs-8.1.4-3PGDG
postgresql-python-8.1.4-3PGDG
I've already compiled apache after postgres was upgraded months ago.
I'm using cpanel 10x
View 1 Replies
View Related
Jun 14, 2007
I was hoping someone could shed some light on a cron related issue I'm having.
I've been using linux for a while...but never really used crons.
My cron is supposed to dump a postgres db in tar.gz format every minute (for testing purposes) but it doesn't.
I opened my cron in vim via:
Code:
postgres@myhost:~$ crontab -e
And here's the cron:
Code:
* * * * * /usr/bin/pg_dump -D warranty_1_6_test | gzip -c > /var/www/test/postgres/backup$(date +"%Y%m%d_%H%M").tar.gz
Also:
Code:
postgres@myhost:~$ ls -lah /var/www/test/postgres/
total 8.0K
drwxrwxrwx 2 postgres postgres 4.0K 2007-06-14 12:01 .
drwxr-xr-x 3 user user 4.0K 2007-06-14 11:47 ..
Running the backup command via CLI works fine.
View 5 Replies
View Related
Feb 15, 2007
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
and reloaded with (as user postgres):
Code:
bash-3.00$ pg_ctl reload -D /var/lib/pgsql/data -l /var/lib/pgsql/data/temp.log
but i still get the same error. am i editing the wrong file, perhaps?
how would i know which is the correct pg_hba.conf file?
locate pg_hba.conf seems to give me a few results.
View 3 Replies
View Related
Jun 10, 2008
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).
View 14 Replies
View Related
Jul 6, 2007
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"
View 14 Replies
View Related
Nov 10, 2008
How to dump all relaying email?
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:
View 4 Replies
View Related
Dec 5, 2007
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.
View 1 Replies
View Related
Oct 3, 2007
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.
View 1 Replies
View Related
May 19, 2009
How to import mysql dump file to database by SSH?
How to import mysql database host to other host database by SSH?
View 4 Replies
View Related
Jun 9, 2008
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?
View 1 Replies
View Related
Feb 2, 2015
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.
View 3 Replies
View Related
Jun 28, 2009
How does one dump the contents of a Qmail?
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?
View 3 Replies
View Related
Jun 19, 2014
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
View 9 Replies
View Related
Oct 24, 2014
Beginning with today, all Backups to FTP repository failed. Even updates being started manually fail.
FTP Space is not full, there are still app. 400GB free space left.
I was also able to do a ftp upload on terminal using ftp client.
Server is accessible, credentials are right, but backup fails.
Why backup stops working after having done login.
This are the last few lines of the current psadump.log (removed server url and username):
[2014-10-24 13:38:46.754|17907] INFO: Repository 'ftps://[XXX]//as/': Initializing...
[2014-10-24 13:38:46.754|17907] INFO: Transport: Get repository transport ftps://[XXX]//as/
[2014-10-24 13:38:46.754|17907] INFO: Transport: Init credentials for user '[XXX]'
[2014-10-24 13:38:46.756|17907] INFO: Repository 'ftps://[XXX]//as/': Initialized
[2014-10-24 13:38:46.758|17907] INFO: pmm-ras finished. Exit code: 1
==============================
View 10 Replies
View Related
Jul 7, 2014
I have the last update (#6) but i have this message when i try to make a backup.
Error:
Runtime error: The check dump failed with code '1'. The dump can contain invalid data! at /opt/psa/admin/bin/plesk_agent_manager line 1022.
Error:
The dump have been invalidated by check-dump operation
What is this?
View 19 Replies
View Related
Nov 30, 2013
I've been seeing lots of the following error in my error_log recently, I've enabled core dumps and have managed to analyse one using gdb:
[Fri Nov 29 20:44:41.318847 2013] [core:notice] [pid 2307] AH00051: child pid 7504 exit signal Segmentation fault (11), possible coredump in /tmp/core-dump[Fri Nov 29 20:44:41.318937 2013] [core:notice] [pid 2307] AH00051: child pid 7623 exit signal Segmentation fault (11), possible coredump in /tmp/core-dump[Fri Nov 29 20:44:43.324859 2013] [core:notice] [pid 2307] AH00051: child pid 7724 exit signal Segmentation fault (11), possible coredump in /tmp/core-dump
View 2 Replies
View Related
Sep 5, 2014
generate crash dumps for apache 2.4.9 at the time freeze or crash in windows environment 2008 server R2.
View 2 Replies
View Related
May 26, 2015
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.
View 1 Replies
View Related
Jun 20, 2014
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!
Warning: domain "abc.com"
Cannot resume domain 'abc.com' (ErrorCode: 255, STDOUT [Error:].
View 4 Replies
View Related
Sep 25, 2012
I have an issue on a Plesk 11 Installation
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...
View 1 Replies
View Related
Jun 20, 2014
Ii got the following error during automatic Backup:
Unable to rotate dump: The dump rotation is failed with code '1' at /opt/psa/admin/bin/plesk_agent_manager line 1041.
I used Plesk Version 12.0.18. The Backup is created, but i following this error Message.
View 8 Replies
View Related
Dec 12, 2014
On our Centos 6.5 Vps with Plesk 12.0.18 the scheduled backup to a personal repository ftp fails every time with this error:
ERROR: () Unable to rotate dump: The dump rotation is failed with code '126' at /usr/local/psa/admin/bin/plesk_agent_manager line 1041.
ERROR: () Can't upload file 'clients/vorrei-cloud/domains/vorrei.org/backup_vorrei.org_info_1412130307.xml' to ftp. Error code: 1
On the target server there are nothing.
View 1 Replies
View Related
Jul 23, 2014
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] ....
View 6 Replies
View Related
Mar 5, 2015
I try to backup server and become error
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
View 19 Replies
View Related