Page 1 of 1

Coonect to PostgreSQL from another computer

PostPosted: Sat Sep 13, 2008 5:05 pm
by TROM
How I can connet to PostgreSQL database in PT3 from another computer in local network
Where I can find IP adress of database name? login? password?

I cant see password of my database in Database Managment in PT3

i think I know only
username: postgres
port:5432

I need
Host Nam/Ip address
Password
DB Name

Computer with database in local network has IP 192.168.0.22
Anoter computer where I want connet to database in local network too

Please Help me

Re: Coonect to PostgreSQL from another computer

PostPosted: Sat Sep 13, 2008 5:08 pm
by WhiteRider

Re: Coonect to PostgreSQL from another computer

PostPosted: Sun Sep 14, 2008 4:13 am
by TROM
its doesn't help

in pg_hba.conf

I wrote
host all all 192.168.0.0/220 trust

in postergresql.conf i wrote
listen_addresses = '*'

and try to connect without password in Internet explorer 192.168.0.22:5432
and I have error

I try to connect in other program without password but with Username and Db name I have error too
Another computer in the same network
Firewall I turn off

Re: Coonect to PostgreSQL from another computer

PostPosted: Sun Sep 14, 2008 9:04 am
by Guest
Your netmask is wrong. Try 192.168.0.0/255.255.255.0, that should fix your problem.

Re: Coonect to PostgreSQL from another computer

PostPosted: Tue Sep 16, 2008 5:15 pm
by TROM
gvdbilt wrote:Your netmask is wrong. Try 192.168.0.0/255.255.255.0, that should fix your problem.

no this does'nt help

Re: Coonect to PostgreSQL from another computer

PostPosted: Wed Sep 17, 2008 1:27 am
by APerfect10
Your listen address in your postgresql.conf file is fine.

Your pg_hba.conf file should be:
Code: Select all
# IPv4 local connections:
host    all         all         127.0.0.1/32            trust
host    all         all         192.168.0.0/24          trust
# IPv6 local connections:
host    all         all         ::1/128                 trust


You will not be able to connect via Internet Explorer by typing in the address.

Best regards,

Derek

highfalutin