Bug 1090183 - Allow the init script instantiate multiple servers running on different IP's but listening on the same port
Summary: Allow the init script instantiate multiple servers running on different IP's ...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Software Collections
Classification: Red Hat
Component: postgresql
Version: rh-postgresql94
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: rc
: 2.0
Assignee: Jozef Mlich
QA Contact: Jakub Prokes
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-04-22 20:43 UTC by John Fulton
Modified: 2018-12-05 18:17 UTC (History)
3 users (show)

Fixed In Version: rh-postgresql94-postgresql-9.4.1-2.el6, rh-postgresql94-postgresql-9.4.1-2.el7
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-06-04 08:40:37 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
diff -u postgresql92-postgresql.dist postgresql92-postgresql > postgresql92.patch (399 bytes, patch)
2014-04-22 20:43 UTC, John Fulton
no flags Details | Diff


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHEA-2015:1055 0 normal SHIPPED_LIVE new packages: rh-postgresql94 2015-06-04 12:40:24 UTC

Internal Links: 996492

Description John Fulton 2014-04-22 20:43:29 UTC
Created attachment 888663 [details]
diff -u postgresql92-postgresql.dist postgresql92-postgresql > postgresql92.patch

Description of problem:

The postgresql init script is prepared to be copied (or symlinked) but
it has its local variable 'pidfile' defined like:

  pidfile="/var/run/postmaster.${PGPORT}.pid"

This makes the script differentiate lock files for separated instances just
based on the PGPORT.  If the PGPORT has the same value for more then one
postgres server, these init servers may not co-exist without additional changes
of the script.

The 'pidfile' variable should be ideally defined before sourcing per-instance
configuration file and reuse ${NAME} variable somehow. The attached
patch file could be useful. 

Version-Release number of selected component (if applicable):
* postgresql92-postgresql-server-9.2.7-2.el6 provides postgresql92-postgresql 

How reproducible:
* it is the default behaviour

Additional info:
* Bug 996492 also documented this but the customer with this problem is now experiencing it with Software Collections hence this bug.

Comment 2 Honza Horak 2014-04-23 10:55:05 UTC
Now it's too late for RHSCL-1.1, so moving to RHSCL-1.2.

Comment 7 errata-xmlrpc 2015-06-04 08:40:37 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHEA-2015-1055.html


Note You need to log in before you can comment on or make changes to this bug.