I forgot to add that I used the command for restore:
psql -f <backup.db
Thanks
Mousa
_____
From: Shaya Mousa (Nokia-ES/Boston)
Sent: Tuesday, October 26, 2004 11:42 AM
To: 'pgsql-general(at)postgresql(dot)org'
Subject: Restore problem
I have created a backup file using pg_dumpall.
When I try to restore to new database the tables are created but data is
not loaded into any tables.
I am attaching my backup file.
Thanks
Mousa