Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and Users - Mailing list pgsql-admin

From Gareth Kirwan
Subject Re: pg_dump and Users
Date
Msg-id 00e301c2bbbc$eb4441c0$55eaa8c0@gbjk1
Whole thread Raw
In response to pg_dump and Users  ("Gareth Kirwan" <gbjk@thermeoneurope.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Gareth Kirwan"
Date:
Subject: pg_dump and Users
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: is it safe to change pg_type ?