Thread: getting postgres to listen to tcp/ip on debian.

getting postgres to listen to tcp/ip on debian.

From
bob mendoza
Date:
hey.

i'm using debian with the following configuration:

postgresql     7.1release-4
postgresql-cli 7.1release-4
postgresql-con 6.5.3-26
postgresql-doc 7.1release-4
postgresql-sli 6.3.2

and i want it to listen to on tcp/ip as well as the
defaul unix socket. the stuff i've read says that i
need to put the following in
/etc/postgresql/postmaster.init

PGALLOWTCPIP=yes
PGPORT=5432

it seems that the file listed above is no longer being
used in debian to configure postgres. so i thought i
would use the pg_hba.conf file instead. no luck. can
someone tell me where i have to put this informatoin?
i've used redhat in the past and all i had to do was
use the '-i' option when starting the postmaster.

the stuff in debian is a bit confusing. any help would
be appreciated.

thanks.
john




__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

Re: getting postgres to listen to tcp/ip on debian.

From
Andrew McMillan
Date:
bob mendoza wrote:
>
> hey.
>
> i'm using debian with the following configuration:
>
> postgresql     7.1release-4
> postgresql-cli 7.1release-4
> postgresql-con 6.5.3-26
> postgresql-doc 7.1release-4
> postgresql-sli 6.3.2
>
> and i want it to listen to on tcp/ip as well as the
> defaul unix socket. the stuff i've read says that i
> need to put the following in
> /etc/postgresql/postmaster.init
>
> PGALLOWTCPIP=yes
> PGPORT=5432
>
> it seems that the file listed above is no longer being
> used in debian to configure postgres. so i thought i
> would use the pg_hba.conf file instead. no luck. can
> someone tell me where i have to put this informatoin?
> i've used redhat in the past and all i had to do was
> use the '-i' option when starting the postmaster.
>
> the stuff in debian is a bit confusing. any help would
> be appreciated.

These configuration options are now in /etc/postgresql/postgresql.conf - the file
format, while different to the previous version under Debian, is well documented
within the file.

Cheers,
                    Andrew.
--
_____________________________________________________________________
        Andrew McMillan, e-mail: Andrew @ catalyst . net . nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64(27)246-7091, Fax:+64(4)499-5596, Office: +64(4)499-2267xtn709