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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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.lists@enterprisedb.com>wrote:

On Wed, Apr 14, 2010 at 8:15 PM, Alex Soto Paez <
ALEJANDRO.SOTO666@gmail.com> wrote:

The following bug has been logged online:

Bug reference: 5423
Logged by: Alex Soto Paez
Email address: ALEJANDRO.SOTO666@GMAIL.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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.lists@enterprisedb.com>wrote:

On Wed, Apr 14, 2010 at 8:15 PM, Alex Soto Paez <
ALEJANDRO.SOTO666@gmail.com> wrote:

The following bug has been logged online:

Bug reference: 5423
Logged by: Alex Soto Paez
Email address: ALEJANDRO.SOTO666@GMAIL.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs