Re: How to configure the postmaster daemon so that it accepts TCP connections?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ankuj Gupta <ankuj2004(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to configure the postmaster daemon so that it accepts TCP connections?
Date: 2010-04-04 16:36:23
Message-ID: 12827.1270398983@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ankuj Gupta <ankuj2004(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Halil Türker Özdamar 2010-04-04 18:33:34 Re: Connection Pooling
Previous Message Pavel Stehule 2010-04-04 16:34:20 Re: Dynamic plpgsql help