Home > mailing lists

pg_dump and Users - Mailing list pgsql-admin

From	Gareth Kirwan
Subject	pg_dump and Users
Date	January 14, 2003 08:47:14
Msg-id	00dc01c2bbba$8a589ed0$55eaa8c0@gbjk1 Whole thread Raw
Responses	Re: pg_dump and Users ("Gareth Kirwan" <gbjk@thermeoneurope.com>)
List	pgsql-admin

Hey everyone,

Just a quicky...

I need to dump a database completely while a system is re-installed.. and then reload it afterwards.

I'm planning on using

pg_dump -C database > Flatfile

pgsql -d database -f Flatfile

But this doesn't account for the handling of users and user creation.

Can anyone tell me how I should be doing this ?

Cheers

Gareth Kirwan
Programming & Development,
Thermeon Europe Ltd,
gbjk@thermeoneurope.com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk

From: Bruno Wolff III
Date: 14 January 2003, 05:00:38
Subject: Re: Grants on creating tables..

From: "Gareth Kirwan"
Date: 14 January 2003, 09:04:09
Subject: Re: pg_dump and Users