On Thursday 21 Nov 2002 4:01 pm, Delao, Darryl W wrote: > The main problem I am having is that postgres starts up fine, but does not > open port 5432 which is what I need for all of my local connections to be > able to talk to the database. I am new to this, so please bear with me. > Is there anything I can set to where it will open 5432 everytime postgres > is started? > > Thanks!
Hi Darryl, did you follow the instructions I gave you to edit /var/lib/pgsql/data/postgresql.conf? If so, did you get any error messages when you restarted the service? Did you get any errors in the log files? Gary > > -----Original Message----- > From: Gary Stainburn [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 9:54 AM > To: Delao, Darryl W > Cc: [EMAIL PROTECTED] > Subject: Re: Postgres Startup > > On Thursday 21 Nov 2002 3:31 pm, Delao, Darryl W wrote: > > I am using redhat 7.3 which was automatically installed. I need it to > > automatically start using the command below. Thanks for you help! > > > > Darryl > > Hi Darryl. > > As part of the RPMs for Postgresql there is a startup script which is > placed > > in /etc/rc.d/init.d/postgresql. If you look into this file, you will see > that after performing some sanity checks, it starts the postmaster service. > > Is there any specific reason why you wish to start the postmaster by hand > instead of using the pg_ctl command? > > I noted that you have the '-I' argument. This is not a valid argument to > postmaster. If you mean '-i' to enable TCP/IP connections, the preferred > method is to edit /var/lib/pgsql/data/postgresql.conf file and change the > line: > > tcpip_socket = false > > to > > tcpip_socket = true > > > This way, if you update the RPM's at any time your settings won't get > splatted > on. > > HTH > > BTW, always stay on-list with message by clicking 'reply-to-all' on your > mail > client. That way, other people can still help out. > > Gary > Gary > > > -----Original Message----- > > From: Gary Stainburn [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, November 21, 2002 9:25 AM > > To: [EMAIL PROTECTED]; Delao, Darryl W > > Subject: Re: Postgres Startup > > > > On Thursday 21 Nov 2002 3:04 pm, Delao, Darryl W wrote: > > > I am trying to configure postgres to automatically startup using the > > > following command. > > > > > > Postmaster -I -p 5432 -D /usr/local/pgsql/data > > > > > > However, I am not sure where I should put this line within the postgres > > > startup file. > > > > > > Any suggestions? > > > > > > Thank you! > > > Darryl > > > > Which OS and version are you using? > > How have you installed Postgresql? > > > > If it's a relatively recent version of RedHat (6.0 onwards I think), and > > you're using the RPMs for Postgresql, then you can use > > > > service postgresql start > > and > > service postgresql stop > > > > to manually start and stop the service or use > > > > chkconfig --list|grep postg > > > > to see in which run-levels it starts automatically. > > > > To turn on postgresql for runlevels 3 (text) and 5 (X) use > > > > chkconfig --level 35 postgresql on > > > > HTH > > > > Gary -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list
