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