Re: retoring a PostgreSQL database from one server to another

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux