Search Postgresql Archives

Re: Upgrade Problem: 7.4.3 -> 8.1.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux