From: Scott Marlowe <scott.marlowe@gmail.com>
To: John <lists@johndubchak.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: starting postgres on red hat
Date: Thu, 11 Sep 2008 12:14:34 -0600
Message-ID: <dcc563d10809111114p5d46ba75hd8d108ac19a671c5@mail.gmail.com> (raw)
In-Reply-To: <48C95701.400@johndubchak.com>
References: <B0D7C0A3F35FE144A70312D086CBCA9B143453A4@ExchMailbox2.univ.dir.wwu.edu>
<dcc563d10809111021i46b4019idd6ab3d12bbcd00d@mail.gmail.com>
<dcc563d10809111028u7230f50fscd536a7f8c54c5c3@mail.gmail.com>
<48C95701.400@johndubchak.com>
On Thu, Sep 11, 2008 at 11:36 AM, John <lists@johndubchak.com> wrote:
> Scott Marlowe wrote:
>>
>> Oh yeah, please note that the proper way to start and stop services on
>> RH oses is via the service command:
>>
>> service postgresql start
>> service postgresql initdb
>>
>> etc..
>
> Scott,
>
> How does the above compare with using postmaster to start Postgres?
>
> I tried in the past to use the "service postgresql start" command, but
> couldn't connect from a java application and have gotten in the habit of
> using a script that uses postmaster to append a "-i" to the command line to
> allow TCP/IP connections.
Yeah, you can't stop / stop services as anything but root on centos.
so unless you were running the receiving end to the java app as root,
it wouldn't be able to restart pgsql.
On ubuntu the postgres account can restart with
/etc/init.d/postgresql, nice feature.
> Can that be configured in postgresql.conf?
Yes, it's the line where you tell it what host adapters to use, or on
older pgsql's also the tcp_connection parameter (I think I spelt it
right, been a while)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, lists@johndubchak.com
Subject: Re: starting postgres on red hat
In-Reply-To: <dcc563d10809111114p5d46ba75hd8d108ac19a671c5@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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