Bug 48924

Summary: /etc/rc.d/init.d/rhdb does not start postgres with TCP/IP enabled
Product: Red Hat Database Reporter: Patrick C. F. Ernzer <pcfe>
Component: configurationAssignee: Liam Stewart <liams>
Status: CLOSED NOTABUG QA Contact: Liam Stewart <liams>
Severity: medium Docs Contact:
Priority: medium    
Version: 7.1   
Target Milestone: ---   
Target Release: ---   
Hardware: i386   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2001-07-12 15:40:33 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Patrick C. F. Ernzer 2001-07-12 15:40:30 UTC
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2) Gecko/20010701

Description of problem:
As postgres is started without TCP/IP enabled, the tools that connect to
the DB via TCP/IP will fail.

How reproducible:
Always

Steps to Reproduce:
1. install rhdb
2. create a database with psql
2. launch pgaccess to have a graphical view of this DB

	

Actual Results:  pgaccess cannot connect to the DB.

Expected Results:  A tool referenced in the manual (Administrator and
User's Guide, Utilities Reference) should work out ouf the box.

Additional info:

[pcfe@begot rhdb]$ diff rhdb.orig rhdb
181c181
<               su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl  -D $PGDATA
-p /usr/bin/postmaster start  > /dev/null 2>&1" < /dev/null
---
>               su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl  -o "-i" -D
$PGDATA -p /usr/bin/postmaster start  > /dev/null 2>&1" < /dev/null

Comment 1 Liam Stewart 2001-07-12 17:47:00 UTC
Users should turn on TCP/IP socket use through the postgresql.conf file, located
in data clusters
(in /var/lib/pgsql/data for Red Hat Database 7.1) by setting

tcpip_socket = true