Bug 115288 - postgres IP address binding
Summary: postgres IP address binding
Status: RESOLVED INVALID
Alias: None
Product: SUSE LINUX 10.0
Classification: openSUSE
Component: Network (show other bugs)
Version: Beta 4
Hardware: Other All
: P5 - None : Normal
Target Milestone: ---
Assignee: Reinhard Max
QA Contact: E-mail List
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-09-05 11:03 UTC by peter czanik
Modified: 2005-09-05 12:18 UTC (History)
0 users

See Also:
Found By: Other
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.