Re: backup-strategies for large databases

Hello

2011/8/26 Niyas <cmniyas(at)gmail(dot)com>:
> 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(at)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.

probably your data files are broken - you should to find a broken rows
and delete it.

probably SELECT * FROM tbl_voucher fails too?

Regards

Pavel Stehule

>
> 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.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>