Re: Cannot restart the postmaster - Mailing list pgsql-general

From Rich Shepard
Subject Re: Cannot restart the postmaster
Date
Msg-id Pine.LNX.4.44.0202181905460.23682-100000@salmo.appl-ecosys.com
Whole thread Raw
In response to Cannot restart the postmaster  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Sun, 17 Feb 2002, Len Morgan wrote:

> I just had this problem a few hours ago.  It seems that the PG_VERSION file
> is the problem.  Some directories got moved, etc.  You might want to read
> the "Upgrading" section of the Upgrade-rpm-dist  I ended up removing either
> the base or the data directory and then the initdb worked (as did starting
> up postmaster).

Len,

  Yes, PG_VERSION -- both copies -- report 7.1. I've read
/usr/doc/postgresql-7.2/README.rpm-dist and didn't see anything about this
problem. There is plenty of information about saving existing databases
before upgrading, but not on the particular problem. Let me try removing a
directory ...

> Hope that helps

  Yup! That did it. I moved pg_hba.conf to a safe place, rm'd the complete
data/ directory and, as postgres, ran initdb. Voila! Moved pg_hba.conf back
and, as root, restarted the postmaster.

Many thanks! I'll save this message for the next time.

Rich

Dr. Richard B. Shepard, President

                       Applied Ecosystem Services, Inc. (TM)
            2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
 + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com
                         http://www.appl-ecosys.com



pgsql-general by date:

Previous
From: Richard Emberson
Date:
Subject: PL/pgsql UPDATE status
Next
From: Rich Shepard
Date:
Subject: Alternate database locations