[postgres no lnger launches

From: Alexander Reichstadt <lxr(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [postgres no lnger launches
Date: 2012-06-03 22:39:22
Message-ID: 7B441F95-7F8F-4270-8406-86AB3B952436@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

how do I troubleshoot postgres? It simply won't start any more. I cannot login, not locally nor remotely. I tried a couple of things without success.

bash-3.2$ ps -Ac | egrep postgres
bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl start -D /Library/PostgreSQL/9.1/data -l postgres.log
pg_ctl: another server might be running; trying to start server anyway
server starting
bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl start -D /Library/PostgreSQL/9.1/data -l postgres.log
pg_ctl: another server might be running; trying to start server anyway
server starting
bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl start -D /Library/PostgreSQL/9.1/data -l postgres.log
pg_ctl: another server might be running; trying to start server anyway
server starting
bash-3.2$ ps -Ac | egrep postgres

So sure enough that process claimed to might be starting does not end up being a process. Where do I look for what's actually going on?

This is the log output:
04.06.12 00:26:29,792 com.edb.launchd.postgresql-9.1: If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for.
04.06.12 00:26:29,792 com.edb.launchd.postgresql-9.1: The PostgreSQL documentation contains more information about shared memory configuration.
04.06.12 00:26:29,793 com.apple.launchd: (com.edb.launchd.postgresql-9.1[1260]) Exited with code: 1
04.06.12 00:26:29,793 com.apple.launchd: (com.edb.launchd.postgresql-9.1) Throttling respawn: Will start in 10 seconds
04.06.12 00:26:30,000 kernel: nstat_lookup_entry failed: 2

It respawns every ten seconds and fails. Now this installation has been running for a few weeks now without a hiccup. I tried to enable remote login, I might have screwed up the pg_hba.conf file. So I copied the same file from an installation of another server I have on which things are running ok. I restarted but it continues to throw up those respawn messages and shared mem segmets stuff.

I changed the sysctl.conf file, but this neither made a difference. This unit has loads of memory....actually the messages seem to be rather bogus. Also, it worked fine, I didn't change the sysctl file before, it seems silly to assume that it just changes itself out of the blue and stops working. I installed nothing, there is no source I can assume to have done so. What can I do to make this server working again?

Thanks
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Reichstadt 2012-06-03 23:03:46 Re: [postgres no lnger launches
Previous Message Alexander Reichstadt 2012-06-03 21:23:16 Re: SELECT issue with references to different tables