| View previous topic :: View next topic |
| Author |
Message |
Metnetsky Guest
|
Posted: Sat Jul 19, 2003 10:50 pm Post subject: Postgresql |
|
|
Does anyone know what has to be set in the PostgreSQL pg_hba.conf file to
allow all incoming TCP/IP connections? Any help and/or example would be
greatly appreciated. The PostgreSQL docs are beginning to get to me.
~ Matthew
P.S. The server is starting correctly with the -i or -o options (forget
which).
|
|
| Back to top |
|
 |
Ed Yu Guest
|
Posted: Sat Jul 19, 2003 11:44 pm Post subject: Re: Postgresql |
|
|
Read the file itself, it has all the things you need. The following allows
all incoming connections using password authentication from file 'passwd' in
the $PGDATA directory
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENT
host all 0.0.0.0 0.0.0.0 password passwd
"Metnetsky" <mimetnet (AT) syr (DOT) edu> wrote
| Quote: | Does anyone know what has to be set in the PostgreSQL pg_hba.conf file to
allow all incoming TCP/IP connections? Any help and/or example would be
greatly appreciated. The PostgreSQL docs are beginning to get to me.
~ Matthew
P.S. The server is starting correctly with the -i or -o options (forget
which).
|
|
|
| Back to top |
|
 |
Gerrit van Niekerk Guest
|
Posted: Sun Jul 20, 2003 7:19 am Post subject: Re: Postgresql |
|
|
On Sat, 19 Jul 2003 18:50:32 -0400, "Metnetsky" <mimetnet (AT) syr (DOT) edu>
wrote:
Say you want to allow 192.168.220.120 you must add
host all 192.168.220. 0 255.255.255.0 trust
This will allow all from 0-255 including 120
Gerrit
| Quote: | Does anyone know what has to be set in the PostgreSQL pg_hba.conf file to
allow all incoming TCP/IP connections? Any help and/or example would be
greatly appreciated. The PostgreSQL docs are beginning to get to me.
~ Matthew
P.S. The server is starting correctly with the -i or -o options (forget
which).
|
|
|
| Back to top |
|
 |
Metnetsky Guest
|
Posted: Sun Jul 20, 2003 2:18 pm Post subject: Re: Postgresql |
|
|
On Sat, 19 Jul 2003 23:44:56 +0000, Ed Yu wrote:
| Quote: | Read the file itself, it has all the things you need. The following allows
all incoming connections using password authentication from file 'passwd' in
the $PGDATA directory
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENT
host all 0.0.0.0 0.0.0.0 password passwd
|
Thanks a lot.
|
|
| Back to top |
|
 |
|