Re: [GENERAL] Backup roles / users

[Matthias . Pitzl]

Title: Nachricht

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 9:20 AM
To: pgsql-general@postgresql.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