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