Bug 48924 - /etc/rc.d/init.d/rhdb does not start postgres with TCP/IP enabled
Summary: /etc/rc.d/init.d/rhdb does not start postgres with TCP/IP enabled
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat Database
Classification: Red Hat
Component: configuration (Show other bugs)
(Show other bugs)
Version: 7.1
Hardware: i386 Linux
medium
medium
Target Milestone: ---
Assignee: Liam Stewart
QA Contact: Liam Stewart
URL:
Whiteboard:
Keywords:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2001-07-12 15:40 UTC by Patrick C. F. Ernzer
Modified: 2007-04-18 16:34 UTC (History)
0 users

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: ---


Attachments (Terms of Use)

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



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