Re: Pg_ctl with postmaster -i option

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
 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.oliveira@grant.co.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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Wang, Mary Y
> Sent: 02 February 2010 06:41
> To: pgsql-admin@postgresql.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