From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Correct pg_dumpall Syntax |
Date: | 2008-06-18 18:01:23 |
Message-ID: | Pine.LNX.4.64.0806181051210.10791@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2008-06-18 18:17:00 | Re: Understanding fsync (was: Need Help Recovering from Botched Upgrade Attempt) |
Previous Message | Sam Mason | 2008-06-18 17:49:15 | Re: Correct pg_dumpall Syntax |