Thread: Networking support for postgres isn't working.
Hi. I'm running version 7.1.3-2 of postgres on my RedHat7.1. Well, I would like to use gnome-db and it seems to not work because postgres is refusing network connections. I've made myhost available in the pg_hda.conf file but still nothing. Yet, I've been told that the postmaster should be initiated withthe -i option for network support. COnsidering that I installed the rpms for my distro I was wondering why the packagedversion I'm using isn't takeing care of using the -i option. Anyway, how can I tell the postmaster to start withthe -i option during boot time. Must I just add the -i option to all the postmaster call that come up in the /etc/rc.d/init.d/postgresqlfile? Thanks -- Antonio Gennarini Crecchio, CH - ITALY ----------------------------------- Earth Science student at University "G. D'Annunzio". Join th GNU generation, start from LINUX.
In file /etc/rc.d/init.d/postgresql, add the option -o -i to the pg_ctl that starts the postmaster (around line 152, pgsql 7.2; 125, 7.1). Ex postgresql 7.2: change: su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start > /dev/null 2>&1" < /dev/null to su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start -o -i > /dev/null 2>&1" < /dev/null Regards, Luciano Rocha -- Luciano Rocha, strange@nsk.yi.org The trouble with computers is that they do what you tell them, not what you want. -- D. Cohen