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: (view raw or whole 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-2015 The PostgreSQL Global Development Group