pg_dumpall (postgresql v 7.0.3) - Mailing list pgsql-general

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