dbTalk Databases Forums  

Need help connecting to PostgresSQL over my network

comp.databases.postgresql comp.databases.postgresql


Discuss Need help connecting to PostgresSQL over my network in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Arizona Willie
 
Posts: n/a

Default Need help connecting to PostgresSQL over my network - 03-29-2010 , 05:47 PM






I have postgressQL installed on my desktop for a poker program

I want to access that database using the aame program installed on my
laptop over my wireless network.

I was pointed to some instructions but they don't seem to work.
I followed them to the letter and have disabled the desktops firewall ( no
help ) and made sure the postgres directories are shared with permissions
for everyone to read / write.

But I haven't been able to make it work.

Can someone point me to some good instructions on connecting to postres
over a network for Windows 7 64 bit?

Thanks

Reply With Quote
  #2  
Old   
Andreas Kretschmer
 
Posts: n/a

Default Re: Need help connecting to PostgresSQL over my network - 03-30-2010 , 02:24 AM






Arizona Willie <sclause (AT) npole (DOT) com> wrote:
Quote:
I have postgressQL installed on my desktop for a poker program

I want to access that database using the aame program installed on my
laptop over my wireless network.

I was pointed to some instructions but they don't seem to work.
I followed them to the letter and have disabled the desktops firewall ( no
help ) and made sure the postgres directories are shared with permissions
that's okay


Quote:
for everyone to read / write.
that's wrong and a REALLY bad idea...


Quote:
But I haven't been able to make it work.
You have to enable listen on tcp/ip for your network-interface (see
postgresql.conf) and you need a proper entry for your remote host (or
network) in your pg_hba.conf. Read the docs, available here:
http://www.postgresql.org/docs/8.4/i...-hba-conf.html for
more details.



Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Reply With Quote
  #3  
Old   
Laurenz Albe
 
Posts: n/a

Default Re: Need help connecting to PostgresSQL over my network - 03-30-2010 , 04:34 AM



Arizona Willie wrote:
Quote:
I have postgressQL installed on my desktop for a poker program

I want to access that database using the aame program installed on my
laptop over my wireless network.

I was pointed to some instructions but they don't seem to work.
I followed them to the letter and have disabled the desktops firewall ( no
help ) and made sure the postgres directories are shared with permissions
for everyone to read / write.

But I haven't been able to make it work.

Can someone point me to some good instructions on connecting to postres
over a network for Windows 7 64 bit?
Not the cookbook you want, but:

- Configure the server so that it listens on the network:
listen_addresses='*' in postgresql.conf. Verify with "netstat -a".
- You might need to change pg_hba.conf on the server to allow remote
connections.
- Get the Windows Installer from EnterpriseDB
http://www.enterprisedb.com/getfile.jsp?fileid=880
Install only the client components on the client machine (not the server).
- In the DOS-Box:
psql.exe -h <host name of server> -p <server port> -d <database name> -U <user name>

Yours,
Laurenz Albe

Reply With Quote
  #4  
Old   
Arizona Willie
 
Posts: n/a

Default Re: Need help connecting to PostgresSQL over my network - 03-30-2010 , 02:37 PM



Andreas Kretschmer <akretschmer (AT) spamfence (DOT) net> wrote in
news:qil887-9ic.ln1 (AT) akretschmer (DOT) selfip.info:

Quote:
Arizona Willie <sclause (AT) npole (DOT) com> wrote:
I have postgressQL installed on my desktop for a poker program

I want to access that database using the aame program installed on my
laptop over my wireless network.

I was pointed to some instructions but they don't seem to work.
I followed them to the letter and have disabled the desktops firewall
( no help ) and made sure the postgres directories are shared with
permissions

that's okay


for everyone to read / write.

that's wrong and a REALLY bad idea...



But I haven't been able to make it work.

You have to enable listen on tcp/ip for your network-interface (see
postgresql.conf) and you need a proper entry for your remote host (or
network) in your pg_hba.conf. Read the docs, available here:
http://www.postgresql.org/docs/8.4/i...-hba-conf.html
for more details.



Andreas
====================
Thanks for the replies guys. I got it. I had been using an IP with /32 and
it should have been /24. Changed that and now everything is working just
fine.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.