Thread: '-i option' with Runlevel script (RPM version)
Hi guys, I have read the archive, looking for posts which could help me solve this case. It is not a problem, as long as I can make it work, but it is a thing that ... I'd love to be solved in a more clean way. I want to start up the postmaster process with the '-i' option, but the runlevel script which comes with the RPM, doesn't include it. The only way I could do to accomplish this, was to modify this script. Well, sincerely, I'd prefer - if there is - another way to do this, maybe by specifying a configuration option. I don't know ... just wondering. Please consider that I am pretty new with PostgreSQL and this is my 1st msg! :-) Ciao and thanks -Gabriele -- Gabriele Bartolini - Web Programmer Comune di Prato - Prato - Tuscany - Italy g.bartol@comune.prato.it | http://www.comune.prato.it > find bin/laden -name osama -exec rm {} ;
Attachment
On Tue, Oct 15, 2002 at 09:20:00AM +0200, Gabriele Bartolini wrote: > Hi guys, > > I have read the archive, looking for posts which could help me solve > this case. It is not a problem, as long as I can make it work, but it is > a thing that ... I'd love to be solved in a more clean way. > > I want to start up the postmaster process with the '-i' option, but > the runlevel script which comes with the RPM, doesn't include it. The > only way I could do to accomplish this, was to modify this script. Yep, look in the postmaster.conf, I think it's called tcpip_socket = 1 -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > There are 10 kinds of people in the world, those that can do binary > arithmetic and those that can't.
On Tuesday 15 October 2002 03:20 am, Gabriele Bartolini wrote: > I have read the archive, looking for posts which could help me solve > this case. It is not a problem, as long as I can make it work, but it is > a thing that ... I'd love to be solved in a more clean way. > I want to start up the postmaster process with the '-i' option, but > the runlevel script which comes with the RPM, doesn't include it. The > only way I could do to accomplish this, was to modify this script. Well, first, welcome to PostgreSQL. You will find that this is a really industrial-strength database, with features that meet the needs of an Internet-connected, or Intranet-connected, database server. One of those features is the ability to be a totally local database server, not accessible to the outside. As of PostgreSQL 6.3, the default behavior of the postmaster was changed to not open a TCP/IP socket by default. This is, in my opinion, a very good thing for security. Up until the 7.0 version of the RPMset, I had the '-i' in the initscript in /etc/rc.d/init.d. At 7.1 I decided to remove the -i for security reasons, as well as the fact that it became very easy to enable TCP/IP socket listening in the file /var/lib/pgsql/data/postgresql.conf. Unfortunately many people became very confused by this, and the question 'Why isn't -i the default' or 'How do I get the -i behavior' has been very frequently asked since then. So the topic is dealt with thoroughly in the README.rpm-dist documentation file distributed with the postgresql RPM. To find this file, run the following command: rpm -ql postgresql | grep README and it will show up in the listing. Then use less, or your favorite file reader, to read this file. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Is the tcpip_socket option available to all versions? I had the same problem Gabriele did and someone suggested adding the option to postmaster.conf but it didnt work. I was already too frustrated at the time to persue the matter further, I simply edited the script. thanks -b On Tue, 2002-10-15 at 03:27, Martijn van Oosterhout wrote: > On Tue, Oct 15, 2002 at 09:20:00AM +0200, Gabriele Bartolini wrote: > > Hi guys, > > > > I have read the archive, looking for posts which could help me solve > > this case. It is not a problem, as long as I can make it work, but it is > > a thing that ... I'd love to be solved in a more clean way. > > > > I want to start up the postmaster process with the '-i' option, but > > the runlevel script which comes with the RPM, doesn't include it. The > > only way I could do to accomplish this, was to modify this script. > > Yep, look in the postmaster.conf, I think it's called tcpip_socket = 1 > > -- > Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > > There are 10 kinds of people in the world, those that can do binary > > arithmetic and those that can't. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
It's definitely been there for awhile, I'd say maybe since the 7.0.x versions. However, the option doesn't go in the postmaster.conf, it's in the postgresql.conf Robert Treat On Tue, 2002-10-15 at 17:55, Bill wrote: > Is the tcpip_socket option available to all versions? I had the same > problem Gabriele did and someone suggested adding the option to > postmaster.conf but it didnt work. I was already too frustrated at the > time to persue the matter further, I simply edited the script. > > thanks > > -b > > On Tue, 2002-10-15 at 03:27, Martijn van Oosterhout wrote: > > On Tue, Oct 15, 2002 at 09:20:00AM +0200, Gabriele Bartolini wrote: > > > Hi guys, > > > > > > I have read the archive, looking for posts which could help me solve > > > this case. It is not a problem, as long as I can make it work, but it is > > > a thing that ... I'd love to be solved in a more clean way. > > > > > > I want to start up the postmaster process with the '-i' option, but > > > the runlevel script which comes with the RPM, doesn't include it. The > > > only way I could do to accomplish this, was to modify this script. > > > > Yep, look in the postmaster.conf, I think it's called tcpip_socket = 1 > > > > -- > > Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > > > There are 10 kinds of people in the world, those that can do binary > > > arithmetic and those that can't. > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly