pg_dump and Users

From: "Gareth Kirwan" <gbjk(at)thermeoneurope(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump and Users
Date: 2003-01-14 10:48:56
Message-ID: 00dc01c2bbba$8a589ed0$55eaa8c0@gbjk1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Gareth StationeryHey 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(at)thermeoneurope(dot)com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gareth Kirwan 2003-01-14 11:05:52 Re: pg_dump and Users
Previous Message GB 2003-01-14 09:33:44 Failed to initialize lc_messages to ''