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 ignorable:
pg_dumpall --globals-only -U ${pguser} > users.sql
where pguser is defined as the postgres superuser you use.