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:47, Richard Lyons wrote:
> On Wednesday 04 September 2002 4:02, John Summerfield wrote:
> > On Wed, 4 Sep 2002 09:21, Sergio A. Kessler wrote:
> > > > Anyone refresh my memory what to do now?
> > >
> > > you did a pg_dumpall before updating, right ?
> >
> > As I recall, the RHL docs describe what to do if you didn't pg_dumpall
> first.
> > The data gets archived somewhere.
> The data are well and living in /var/lib/pgsql/data/base/XXXXXX/ (where
XXXXXX
> is the relevant dataset. The problem is to do with some change to pgsql, as
> I recollect. I just don't remember what the change was.
Oh! Horrible!
I've just found the answer at
http://www.postgresql.org/idocs/index.php?migration.html>
If your dump isn't up to date (mine isn't), you have to install the old
version of pgsql in another directory and do the final dump, making sure to
use a different port if the two versions are running simultaneously. Or
something like that.
--
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]/