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
Alias: None
Product: Red Hat Database
Classification: Red Hat
Component: configuration
Version: 7.1
Hardware: i386
OS: Linux
Target Milestone: ---
Assignee: Liam Stewart
QA Contact: Liam Stewart
Depends On:
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

Clone Of:
Last Closed: 2001-07-12 15:40:33 UTC

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:

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