Re: upgraded postgresql - bother! can't find the thread
Richard Lyons <[email protected]>
| Newsgroups | gmane.comp.web.sql-ledger.user |
|---|---|
| Organization | the-place |
| Message-ID | <[email protected]> |
On Wednesday 04 September 2002 8:49, Maanus Kask wrote: > On Wed, 4 Sep 2002 01:24:50 +0100 > Richard Lyons <[email protected]> wrote: > > > I know this has been discussed here before, but I can't find it. I > > upgraded from RH7.1 to RH7.3, and it upgraded postgresql without > > asking me. Now when I try to log on, I get [snip] > When you upgrade to PostgresSQL 7.2.1 it will make backups of your old > PostgresSQL binarys. I had them in /usr/lib/pgsql/backup/, what you need > to do is cd to this directory and run postmaster from there e.g > "./postmaster -iD /var/lib/pgsql/data" and then ./pg_dumpall to a file, > after that you can delete /var/lib/pgsql/data (of cource you can make > backup first, in case anything goes wrong) and start postgresql service > normally (from /etc/init.d). My saviour! That worked perfectly (once I realized I had to start another shell for the ./pg_dumpall). The files are all neatly restored, and all I have to do now is remember how to sort the permissions and ownership to avoid Error! FATAL 1: IDENT authentication failed for user "postgres" > best regards > Maanus Kask > > P.S. As an alternative you can remove the new PostreSQL, install old > one, make pg_dumpall, upgrade again, edit dumpfile and restore > databases. That was the alternative I was getting geared up for. I'm glad I didn't have to do that. Thanks, Maanus -- richard ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/