Red Hat Bugzilla – Bug 48924
/etc/rc.d/init.d/rhdb does not start postgres with TCP/IP enabled
Last modified: 2007-04-18 12:34:41 EDT
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
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