On 1/2/06 3:04 pm, "Bruce Momjian" <pgman@xxxxxxxxxxxxxxxx> 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 passwords for each >> user/role? > > pg_dumpall should transfer your passwords too. Ah I see, I only did a pg_dump as I was just transferring one database to the new server for testing. Thanks for the help Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
