<html> <head> <style> P { margin:0px; padding:0px } body { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } </style> </head> <body> How I can do the redirect the stderror ? I'm sorry I'm just beginning with Postgresql and I don't have experience?! Thaks <HR id=stopSpelling> > Date: Wed, 28 Feb 2007 22:33:10 +0100 > From: szajmi@gmail.com > To: fedora-list@redhat.com > Subject: Re: retoring a PostgreSQL database from one server to another > > On 2/28/07, Beau BOB <man_55@hotmail.fr> wrote: > > 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 > > Are you doing the restore as the postgres user? > Also, it's useful to redirect stderror to a file when doing the > restore, so you can inspect it later. > > Andras > > -- > fedora-list mailing list > fedora-list@redhat.com > To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list <hr />Exprimez-vous en direct avec Windows Live Messenger ! <a href='http://imagine-msn.com/messenger/launch80/default.aspx?locale=fr-fr&source=joinmsncom/messenger' target='_new'>Windows Live Messenger !</a></body> </html>