Re: Correct pg_dumpall Syntax - Mailing list pgsql-general

From Rich Shepard
Subject Re: Correct pg_dumpall Syntax
Date
Msg-id Pine.LNX.4.64.0806181051210.10791@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Correct pg_dumpall Syntax  (Andrew Sullivan <ajs@commandprompt.com>)
List 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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Correct pg_dumpall Syntax
Next
From: Greg Smith
Date:
Subject: Re: Understanding fsync (was: Need Help Recovering from Botched Upgrade Attempt)