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