I have discovered that the default init script distributed with
pgsql v8.1 sets the listening port to 5432 but does not enable
tcp/ip connections. One must add the -i switch to the invocation
line in the script. I am not sure if this is an oversight or
whether there is another way to tell postmaster to start with
tcp/ip listening enabled that I am unaware of. However, I thought
that this information might be of interest to anyone else running a
non-distro version of pgsql.
Regards,
Jim
--
*** e-mail is not a secure channel ***
mailto:byrnejb.<token>@harte-lyne.ca
James B. Byrne Harte & Lyne Limited
vox: +1 905 561 1241 9 Brockley Drive
fax: +1 905 561 0757 Hamilton, Ontario
<token> = hal Canada L8E 3C3
James B. Byrne wrote:>I have discovered that the default init script distributed with >pgsql v8.1 sets the listening port to 5432 but does not enable >tcp/ip connections. One must add the -i switch to the invocation >line in the script. I am not sure if this is an oversight or >whether there is another way to tell postmaster to start with >tcp/ip listening enabled that I am unaware of. However, I thought >that this information might be of interest to anyone else running a >non-distro version of pgsql. > >Regards, >Jim > >-- > *** e-mail is not a secure channel *** >mailto:byrnejb.<token>@harte-lyne.ca >James B. Byrne Harte & Lyne Limited >vox: +1 905 561 1241 9 Brockley Drive >fax: +1 905 561 0757 Hamilton, Ontario ><token> = hal Canada L8E 3C3 > >_______________________________________________ >CentOS mailing list >CentOS at centos.org >http://lists.centos.org/mailman/listinfo/centos > > > >edit your /var/lib/pgsql/data/postgresql.conf and set the variable listen_addresses leonel
James B. Byrne wrote:>I have discovered that the default init script distributed with >pgsql v8.1 sets the listening port to 5432 but does not enable >tcp/ip connections. One must add the -i switch to the invocation >line in the script. I am not sure if this is an oversight or >whether there is another way to tell postmaster to start with >tcp/ip listening enabled that I am unaware of. However, I thought >that this information might be of interest to anyone else running a >non-distro version of pgsql. > >Regards, >Jim > >-- > *** e-mail is not a secure channel *** >mailto:byrnejb.<token>@harte-lyne.ca >James B. Byrne Harte & Lyne Limited >vox: +1 905 561 1241 9 Brockley Drive >fax: +1 905 561 0757 Hamilton, Ontario ><token> = hal Canada L8E 3C3 > >_______________________________________________ >CentOS mailing list >CentOS at centos.org >http://lists.centos.org/mailman/listinfo/centos > > > >Jim, also be aware that there is a non-password login from root on that distro, as well as the CentOS version. I found out the hard way after being compromised by some idiot portscanning me. No damage, but thought it odd to have a password-less service open to the world. Sam -- Snowman
On Friday 18 November 2005 15:42, James B. Byrne wrote:> I have discovered that the default init script distributed with > pgsql v8.1 sets the listening port to 5432 but does not enable > tcp/ip connections. One must add the -i switch to the invocation > line in the script.Oh, I forgot to mention one detail you will want to know about. The initscript will get overwritten the next time you upgrade the RPM (it is not a configuration file, after all, but a program and part of the package and subject to change from time to time). Thus if your postmaster quits responding when you upgrade next, you'll know why. For those using the regular CentOS PostgreSQL (either CentOS 3 or 4) if you add the -i in the initscript be prepared for a yum update to change it back (the initscript is NOT a configuration file, but part of the program itself. /var/lib/pgsql/data/postgresql.conf is the correct place, and will never be overwritten as the RPM is currently written unless you run an initdb (which creates that file from the postgresql.conf.sample template). -- Lamar Owen Director of Information Technology Pisgah Astronomical Research Institute 1 PARI Drive Rosman, NC 28772 (828)862-5554 www.pari.edu