Re: Postgres no longer starts - Mailing list pgsql-general

From Bart Lateur
Subject Re: Postgres no longer starts
Date
Msg-id 08ocs7d3ce3u51naa16050cvisdub69b2b@4ax.com
Whole thread Raw
In response to Postgres no longer starts  ("Bart Lateur" <bla@taxistop.be>)
Responses Re: Postgres no longer starts
Re: Postgres no longer starts
List pgsql-general
(Sorry if message threading is a bit off; I'm replying from a different
mail account as the previous post, so the "ref" header won't match.)

Well I tried

    /usr/bin/pg_ctl -D /var/lib/pgsql/data start -l /tmp/pglogfile

and it just says

    server starting

and then... nothing. It seems to quit immediately.

The logfile, /tmp/logfile exists, but is empty. (I noticed the previous
logfile, "pgstartup.log", was still the same and hadn't changed since a
few hours earlier, so the "modified" timestamp confirmed, so it wasn't
being updated any more.)

As where I did get the installer of Postgres for CentOS: I don't quite
remember the details, as it has been running well for several months.
But I got the idea from one of the many blog posts about it, such as
these:
http://blog.lystor.org.ua/2010/05/upgrading-postgresql-81-to-84-centos-55.html
http://www.if-not-true-then-false.com/2010/howto-install-postgresql-8-4-database-server-on-centos-fedora-red-hat/

I think it just comes from one of the unofficial CentOS repositories.

Like I said, it has been running well for months and the latest upgrade
was unrelated to PostGres.

It may have been some manual tweak I did a few weeks ago... PostGres
hadn't been restarted since then.

If  I knew what it was complaining about, I might be able to fix it.

I have already made a backup of the /var/lib/pgsql/data subdirectory, I
might just remove all of Postgres, and then reinstall.

Luckily this is a development machine, but as we don't know what causes
the problem we fear we might one day face the exact same problem where
it does matter: on a production machine. So we'd like to know exactly
what went wrong...

--
    Bart Lateur
    bart.lateur@telenet.be

pgsql-general by date:

Previous
From: Dave Bettin
Date:
Subject: 9.2 Range Types
Next
From: Merlin Moncure
Date:
Subject: Re: 9.2 Range Types