From: | Matthias(dot)Pitzl(at)izb(dot)de |
---|---|
To: | raf(dot)news(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Backup roles / users |
Date: | 2006-09-22 07:42:40 |
Message-ID: | 11EC9A592C31034C88965C87AF18C2A70CFC63@m0000s61 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Alain!
To get all the users and so on to the other machine, you have to use the
pg_dumpall tool with the -g switch. This will dump out all the users, groups
and roles i think.
-- Matthias
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 9:20 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Backup roles / users
Hi,
I've checked in pg_dump and i did not find anything regarding backuping
roles ?
When i migrate my DB to another computer, should i recreate all roles
manually ?
thx.
Alain
From | Date | Subject | |
---|---|---|---|
Next Message | Matthias.Pitzl | 2006-09-22 07:53:00 | Re: Strange database corruption with PostgreSQL 7.4.x o |
Previous Message | Alain Roger | 2006-09-22 07:20:23 | Backup roles / users |