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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
