restoring a PostgreSQL database from one server to another

[Beau BOB <man_55 hotmail fr>]

about my problem, 
when I run my command to restoring , I saw many error about the relation, and at the final I can't found the pg_catalog.pg_user, can anybody help me to create it,
thanks
 
 

Hi,
 
I have postgresql 7.4.1 and I'm restoring to another server that has postgresql 7.4.6
 
for dumping I'm using :
pg_dumpall --clean -h localhost -U postgres -p 5432 > dbfile
 
and for restoring I use many methods:
psql -h localhost -U postgres -d template1 -f dbfile
 
and I have this error message when I run the PgAdminIII to connect my data base:
"error relation pg_settings not found " & " error relation pg_user not found"
 
and when I use the commands:
psql -l 
ERROR:  relation "pg_catalog.pg_user" not found
 
notice that when I make restore , I have many error message about missing relation ;
 
please can anybody help me to resolv my problem
thanks for advance

---

Exprimez-vous en direct avec Windows Live Messenger ! Windows Live Messenger !