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! -----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
