Re: retoring a PostgreSQL database from one server to another

[Andras Simon]

On 2/28/07, Bruno Wolff III  wrote:
> On Wed, Feb 28, 2007 at 22:33:10 +0100,
>   Andras Simon  wrote:
> > On 2/28/07, Beau BOB  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.

You're right, sorry for the noise!

Andras