Search Postgresql Archives

Re: backup-strategies for large databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux