Thread: pg_dump, pg_restore
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
Did you check if your pg_restore was successful? I think you need to include the following option while using pg_dump & pg_restore -C, --create include/issue commands to create database On 2/6/06, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> 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
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