RE: 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(a)wolff.to>
> To: szajmi(a)gmail.com> CC: fedora-list(a)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(a)gmail.com&gt; wrote:> > On 2/28/07, Beau BOB
> <man_55(a)hotmail.fr&gt; 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(a)redhat.com&gt; 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