On Sun, Jun 03, 2007 at 12:50:51AM -0400, Scott Gifford wrote: > Douglas Allan Tutty <[EMAIL PROTECTED]> writes: > > On Fri, Jun 01, 2007 at 12:07:23AM -0400, Scott Gifford wrote: > >> Postgres completely fell apart, and it took many hours to piece things > >> back together. > > > > Did you have a postgres dump just prior to the upgrade? In what way did > > it fall apart? What did you have to do to piece things back together; > > didn't restoring from the dump work? > > The data was OK, but it lost all the user accounts. It's been a few > months now and my memory is a bit hazy, but IIRC, the format of the > Postgres password file changed between versions.
I thought that a pg_dumpall would dump all the users with their passwords so that when the dump was run by the new version, the file would be created correctly from the data in the dump. I thought that was the whole reason for doing a pg_dump rather than just backing up the postgres home directory with it stopped. Doug. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
