rsetoring a PostgreSQL database from one server to another

[Beau BOB]

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 at wolff.to> To: szajmi at gmail.com> CC: fedora-list at 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 at gmail.com> wrote:> > On 2/28/07, Beau BOB <man_55 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20070301/2b4e8f7b/attachment-0001.htm>