On Wed, 18 Jun 2008, Andrew Sullivan wrote:
Did you use a non-ascii dump format? Try
Andrew, Not by design.
psql -U postgres -f pg814data.sql
Well! That stirred things up. I seem to have restored the accounting data (and the other databases in the cluster), but cannot access them. As a user, if I type 'psql aesi [Enter]', I'm connected to the database, and aesi-# \d lists all the tables. So, I assume that the restoration worked as intended. But, when I point firefox to http://localhost/sql-ledger/login.pl and try to log in, I get a server error. It's in /var/log/apache/error.log, so that's where I need to start fixing what broke. Thanks to everyone here. I think the upgrade has finally been successful. I learned a lot, and will try to make the next upgrade both much sooner and more smooth. Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863