RE: rsetoring a PostgreSQL database from one server to another

[Beau BOB <man_55 hotmail fr>]

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

---

Exprimez-vous en direct avec Windows Live Messenger ! Windows Live Messenger !