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 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:

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.

I found out . Its is in /var/lib/pgsql/data .

On Sun, Apr 4, 2010 at 10:00 PM, Scott Marlowe <scott.marlowe@gmail.com>wrote:

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