Re: BUG #5423: problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initiate the connecti

On Thu, Apr 15, 2010 at 6:35 PM, Geoffrey Pitman
<geoffrey(dot)pitman(at)gmail(dot)com>wrote:

Offlist reply posted back to list.

How did you perform your install? (I think you're running Ubuntu 9.10).
>
> Did you use the repositories, or did you build it from source?
>
> If you used the Ubuntu repositories, have you checked the Community guide?
> Located here:
>
> https://help.ubuntu.com/community/PostgreSQL
>
> The version data (in the guide) is not up-to-date, but you can always do an
> aptitude search postgre at the CLI to find the appropriate version number.
>
> Also, it might not be on port 5432; I've seen some funky installs with
> Ubuntu that put Postgre on 5433. You might want to check that? (though that
> wouldn't be directly related to your reported issue) which is more likely a
> permissions issue, or you're not launching the server as root--either via a
> secondary script or maybe your init.rc script is wrong?
>
>
>
> On Thu, Apr 15, 2010 at 8:51 AM, Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>wrote:
>
>>
>> On Wed, Apr 14, 2010 at 8:15 PM, Alex Soto Paez <
>> ALEJANDRO(dot)SOTO666(at)gmail(dot)com> wrote:
>>
>>>
>>> The following bug has been logged online:
>>>
>>> Bug reference: 5423
>>> Logged by: Alex Soto Paez
>>> Email address: ALEJANDRO(dot)SOTO666(at)GMAIL(dot)COM
>>> PostgreSQL version: 8.4
>>> Operating system: linux 9.10
>>> Description: problems installing postgresql-8.4 deleted folder /
>>> .s.PGSQL.lock not initiate the connecti
>>> Details:
>>>
>>> problems installing postgresql-8.4 deleted folder / var / run /
>>> postgresql /
>>> .s.PGSQL.lock not initiate the connection to port 5432
>>>
>>> when installing postgresql-8.4 is installed correctly while running the
>>> command:
>>>
>>> $ Service postgresql-8.4 status
>>>
>>> Published online defautl port 5432, but at reboot the machine no longer
>>> seems in line appears down and restart the server payable are parachute
>>> with
>>> the error:
>>>
>>>
>>> $sudo /ect/init.d/postgresql-8.4 restart
>>>
>>> The PostgreSQL server failed to start. Please check the log output:
>>> 2010-04-14 18:48:24 CDT FATAL: could not lock file </ var / run /
>>> postgresql
>>> / .s.PGSQL.lock>>: no such file? directory
>>>
>>>
>>> [Fail]
>>>
>>> run and hand it to guide the pid file and everything goes well but when
>>> you
>>> see another restart the computer I get the same error described above.
>>> not
>>> save the folder with the Pid and does not connect to port 5432
>>>
>>> Someone can help me
>>>
>>> In advance thank you very much.
>>>
>>>
>> Does the '/var/run/postgresql' directory exist and is it writeable by the
>> postgres user? If it is not, I would say it's a bug for the packager of
>> this install of postgres. Typically, postgres puts its lock / sockets in
>> '/tmp'. You say linux, but don't say which linux, by your version string
>> (9.10) I'm guessing that this is ubuntu?
>>
>> --Scott
>>
>>
>>
>>
>>> --
>>>
>>> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-bugs
>>>
>>
>>
>