Re: can't run on TCP/IP ports

Поиск
Список
Период
Сортировка
От Patrick Raphael
Тема Re: can't run on TCP/IP ports
Дата
Msg-id 3A7E35AE.5CF1893F@vt.edu
обсуждение исходный текст
Ответ на Re: can't run on TCP/IP ports  (Vince Vielhaber <vev@michvhf.com>)
Ответы Re: can't run on TCP/IP ports  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: can't run on TCP/IP ports  ("Oliver Elphick" <olly@lfix.co.uk>)
Список pgsql-general
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:
>
> 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 port
> >
> >
> > There 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
> ==========================================================================

В списке pgsql-general по дате отправления:

Предыдущее
От: "J.Goodleaf"
Дата:
Сообщение: Solaris 8 compilation errors
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: php & postgresql data type