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

Re: pg_ctl question

From: jseymour(at)linxnet(dot)com (Jim Seymour)
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_ctl question
Date: 2004-06-28 21:57:28
Message-ID: 20040628215728.B054D430E@jimsun.linxnet.com (view raw or flat)
Thread:
Lists: pgsql-admin
"Jeff Stout" <jstout(at)cctus(dot)com> 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?
[snip]

Set "tcpip_socket = true" in $PGDATA/postgresql.conf and restart.

And you'll want to set up host entries in $PGDATA/pg_hba.conf, as
well.

Jim

In response to

pgsql-admin by date

Next:From: Jose' CruanyesDate: 2004-06-28 22:45:28
Subject: Re: Change the character encoding of a database
Previous:From: Bender, CherylDate: 2004-06-28 21:41:46
Subject: Re: pg_ctl question

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