Re: retoring a PostgreSQL database from one server to another

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.

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

Relevant Pages