PDA

View Full Version : Postgres SQL Database over Internet



Curru
11-02-2009, 12:02 PM
Hello,

i need help setting up to use my DB through internet.
On my homepc there is dyndns and it works. pinged and router web access works fine.

Now i wanna access on my laptop on this database.

This is what i´ve done till now:
1. portforwarding on my router and the windows firewall on both computer. (5432)
2. added the line : host all all 0.0.0.0/0 the pg_hba conf

So now i installed HM on the laptop and tried to connect to my dyndns name and username and pw but it doesn't work.

Anybody now what to do?

Thank you very much

netsrak
11-02-2009, 02:55 PM
Can you ping the computer?
Can you connect via pgadmin?

Curru
11-02-2009, 05:57 PM
yes i can ping the computer
and i don't have pgadmin on the laptop. i think i don't need to install it on the laptop right=?!

fabio
11-03-2009, 10:36 AM
Add host all all <yourdyndnsip>/32 to the pg_hba conf

netsrak
11-03-2009, 01:01 PM
I recommend you install pgadmin, its better for testing (www.pgadmin.org)