From: | Ian Lea <ian(dot)lea(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
Subject: | Re: Pg_ctl with postmaster -i option |
Date: | 2010-02-02 09:14:00 |
Message-ID: | 8c4e68611002020114w291be431of9a9e811a847a924@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
From $ man postmaster
-i Allows remote clients to connect via TCP/IP (Internet domain)
connections. Without this option, only local connections are
accepted. This option is equivalent to setting listen_addresses
to * in postgresql.conf or via -h.
This option is deprecated since it does not allow access to the
full functionality of listen_addresses. It's usually better to
set listen_addresses directly.
And you will need to set up pg_hba.conf as well, as Renato says. But
maybe more restrictive.
--
Ian.
On Tue, Feb 2, 2010 at 8:36 AM, Renato Oliveira
<renato(dot)oliveira(at)grant(dot)co(dot)uk> wrote:
> If I understood correctly what you want is to allow remote users or clients to connect to your postgresql server
>
> I believe this is controlled by "pg_hba.conf"
> Add a line similar to:
> host all all 192.168.10.0/24 trust
>
> Renato
>
>
>
>
> Renato Oliveira
> Systems Administrator
> e-mail: renato(dot)oliveira(at)grant(dot)co(dot)uk
>
> Tel: +44 (0)1763 260811
> Fax: +44 (0)1763 262410
> http://www.grant.co.uk/
>
> Grant Instruments (Cambridge) Ltd
>
> Company registered in England, registration number 658133
>
> Registered office address:
> 29 Station Road,
> Shepreth,
> CAMBS SG8 6GB
> UK
>
> -----Original Message-----
>
>
> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Wang, Mary Y
> Sent: 02 February 2010 06:41
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] Pg_ctl with postmaster -i option
>
> Hi,
>
> How do configure the pg_ctl program so that when it starts postmaster it will start postmaster with the -i option. I want postmaster allows remote user to connect to the PostgreSQL server.
>
> Thanks in advance
> Mary
>
> ------------------------------------------------
> Mary Y Wang
From | Date | Subject | |
---|---|---|---|
Next Message | Renato Oliveira | 2010-02-02 10:11:48 | PITR clarification to certain points |
Previous Message | Renato Oliveira | 2010-02-02 08:36:21 | Re: Pg_ctl with postmaster -i option |