restoring a PostgreSQL database from one server to another

Beau BOB man_55 at hotmail.fr
Wed Feb 28 15:40:18 UTC 2007


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 problemthanks for advance 
_________________________________________________________________
Essayez Live.com, votre nouvelle page d'accueil ! Personnalisez-la en quelques clics pour retrouver tout ce qui vous intéresse au même endroit.
http://www.live.com/getstarted
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20070228/a2f75e41/attachment-0001.htm>


More information about the fedora-list mailing list