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
