I'm restoring the database via the the postgres user, what do want me to do , is there any way to do it ?
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
_________________________________________________________________ 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