Re: Unable to user pg_restore

"Kumar" <sgnerd(at)yahoo(dot)com(dot)sg> 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 options ... not sure
why the thing doesn't complain about that. What you want is just

pg_restore -d sampledbtest -v -c -O -h 192.128.2.51 -p 5432 -u inputfilename

Depending on whether -d or -f takes precedence, the program might have
tried to overwrite your dump file; better check.

regards, tom lane