could not bind IPv4 socket
Importance: High
On Monday 04 May 2009 4:29:27 am Grzegorz Buś wrote:
> When I run separately start/stop commands I still get "could not bind
> socket" message:
>
> # service postgresql stop
> Stopping postgresql service:
On Monday 04 May 2009 4:29:27 am Grzegorz Buś wrote:
> When I run separately start/stop commands I still get "could not bind
> socket" message:
>
> # service postgresql stop
> Stopping postgresql service: [ OK ]
> # netstat -plunt | grep 5432
> # ps -A | grep postmas
not, wait a few
seconds and retry.
--
Kind Regards,
Grzegorz Bus
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Vladimir N. Indik
Sent: Monday, May 04, 2009 10:15 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
> > # cat /var/lib/pgsql/data/pgstartup.log
> > LOG: could not bind IPv4 socket: Address already in use
> > HINT: Is another postmaster already running on port 5432? If not,
> wait a
> > few seconds and retry.
>
> Did you heed the HINT and see if there is another instance of Postgres
> running?
Try this command separately.
# service postgresql stop
and then
# service postgresql start
On Воскресенье 03 мая 2009 23:01:24 Grzegorz Buś wrote:
> postgresql restart
> Stopping postgresql service: [ OK ]
> Starting postgresql service:
On Sunday 03 May 2009 12:01:24 pm Grzegorz Buś wrote:
> > listen_addresses gets set to the IP address of the server itself, the
> > IP address it is "listening" for input on. Since you're giving it a
> > remote address, that's why it can't create a socket to listen there.
> >
> > There is a second
> listen_addresses gets set to the IP address of the server itself, the
> IP address it is "listening" for input on. Since you're giving it a
> remote address, that's why it can't create a socket to listen there.
> There is a second file here, pg_hba.conf, that filters down who can
> connect t
Greg Smith wrote:
> Normal practice here is to set:
>
> listen_address='*'
>
> So that the server is remotely accessible from all of its interfaces,
> and then you can do all filtering of who can connect just via
> pg_hba.conf instead.
Just to expand on that:
listen_addresses is usually used i
On Thu, 30 Apr 2009, Grzegorz Bu? wrote:
listen_addresses = 'localhost,XXX.XXX.XXX.XXX'
where XXX.XXX.XXX.XXX is IP address of remote client that I want to be able to
use PostgreSQL server. Port is default.
listen_addresses gets set to the IP address of the server itself, the IP
address it i
