Re: [PLUG] postgres on RH EL 4

[Andrew Libby <andrew.libby@gmail.com>]

While I don't know specifically, the way I usually find these things
is to do something like:

(find out the postgres rpm name)

[alibby@localhost ~]$ rpm -qa|grep -i post
postgresql-jdbc-8.0.7-1.FC4.1
postgresql-pl-8.0.7-1.FC4.1
gnucash-backend-postgres-1.8.12-0.fc4
postgresql-docs-8.0.7-1.FC4.1
postgresql-python-8.0.7-1.FC4.1
postgresql-8.0.7-1.FC4.1
postgresql-server-8.0.7-1.FC4.1
postgresql-devel-8.0.7-1.FC4.1
postgresql-odbc-08.00.0100-1
postgresql-libs-8.0.7-1.FC4.1
postgresql-contrib-8.0.7-1.FC4.1

I'm thinking server is the right one (FC anyway):

(find something that looks like a config file)

[alibby@localhost ~]$ rpm -ql postgresql-server | grep conf
/etc/sysconfig/pgsql
/usr/share/pgsql/pg_hba.conf.sample
/usr/share/pgsql/pg_ident.conf.sample
/usr/share/pgsql/pg_service.conf.sample
/usr/share/pgsql/postgresql.conf.sample
/usr/share/pgsql/recovery.conf.sample

Another approach is to look in the postgresql start/ stop script
in /etc/init.d and try to chase it down that way.    Look for
the location of PGDATA.

Good luck.

Andy



Chad Waters wrote:

>Hi, I got an app that needs a tcp connection to postgres db on a Red
>Hat EL 4 machine.
>
>Preferably I'd like postgres to listen on the loopback only (127.0.0.1:5432).
>
>RH seems to have hidden the postgres conf file. Can someone clue me in?
>
>--
>-Chad C Waters
>___________________________________________________________________________
>Philadelphia Linux Users Group         --        http://www.phillylinux.org
>Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
>General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug
>
>  
>


-- 
Andrew Libby                                  
alibby@philadelphiariders.com
http://philadelphiariders.com/


___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug