Bug 115288

Summary:	postgres IP address binding
Product:	[openSUSE] SUSE LINUX 10.0	Reporter:	peter czanik <peter>
Component:	Network	Assignee:	Reinhard Max <max>
Status:	RESOLVED INVALID	QA Contact:	E-mail List <qa-bugs>
Severity:	Normal
Priority:	P5 - None
Version:	Beta 4
Target Milestone:	---
Hardware:	Other
OS:	All
Whiteboard:
Found By:	Other	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description peter czanik 2005-09-05 11:03:53 UTC

No matter, what I set in /var/lib/pgsql/data/postgresql.conf, postmaster always
binds to 0.0.0.0:5432

tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN     
8237/postmaster

Comment 1 Reinhard Max 2005-09-05 11:31:15 UTC

You must have added -i to POSTGRES_OPTIONS in /etc/sysconfig/postgresql , which
according to the postmaster(1) manpage is deprecated and equivalent to setting
listen_addresses to '*'.

When -i is not used, the postmaster binds only to the IP addresses given in the
listen_addresses parameter, and setting it empty (listen_addresses = '')
disables TCP access completely.

Comment 2 peter czanik 2005-09-05 11:38:14 UTC

Thanks, then README.SuSE for open-xchange is to be changed...

Comment 3 Reinhard Max 2005-09-05 11:59:37 UTC

Well, the listen_addresses parameter got added in PG 8.0. Previous versions were
either listening on all interfaces or not listening for TCP connections at all,
so there is no regression in security or functionality if you keep doing things
as the open-xchange README says.

BTW, does open-xchange even officially support PostgreSQL 8.0 yet? If not, 
README.SuSE is still correct for the version(s) of PostgreSQL it was written for.

Comment 4 peter czanik 2005-09-05 12:18:18 UTC

I suppose yes. At least editing /var/lib/pgsql/data/postgresql.conf and set
'localhost' there was mentioned in an OX wiki document. And all recent OX
HOWTO-s mention 8.0.