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 Archive is too short... greetings Maanus Begin forwarded message: ------------------------ Date: Wed, 22 May 2002 11:12:17 +0300 From: Maanus Kask <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: [SL] Upgrade to PostgresSQL 7.2 On Sat, 18 May 2002 11:33:22 +0100 Scott Taylor <[EMAIL PROTECTED]> wrote: > I have seen a lot of mail on upgrades, but didn't see any that > resolved the problem where you upgrade without doing the back up > first. I am in this position. > > I have SQL Ledger 1.8.2 and PostgresSQL 7.2.1 (upgraded from 7.1) on > Red Hat 7.3 (upgraded from 7.2). I had similar situation (only difference was sql-ledger 1.8.3). Reading manual pages and list history would help you :-) 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/, whta 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). You have to edit your backup file and remove quotes from all 'current_date' s (see John Christian Stoddart <[EMAIL PROTECTED]> email on 15 May 2002 14:25:25 -0400, thanks John) after this step you can restore all your tables and enjoy SQL Ledger. 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. ------------------------------------------------------- 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]/
