Обсуждение: How to configure the postmaster daemon so that it accepts TCP connections?

On Sun, Apr 4, 2010 at 10:02 AM, Ankuj Gupta <ankuj2004@gmail.com> wrote:
> Hi!!
>
> I have to configure the postmaster daemon to accept TCP connection.For that
> I will have to add -i and -o flag at the start but how do I accomplish this
> ? I am using Fedora 9.

How did you install pg?  I'm guessing the easiest way is to edit
postgresql.conf in the $PGDATA directory to have listen_addresses="*"
and restarting pgsql.

I'm pretty sure it's in /var/lib/pgsql on fedora, but I won't make a
bet.  You can use locate to find it (maybe):

sudo locate postgresql.conf

On Sun, Apr 4, 2010 at 10:18 AM, Ankuj Gupta <ankuj2004@gmail.com> wrote:
> I installed it using yum. I had a look at the /etc/profile file but it
> didn't have $PGDATA .
>
>
> On Sun, Apr 4, 2010 at 9:44 PM, Scott Marlowe <scott.marlowe@gmail.com>
> wrote:
>>
>> On Sun, Apr 4, 2010 at 10:02 AM, Ankuj Gupta <ankuj2004@gmail.com> wrote:
>> > Hi!!
>> >
>> > I have to configure the postmaster daemon to accept TCP connection.For
>> > that
>> > I will have to add -i and -o flag at the start but how do I accomplish
>> > this
>> > ? I am using Fedora 9.
>>
>> How did you install pg?  I'm guessing the easiest way is to edit
>> postgresql.conf in the $PGDATA directory to have listen_addresses="*"
>> and restarting pgsql.
>
>



--
When fascism comes to America, it will be intolerance sold as diversity.

Ankuj Gupta <ankuj2004@gmail.com> writes:
> I installed it using yum. I had a look at the /etc/profile file but it
> didn't have $PGDATA .

In an RPM install the data directory is typically going to be
/var/lib/pgsql/data/.  There may not be anything there yet if you
haven't started the postmaster once already.  I concur with Scott's
advice to modify postgresql.conf rather than touching the init script
--- any package update is likely to overwrite the script.

(Not that you really need to worry about any future updates happening to
a Fedora 9 installation :-(.  Why aren't you using a current distro for
which you can get updates?  There are now-known security and data loss
risks for the last PG version that shipped in Fedora 9, and the same can
be said for quite a lot of other components in that release.)

            regards, tom lane