Re: backup-strategies for large databases

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