<html> <head> <style> P { margin:0px; padding:0px } body { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } </style> </head> <body> I'm restoring the database via the the postgres user, what do want me to do , is there any way to do it ? <HR id=stopSpelling> > Date: Wed, 28 Feb 2007 15:42:44 -0600 > From: bruno@wolff.to > To: szajmi@gmail.com > CC: fedora-list@redhat.com > Subject: Re: retoring a PostgreSQL database from one server to another > > On Wed, Feb 28, 2007 at 22:33:10 +0100, > Andras Simon <szajmi@gmail.com> wrote: > > 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 > > > > > > > Are you doing the restore as the postgres user? > > That is what the -U option to psql specifies. So it looks like he is. > > -- > 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>