Re: [GENERAL] Help: pg_restore failure

2011-04-15 Thread Edison So
Hello Adrian, Thank you for the reply. I will definitely give it a try on Monday. I am trying to use pg_dump command to backup up each table in the database and restore them one by one using the "-t" option. It is going to be a painful process because 8.1 pg_dump does not have the "exclude" opti

Re: [GENERAL] Help: pg_restore failure

2011-04-15 Thread Adrian Klaver
On 04/15/2011 01:15 PM, Edison So wrote: I have a DELL server running Windows server 2003 and Postgres 8.1. I used pg_dump to back up a database test: pg_dump -v -h localhost -p 5432 -U postgres -F c -b -f "D:/db_dump/backup.bak" test The backup was showing the following error. . pg_dump: dumpin