Skip site navigation (1) Skip section navigation (2)

Re: Problems Restarting PostgreSQL Daemon

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems Restarting PostgreSQL Daemon
Date: 2008-07-26 19:41:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Wed, 23 Jul 2008, Andrej Ricnik-Bay wrote:

> Now there's an interesting piece of information :) How long
> ago did you upgrade it?


   I found the thread in the archives for June of this year.

   Re-reading the posted results of running initdb I tried a different
approach to starting the server. Instead of using pg_ctl I used 'postgres -D
/var/lib/pgsql/data &' (while logged in as user postgres, of course.) That
cleaned up a bad shutdown (when I had to reboot the system after it hung),
fixed the missing socket, and replaced the .pid. So, it's up and running
once again.

   My question is how best to modify the startup script so the postmaster
fires up when the system is rebooted. I don't see an option to 'su' to
specify the postgres user's password so I can script this. Have you any



Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<>     Voice: 503-667-4517      Fax: 503-667-8863

In response to


pgsql-general by date

Next:From: Tino WildenhainDate: 2008-07-26 19:43:39
Subject: Re: php + postgresql
Previous:From: Pavel StehuleDate: 2008-07-26 19:37:17
Subject: Re: how to remove the duplicate elements from an array?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group