Thread: How to configure the postmaster daemon so that it accepts TCP connections?
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.
Ankuj
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.
Ankuj
Re: How to configure the postmaster daemon so that it accepts TCP connections?
From
Scott Marlowe
Date:
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.
Re: How to configure the postmaster daemon so that it accepts TCP connections?
From
Ankuj Gupta
Date:
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:
How did you install pg? I'm guessing the easiest way is to editOn 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.
postgresql.conf in the $PGDATA directory to have listen_addresses="*"
and restarting pgsql.
Re: How to configure the postmaster daemon so that it accepts TCP connections?
From
Scott Marlowe
Date:
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.
Re: How to configure the postmaster daemon so that it accepts TCP connections?
From
Ankuj Gupta
Date:
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:
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