Re: [ADMIN] pg_ctl question

2004-06-28 Thread Jim Seymour
"Jeff Stout" <[EMAIL PROTECTED]> wrote: > > I am using the /contrib/start-scripts/linux file to set > up postgres to automatically restart upon reboot. > > I set it up /etc/init.d/postgres which calls pg_ctl > > pg_ctl invokes postmaster > > where do I set the -i option to allow tcp connection?

Re: [ADMIN] pg_ctl question

2004-06-28 Thread Peter Eisentraut
Jeff Stout wrote: > I am using the /contrib/start-scripts/linux file to set > up postgres to automatically restart upon reboot. > > I set it up /etc/init.d/postgres which calls pg_ctl > > pg_ctl invokes postmaster > > where do I set the -i option to allow tcp connection? In /usr/local/pgsql/data/p

Re: [ADMIN] pg_ctl question

2004-06-28 Thread Jason Jahn
: Jeff Stout [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 4:10 PM Cc: [EMAIL PROTECTED] Subject: [ADMIN] pg_ctl question I am using the /contrib/start-scripts/linux file to set up postgres to automatically restart upon reboot. I set it up /etc/init.d/postgres which calls pg_ctl pg_ctl

Re: [ADMIN] pg_ctl question

2004-06-28 Thread Bender, Cheryl
<> The easiest way is to set it in postgresql.conf, which is put in your data folder when you run initdb. Near the beginning of the file you should see something like tcpip_socket=true port=5432 Except that these lines are commented out by default. Uncomment them and restart pgsql after saving

[ADMIN] pg_ctl question

2004-06-28 Thread Jeff Stout
I am using the /contrib/start-scripts/linux file to set up postgres to automatically restart upon reboot. I set it up /etc/init.d/postgres which calls pg_ctl pg_ctl invokes postmaster where do I set the -i option to allow tcp connection? I am able to set the database to start upon boot, but can