Re: Unable to user pg_restore

"Kumar" <sgnerd@yahoo.com.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