Upgrade Problem: 7.4.3 -> 8.1.2

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrade Problem: 7.4.3 -> 8.1.2
Date: 2006-01-19 20:59:40
Message-ID: Pine.LNX.4.63.0601191244280.10345@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It's time for me to stop procrastinating and upgrade postgres from -7.4.3
to -8.1.2. Unfortunately, I think that I got it wrong. Here's what I did on
my Slackware-10.2 box:

1) cd to /usr/local/pgsql
2) su'd to postgres
3) ran 'pg_dumpall'
4) as root, ran 'upgradepkg slackware-8.1.2*.tgz'
5) as root, ran '/etc/rc.d/rc.postgresql stop'
6) as root, ran '/etc/rc.d/rc.postgresql start'; yes, there's a postmaster
process running.
7) back to /usr/local/pgsql; as postgres ran 'pg_restore'
8) I see nothing in the virtual terminal. The cursor sits on the following
line.

The only live data I have are the accounting data from SQL-Ledger. It
shouldn't take that long to restore it to the new version's directories.

What did I do wrong, and (most important!) how do I recover my data so I
can both continue to work in SL and get another web-based app running with
the postgres back end?

TIA,

Rich

--
Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental
Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic"
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2006-01-19 21:03:41 out parameters and SETOF
Previous Message Andreas Kretschmer 2006-01-19 20:57:52 Re: Replicating a remote database (backuping)