Re: backup-strategies for large databases - Mailing list pgsql-general

From Niyas
Subject Re: backup-strategies for large databases
Date
Msg-id 1314352109031-4737573.post@n5.nabble.com
Whole thread Raw
In response to backup-strategies for large databases  (MirrorX <mirrorx@gmail.com>)
Responses Re: backup-strategies for large databases
Re: backup-strategies for large databases
List pgsql-general
Hi All,

I have some other issue related to taking backup of the database having
bigger size. I have been getting the
following errors

anil@ubuntu107:~/Desktop$ pg_dump -Uadmin -h192.168.2.5 dbname >
filename.sql

 pg_dump: Dumping the contents of table "tbl_voucher" failed:
PQgetCopyData() failed.
pg_dump: Error message from server: server closed the connection
unexpectedly This probably means the server terminated abnormally before or
while processing the request.

Due to this error i am not able to dump the database.

Pls advice me how to tackle this issue...

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/backup-strategies-for-large-databases-tp4697145p4737573.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Ondrej Ivanič
Date:
Subject: Re: Sort Method: external merge
Next
From: "Tomas Vondra"
Date:
Subject: Re: backup-strategies for large databases