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