Restoring 1.5GB SQL Dump (Postgres)

Jan 23, 2007

This seemed like the most appropriate place so I decided to post here.

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:

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


Postgres: Restoring A Filesystem Backup

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:

[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.

[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

Plesk 12.x / Linux :: Unable To Rotate Dump - The Dump Rotation Is Failed With Code 121

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:

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

Postgres Install

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

Running Postgres

Feb 20, 2008

I have installed postgres over my cpanel account but I am unable to find file

I am running Centos 4 Apache 1.3 PHP 4.3 Postgres 7.3

View 4 Replies View Related

Cannot Add Postgres Database

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

I've already compiled apache after postgres was upgraded months ago.

I'm using cpanel 10x

View 1 Replies View Related

Cron As Postgres User Not Working

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:

postgres@myhost:~$ crontab -e
And here's the cron:

* * * * * /usr/bin/pg_dump -D warranty_1_6_test | gzip -c > /var/www/test/postgres/backup$(date +"%Y%m%d_%H%M").tar.gz


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

IDENT Authentication Failed For Postgres. Pg_hba.conf

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:

$ su postgres
$ psql service_2_3
and i recieved the following error:

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:



# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all ident sameuser
# IPv6 local connections:
host all all ::1/128 ident sameuser
host all all password

and reloaded with (as user postgres):

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

Should I Dump My Host For 1&1

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

Copying Whole Dump Over Ssh

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

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

How To Dump All Relaying Email?

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

Core Dump Files

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

CPLinks Categories SQL Dump

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

How To Import Mysql Dump File To Database By SSH

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

Mysql Database Dump (150mb) Utf8

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

Plesk 12.x / Linux :: Backup Fails During Dump?

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

Command(s) For Telling Qmail To Dump All Emails In Queue?

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

Apache :: How To Create Dump File For Crash In Windows

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 : 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 ( from XX.XXX.XX.XX (), referer:

View 9 Replies View Related

Plesk 12.x / Linux :: Backup Does Not Write Dump To FTP Repository

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

Plesk 12.x / Linux :: Backup - Dump Can Contain Invalid Data

Jul 7, 2014

I have the last update (#6) but i have this message when i try to make a backup.

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.

The dump have been invalidated by check-dump operation

What is this?

View 19 Replies View Related

Apache CentOS Crash - Core Dump Analysis And Backtrace

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

Apache :: Generate Crash Dump In Windows 2008 Server R2

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

Plesk 12.x / Linux :: Error 505 Bad Gateway - When Importing SQL Dump Via PHPMyAdmin

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.", 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

Plesk 12.x / Linux :: Backup Errors - Dump Rotation Failed

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 ""

The domain '' may be inaccessible after backup. Please, resume it manually!

Warning: domain ""

Cannot resume domain '' (ErrorCode: 255, STDOUT [Error:].

View 4 Replies View Related

Plesk 11.x / Windows :: Unable To Find Backup Dump Object

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
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

Plesk 12.x / Linux :: Error During Automatic Backup - Unable To Rotate Dump

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

Plesk 12.x / Linux :: FTP Backup Fails Error - Unable To Rotate Dump

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/' to ftp. Error code: 1

On the target server there are nothing.

View 1 Replies View Related

Plesk 12.x / Windows :: After Upgrade Unable To Dump IP Addresses For Mail Service

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="" 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

Plesk 12.x / Linux :: Server Backup Failed - Could Not Run Make Dump With Pmmcli

Mar 5, 2015

I try to backup server and become error

# 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/ line 1060.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/ line 78.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/ line 161.
Runtime error: Could not run make dump with pmmcli[Illegal seek]

# /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/", line 21, in <module>
import pmmcli_session
File "/usr/local/psa/admin/share/pmmcli/", line 15, in <module>
import pmm_migration_handler
File "/usr/local/psa/admin/share/pmmcli/", 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

Copyrights 2005-15, All rights reserved