pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_ctl question
5+ messages / 5 participants
[nested] [flat]
* pg_ctl question
@ 2004-06-28 21:10 Jeff Stout <jstout@cctus.com>
2004-06-28 21:32 ` Re: pg_ctl question Peter Eisentraut <peter_e@gmx.net>
2004-06-28 21:57 ` Re: pg_ctl question Jim Seymour <jseymour@linxnet.com>
0 siblings, 2 replies; 5+ messages in thread
From: Jeff Stout @ 2004-06-28 21:10 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
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 not get pgAdmin to connect.
Thank you in advance for you help.
Jeff
CCT
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_ctl question
2004-06-28 21:10 pg_ctl question Jeff Stout <jstout@cctus.com>
@ 2004-06-28 21:32 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 5+ messages in thread
From: Peter Eisentraut @ 2004-06-28 21:32 UTC (permalink / raw)
To: Jeff Stout <jstout@cctus.com>; +Cc: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_ctl question
2004-06-28 21:10 pg_ctl question Jeff Stout <jstout@cctus.com>
@ 2004-06-28 21:57 ` Jim Seymour <jseymour@linxnet.com>
1 sibling, 0 replies; 5+ messages in thread
From: jseymour@linxnet.com @ 2004-06-28 21:57 UTC (permalink / raw)
To: pgsql-admin
"Jeff Stout" <jstout@cctus.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_ctl question
@ 2004-06-28 21:28 Jason Jahn <JJahn@Signicast.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jason Jahn @ 2004-06-28 21:28 UTC (permalink / raw)
To: Jeff Stout <jstout@cctus.com>; +Cc: pgsql-admin
I personally use the postgresql.conf file to specify the options for the
server.
tcpip_socket = true
in that file should do the trick.
That file is located in /var/lib/pgsql/data for me (Fedora core 2), but it
may be located elsewhere on your system.
Jason
-----Original Message-----
From: Jeff Stout [mailto:jstout@cctus.com]
Sent: Monday, June 28, 2004 4:10 PM
Cc: pgsql-admin@postgresql.org
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 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 not get pgAdmin to connect.
Thank you in advance for you help.
Jeff
CCT
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_ctl question
@ 2004-06-28 21:41 Bender, Cheryl <cbender@mriresearch.org>
0 siblings, 0 replies; 5+ messages in thread
From: Bender, Cheryl @ 2004-06-28 21:41 UTC (permalink / raw)
To: Jeff Stout <jstout@cctus.com>; +Cc: pgsql-admin
<<I am able to set the database to start upon boot, but
can not get pgAdmin to connect. >>
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 this file.
I almost forgot--If you haven't already done this, in order to connect
from pgadmin you will also need to change your pg_hba.conf file as well
to tell it what host(s) to allow.
Here is a simple entry to allow all hosts on a subnet to connect to all
databases
#TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
host all all 192.168.0.0
255.255.255.0 trust
Cheryl Bender
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-06-28 21:57 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-28 21:10 pg_ctl question Jeff Stout <jstout@cctus.com>
2004-06-28 21:32 ` Peter Eisentraut <peter_e@gmx.net>
2004-06-28 21:57 ` Jim Seymour <jseymour@linxnet.com>
2004-06-28 21:28 Re: pg_ctl question Jason Jahn <JJahn@Signicast.com>
2004-06-28 21:41 Re: pg_ctl question Bender, Cheryl <cbender@mriresearch.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox