Re: [GENERAL] Backup roles / users

2006-09-22 Thread Vivek Khera 
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.sqlwhere pguser is defined as the postgres superuser you use.

smime.p7s
Description: S/MIME cryptographic signature

Re: [GENERAL] Backup roles / users

2006-09-22 Thread Matthias . Pitzl 
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 PROTECTED] 
  On Behalf Of Alain RogerSent: Friday, September 22, 2006 
  9:20 AMTo: pgsql-general@postgresql.orgSubject: 
  [GENERAL] Backup roles / usersHi,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

[GENERAL] Backup roles / users

2006-09-22 Thread Alain Roger 
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