Re: Backup roles / users

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