Re: retoring a PostgreSQL database from one server to another

[Andras Simon]

On 2/28/07, Bruno Wolff III <bruno(a)wolff.to&gt; wrote:
>  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.
>  
You're right, sorry for the noise!

Andras