Coonect to PostgreSQL from another computer

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Coonect to PostgreSQL from another computer

Postby TROM » Sat Sep 13, 2008 5:05 pm

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
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: Coonect to PostgreSQL from another computer

Postby WhiteRider » Sat Sep 13, 2008 5:08 pm

WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Coonect to PostgreSQL from another computer

Postby TROM » Sun Sep 14, 2008 4:13 am

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
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: Coonect to PostgreSQL from another computer

Postby Guest » Sun Sep 14, 2008 9:04 am

Your netmask is wrong. Try 192.168.0.0/255.255.255.0, that should fix your problem.
Guest
 

Re: Coonect to PostgreSQL from another computer

Postby TROM » Tue Sep 16, 2008 5:15 pm

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
TROM
 
Posts: 57
Joined: Mon Jun 16, 2008 6:56 pm

Re: Coonect to PostgreSQL from another computer

Postby APerfect10 » Wed Sep 17, 2008 1:27 am

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
APerfect10
Site Admin
 
Posts: 4465
Joined: Sat Dec 08, 2007 6:03 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 40 guests

cron
highfalutin