Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group