Thread: pg_dump and Users

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