Re: backup-strategies for large databases

From: Niyas <cmniyas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: backup-strategies for large databases
Date: 2011-08-26 09:48:29
Message-ID: 1314352109031-4737573.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-08-26 09:52:25 Re: backup-strategies for large databases
Previous Message Bruce Momjian 2011-08-26 04:18:55 Re: [GENERAL] pg_upgrade problem