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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] 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 ?