Re: pg_ctl question

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Jeff Stout" <jstout(at)cctus(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_ctl question
Date: 2004-06-28 21:32:42
Message-ID: 200406282332.42957.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/postgresql.conf (or your local equivalent
database directory), set

tcpip_socket = true

and do pg_ctl reload

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ivo Rossacher 2004-06-28 21:38:24 Change the character encoding of a database
Previous Message Jason Jahn 2004-06-28 21:28:39 Re: pg_ctl question