From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | Doug McNaught <doug(at)mcnaught(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgrade Problem: 7.4.3 -> 8.1.2 |
Date: | 2006-01-19 22:18:25 |
Message-ID: | Pine.LNX.4.63.0601191411330.20481@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 19 Jan 2006, Doug McNaught wrote:
> Did you tell pg_restore to read from a file? Otherwise it will try to
> read from your terminal, which probably isn't what you want.
Doug,
Here's what I have in /var/lib/:
drwxr-x--- 3 postgres postgres 104 2006-01-19 12:49 pgsql/
drwx------ 3 postgres root 72 2006-01-19 12:47 postgresql/
In pgsql/ there is a data/ directory which contains:
PG_VERSION pg_clog/ pg_multixact/ pg_twophase/
base/ pg_hba.conf pg_subtrans/ pg_xlog/
global/ pg_ident.conf pg_tblspc/ postgresql.conf
and PG_VERSION holds '8.1', with all directories and files having a
creation date of 2006-01-19.
In postgresql/ there is a data/ directory which contains:
PG_VERSION global/ pg_hba.conf pg_xlog/
base/ pg_clog/ pg_ident.conf postgresql.conf
This PG_VERSION also holds '8.1', but all the directories and files have a
creation date of 2004-12-05.
So, I assume that /var/lib/postgresql/data holds the 7.4.3 data files and
/var/lib/postgresql/data holds what should be the 8.1.2 data files.
What specific steps should I take to get the data into the new version so
that SQL-Ledger runs once again? Once I learn this it will be much easier for
me to keep current.
Thanks very much,
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2006-01-19 22:24:04 | Re: Upgrade Problem: 7.4.3 -> 8.1.2 |
Previous Message | Doug McNaught | 2006-01-19 22:16:48 | Re: Upgrade Problem: 7.4.3 -> 8.1.2 |