Re: can't run on TCP/IP ports
On Sun, 4 Feb 2001, Patrick Raphael wrote:
When I attempt to run postmaster on a TCP/IP socket, I get the following
error:FATAL: StreamServerPort: bind() failed: Permission denied
Is another postmaster already running on that port?
If not, remove socket node (/var/run/postgresql/.s.PGSQL.5432)
and retry.
/usr/lib/postgresql/bin/postmaster: cannot create UNIX stream portThere is no other postmaster running, there is nothing in
/var/run/postgresql, nothing else is on port 5432(switching to another
port doesn't make a difference), I am logged on as user postgres, the
user postgres owns all files in the postgres home directory, and
postmaster works fine with UNIX domain sockets. Does anyone have any
other ideas what could be wrong? I am running Debian 2.2
Telnet to port 5432 and see if something answers. Are you running
something like portsentry or something that may be listening on it?
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
Import Notes
Reply to msg id not found: 3A7E127A.CBAF161A@vt.edu
Patrick Raphael <praphael@vt.edu> writes:
I figured out the problem, postmaster when run as postgres didn't have
write permissions to /var/run/postgresql directory (where the Debian
version puts its socket files) and therefore didn't have permission to
open the socket. .
ROTFL ... score one for the Debian package's gratuitously non-standard
placement of the sockets ...
(Nothing to do with you, Patrick, but this has been a sore spot for
awhile with some of us.)
regards, tom lane
Import Notes
Reply to msg id not found: 3A7E35AE.5CF1893F@vt.edu
I figured out the problem, postmaster when run as postgres didn't have
write permissions to /var/run/postgresql directory (where the Debian
version puts its socket files) and therefore didn't have permission to
open the socket. .
Vince Vielhaber wrote:
Show quoted text
On Sun, 4 Feb 2001, Patrick Raphael wrote:
When I attempt to run postmaster on a TCP/IP socket, I get the following
error:FATAL: StreamServerPort: bind() failed: Permission denied
Is another postmaster already running on that port?
If not, remove socket node (/var/run/postgresql/.s.PGSQL.5432)
and retry.
/usr/lib/postgresql/bin/postmaster: cannot create UNIX stream portThere is no other postmaster running, there is nothing in
/var/run/postgresql, nothing else is on port 5432(switching to another
port doesn't make a difference), I am logged on as user postgres, the
user postgres owns all files in the postgres home directory, and
postmaster works fine with UNIX domain sockets. Does anyone have any
other ideas what could be wrong? I am running Debian 2.2Telnet to port 5432 and see if something answers. Are you running
something like portsentry or something that may be listening on it?Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
Patrick Raphael wrote:
I figured out the problem, postmaster when run as postgres didn't have
write permissions to /var/run/postgresql directory (where the Debian
version puts its socket files) and therefore didn't have permission to
open the socket. .
What Debian version of postgresql? The installation should have set the
permissions on the directory to
drwxr-xr-x 2 postgres postgres 1024 Feb 3 21:11 /var/run/postgresql
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Lift up your heads, O ye gates; and be ye lift up, ye
everlasting doors; and the King of glory shall come
in. Who is this King of glory? The LORD strong and
mighty, the LORD mighty in battle."
Psalms 24:7,8
Import Notes
Reply to msg id not found: MessagefromPatrickRaphaelpraphael@vt.eduofSun04Feb2001191006-1000.3A7E35AE.5CF1893F@vt.edu | Resolved by subject fallback
Tom Lane wrote:
I figured out the problem, postmaster when run as postgres didn't have
write permissions to /var/run/postgresql directory (where the Debian
version puts its socket files) and therefore didn't have permission to
open the socket. .ROTFL ... score one for the Debian package's gratuitously non-standard
placement of the sockets ...
I beg to differ. I didn't jump in the last thread, but I believe
/var/run is a more safe and standard place than putting everything under
/tmp. There is a problem with that package, not a general problem of
policy.
--
Alessio F. Bragadini alessio@albourne.com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750
"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925