pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLAN connection to server only after restart server
3+ messages / 3 participants
[nested] [flat]
* LAN connection to server only after restart server
@ 2008-03-13 09:20 Pietro <bpietro@simail.it>
0 siblings, 2 replies; 3+ messages in thread
From: Pietro @ 2008-03-13 09:20 UTC (permalink / raw)
To: pgsql-admin
Hi,
I have strange behaviour on my LAN.
Postgresql server is up and running, accepting connection on default port.
Firewall is set well.
Connection from 'localhost' is OK.
Connection from another host on LAN is refused (sniffed with wireshark:
request ACK, response RST, ACK) and so application shows 'Can't connect
to DB server' and dies.
After restart Postgresql server, nota bene _WITHOUT_ changing any bit of
configuration files, all stuff work (connections from localhost and
connections from LAN too)
In /etc/rc5.d/ postgresql server is started after network and after firewall.
It isn't so serious problem for me, only boring one, because each morning
I must start server box and then manually restart posgresql server.
All boxes runs Mandriva 2008.0
Any clue?
Thanks in advance
Pietro
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: LAN connection to server only after restart server
@ 2008-03-13 12:46 Julio Leyva <jcleyva@hotmail.com>
parent: Pietro <bpietro@simail.it>
1 sibling, 0 replies; 3+ messages in thread
From: Julio Leyva @ 2008-03-13 12:46 UTC (permalink / raw)
To: Pietro <bpietro@simail.it>; pgsql-admin
double check pg_hba.conf
> From: bpietro@simail.it
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] LAN connection to server only after restart server
> Date: Thu, 13 Mar 2008 10:20:07 +0100
>
> Hi,
>
> I have strange behaviour on my LAN.
>
> Postgresql server is up and running, accepting connection on default port.
> Firewall is set well.
> Connection from 'localhost' is OK.
> Connection from another host on LAN is refused (sniffed with wireshark:
> request ACK, response RST, ACK) and so application shows 'Can't connect
> to DB server' and dies.
>
> After restart Postgresql server, nota bene _WITHOUT_ changing any bit of
> configuration files, all stuff work (connections from localhost and
> connections from LAN too)
>
> In /etc/rc5.d/ postgresql server is started after network and after firewall.
>
> It isn't so serious problem for me, only boring one, because each morning
> I must start server box and then manually restart posgresql server.
>
> All boxes runs Mandriva 2008.0
>
> Any clue?
> Thanks in advance
>
> Pietro
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: LAN connection to server only after restart server
@ 2008-03-13 15:31 Tom Lane <tgl@sss.pgh.pa.us>
parent: Pietro <bpietro@simail.it>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2008-03-13 15:31 UTC (permalink / raw)
To: Pietro <bpietro@simail.it>; +Cc: pgsql-admin
Pietro <bpietro@simail.it> writes:
> It isn't so serious problem for me, only boring one, because each morning
> I must start server box and then manually restart posgresql server.
There must be something different between what you do manually and what
the init script does ... better take a closer look at that script.
> All boxes runs Mandriva 2008.0
If you were running Red Hat I'd also stop to take a look at the SELinux
configuration, because with RH's default policy there are restrictions
that are enforced against init-started daemons but not against
manually-started programs. Does Mandriva have/use SELinux?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-03-13 15:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-13 09:20 LAN connection to server only after restart server Pietro <bpietro@simail.it>
2008-03-13 12:46 ` Julio Leyva <jcleyva@hotmail.com>
2008-03-13 15:31 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox