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 transfer your passwords too. -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073