Hi -
I am trying to backup (and then restore) the database on a server.
I am using PostgreSQL v 7.0.3
To dump the data I am using :
pg_dumpall -o databasename > database.dmp
And then, when I want to restore :
psql -d databasename -f database.dmp
The thing is that, although in the database.dmp there is a sql command
like :
CREATE TABLE mytable .......
after restoring the database the table mytable is not created !
And there are more then one tables missing.
Could please someone tell me what might be causing this ?
Thank you
Carmen