"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