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
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
On Sep 22, 2006, at 3:20 AM, Alain Roger wrote:When i migrate my DB to another computer, should i recreate all roles manually ?either that or use this command to dump the roles as an SQL file you can feed into the new server. it will complain about trying to recreate the superuser, but that's