AppletTalk.com Forum Index AppletTalk.com
Java discussions newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Postgresql

 
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases
View previous topic :: View next topic  
Author Message
Metnetsky
Guest





PostPosted: Sat Jul 19, 2003 10:50 pm    Post subject: Postgresql Reply with 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
Ed Yu
Guest





PostPosted: Sat Jul 19, 2003 11:44 pm    Post subject: Re: Postgresql Reply with 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


"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





PostPosted: Sun Jul 20, 2003 7:19 am    Post subject: Re: Postgresql Reply with quote



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





PostPosted: Sun Jul 20, 2003 2:18 pm    Post subject: Re: Postgresql Reply with quote

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
Display posts from previous:   
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.