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