Re: [GENERAL] backup-strategies for large databases

2011-08-26 Thread Niyas
I also guessed the same at initial stage of debugging. So i tried to export the tbl_voucher data to a file and it works fine. Then i googled and found some link, its explaines the reason is higher size of the database. But didnt get any proper solution in the internet. -- View this message in con

Re: [GENERAL] backup-strategies for large databases

2011-08-26 Thread Niyas
Actually database is not crashed. I can run my application perfectly. -- View this message in context: http://postgresql.1045698.n5.nabble.com/backup-strategies-for-large-databases-tp4697145p4737697.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-ge

Re: [GENERAL] backup-strategies for large databases

2011-08-26 Thread Niyas
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() faile