Re: How to allow PostgreSQL to accept remote connection?

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: Fredric Fredricson <Fredric(dot)Fredricson(at)bonetmail(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to allow PostgreSQL to accept remote connection?
Date: 2010-04-24 15:25:45
Message-ID: n2j18f98e681004240825u7d5b1b45i6e581b5a44ce7c50@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for the reply's,

How can I configure pg_hba.conf to accept connections from all IP's

What I have in this file is:

#ipv4
host all all 127.0.0.1/32 md5

#ipv6
host all all ::1/128 md5

What I need to change?

Best Regards,

On Sat, Apr 24, 2010 at 4:15 PM, Fredric Fredricson <
Fredric(dot)Fredricson(at)bonetmail(dot)com> wrote:

> Raymond O'Donnell wrote:
>
>> On 24/04/2010 15:58, Andre Lopes wrote:
>>
>>
>>> Hi,
>>>
>>> I have a virtual machine with VMWARE, and I need to connect from outside
>>> the virtual machine to PostgreSQL.
>>>
>>> How can I configure the PostgreSQL to accept outside connections?
>>>
>>>
>>
>> It should be just the same as a "real" machine.... put the IP address of
>> the VM's network interface in "listen_addresses" in postgresql.conf.
>>
>>
> You will probably also have to edit pg_hba.conf file (chaper 20.1 in the
> manual).
> /Fredric
>
>> Ray.
>>
>>
>>
>>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-04-24 15:40:36 ISP provider with postgres and perl dbi
Previous Message Raymond O'Donnell 2010-04-24 15:04:56 Re: How to allow PostgreSQL to accept remote connection?