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.

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to