| From: | "Gareth Kirwan" <gbjk(at)thermeoneurope(dot)com> |
|---|---|
| To: | <gbjk(at)thermeoneurope(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_dump and Users |
| Date: | 2003-01-14 11:05:52 |
| Message-ID: | 00e301c2bbbc$eb4441c0$55eaa8c0@gbjk1 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
How does pg_dumpall sound ?
-----Original Message-----
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(at)thermeoneurope(dot)com
Tel: +44 (0) 1293 864 303
Thermeon Europe e-Card: gbjk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah. | 2003-01-14 11:24:24 | is it safe to change pg_type ? |
| Previous Message | Gareth Kirwan | 2003-01-14 10:48:56 | pg_dump and Users |