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-----Hi,
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 9:20 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: [GENERAL] Backup roles / users
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
