On Wed, Feb 28, 2007 at 22:33:10 +0100,
Andras Simon <szajmi(a)gmail.com> wrote:
On 2/28/07, Beau BOB <man_55(a)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.