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@xxxxxxxxxxx> 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
