Thread: Networking support for postgres isn't working.

Networking support for postgres isn't working.

From
Antonio Gennarini
Date:
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.

Re: Networking support for postgres isn't working.

From
Luciano Miguel Ferreira Rocha
Date:
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