Re: [SQL] Unable to user pg_restore

2003-10-20 Thread Tom Lane
"Kumar" <[EMAIL PROTECTED]> writes: > $ pg_restore -d sampledbtest -f /home/db_repositorysampledb.sql.tar.gz -F c= > -v -c -O -h 192.128.2.51 -p 5432 -u > User name: postgres This is the wrong way to invoke pg_restore. "-f file" is an *output* file name. -d and -f are mutually contradictory opt

[SQL] Unable to user pg_restore

2003-10-20 Thread Kumar
Dear Friends,   I have created a compressed backup for the database - sampledb using the following $ pg_dump -h 192.128.2.51 -v -u -f /home/db_repository/sampledb20031020.sql.tar.gz wats -F c   while I try to restore this with the pg_restore function as follows $ pg_restore -d sampledbtest -