It’s a passthrough to the postgres command itself.
From the doc:
-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.
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Jonathan Mast Sent: Wednesday, March 31, 2010 4:16 PM To: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Need Help Enabling Remote Connections
I've just installed Postgresql Server 8.1.xx on Cent OS 5.4, the server's IP is 192.168.15.113
I added a db user (with super-user privileges) and edited pg_hba.conf to allow 192.168.15.0/24 and 192.168.1.0/24 (the remote subnet, where I'm trying to connect from).
I edited postgresql.conf to: listen_addresses = '*' port = 5432 max_connections = 100
But I cannot connect remotely, I get "Server doesn't Listen" from pgAdmin.