Basing on the way you did the pg_dump (without the -C option), I think you should have created the database before you performed the pg_restore,
You can see some examples of database backup/restore in this page: http://nediam.com.mx/en/tips/backups_pgsql.php Regards, Javier On Mon, 6 Feb 2006 10:54:27 +0530, surabhi.ahuja wrote > i am trying to do : > > pg_dump -f op.tar -F t database_name > > then i do > > dropdb database_name > > and then i do pg_restore op.tar > > and when i do psql database_name > > it says database does not exist. > > where am i going wrong? > > thanks, > > regards > > Surabhi -- nediam.com.mx ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
