restoring a PostgreSQL database from one server to another

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--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

Relevant Pages

  • Re: restore question
    ... If the partition table is intact, you don't need to create a new one. ... lots of times people are restoring because a disk has failed ... Sometimes it's easier to type out each command separately, ... I just wrote it as a "for" loop because this is easier ...
    (comp.unix.solaris)
  • Re: [opensuse] Disaster Recovery Options
    ... but, like most, not such a good job of restoring. ... As a shop owner, I can tell you that rsync, or the tools built on it like rsnapshot, are the only way to go in my opinion. ... If you don't mind writing a 1-5 line bash script containing the rsync command and adding the script to crontab, ...
    (SuSE)
  • Re: Problems trying to get msmdarch.exe to work.
    ... like msmdarch.exe does some weird processing before restoring the database. ... > I'm having a hard time trying to figure out what the correct syntax is ... > for the msmdarch.exe command to restore a database. ...
    (microsoft.public.sqlserver.olap)
  • VDUMP AND DUMP COMMANDS - CANNOT RESTORE FILESYSTEM
    ... I have a problem with dumping and restoring a filesystem. ... I seem to be having sporatic results with the vdump and vrestore ... The backup seems to be succesful but when I try to do a vrestore I get ... I need to get a valid backup - so I attempted use the dump command: ...
    (Tru64-UNIX-Managers)