Re: [GENERAL] Passwords when changing users -> roles

2006-02-01 Thread Adam Witney
On 1/2/06 3:04 pm, "Bruce Momjian" wrote: > Adam Witney wrote: >> >> Hi, >> >> I'm upgrading from 7.4.x to 8.1.x and I need to move my usernames over to >> the new roles. I can create the roles ok, but is there a way of transferring >> over the existing passwords, or do I have to create new pas

Re: [GENERAL] Passwords when changing users -> roles

2006-02-01 Thread Bruce Momjian
Adam Witney wrote: > > Hi, > > I'm upgrading from 7.4.x to 8.1.x and I need to move my usernames over to > the new roles. I can create the roles ok, but is there a way of transferring > over the existing passwords, or do I have to create new passwords for each > user/role? pg_dumpall should tran

[GENERAL] Passwords when changing users -> roles

2006-02-01 Thread Adam Witney
Hi, I'm upgrading from 7.4.x to 8.1.x and I need to move my usernames over to the new roles. I can create the roles ok, but is there a way of transferring over the existing passwords, or do I have to create new passwords for each user/role? Thanks for any help adam -- This message has been s