From: | Alexander Reichstadt <lxr(at)mac(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [postgres no lnger launches |
Date: | 2012-06-03 23:03:46 |
Message-ID: | 145C7CA4-35E1-43FB-A2F1-D814D37514EF@mac.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Btw, this is OSX 10.7.
Am 04.06.2012 um 00:39 schrieb Alexander Reichstadt:
> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-06-03 23:16:36 | Re: [postgres no lnger launches |
Previous Message | Alexander Reichstadt | 2012-06-03 22:39:22 | [postgres no lnger launches |