Hello
2011/8/26 Niyas <cmniyas@gmail.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@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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>