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

From Tomas Vondra
Subject Re: backup-strategies for large databases
Date
Msg-id 335f1c80d824a5bbfd1be41c4f103ca8.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: backup-strategies for large databases  (Niyas <cmniyas@gmail.com>)
Responses Re: backup-strategies for large databases
List pgsql-general
On 26 Srpen 2011, 11:48, Niyas wrote:
> 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...

This is usually caused by backend crash - you need to check the server log
for more details.

Tomas


pgsql-general by date:

Previous
From: Niyas
Date:
Subject: Re: backup-strategies for large databases
Next
From: Martín Marqués
Date:
Subject: Re: passing cursors from one PL function to another