View Full Version : Networking grrrr

01-20-2011, 07:17 AM
Hi all,

I'm having some issues trying to connect my pc to db over my home network; when trying to connect I receive this error:

Connection Error: FATAL: 28000: no pg_hba.conf entry for host "", user "postgres" database "postgres" SSL off

The laptop I am trying to connect has the ipv4 address, and I'm trying to connect to a desktop pc where the db is (

In the pb_hba.conf file I wrote a line saying the following:
(Under IPv4 Local Connections)

Any thoughts on what I'm doing wrong here? I can't seem to see it.

Cheers guys,


01-20-2011, 10:39 AM
You need to stop the postgresql service on the server, open the pg_hba.conf file with a texteditor and add a line like the following to the ipv4 section:

host all all trust

Save the file and restart the postgresql service.

01-20-2011, 06:00 PM
Ok so this is definitely a problem with my entry in the pg_hba.conf file, if I'm reading the error correctly.

Please note: have turned windows firewall off so it can't be that.


How does this look to you guys?

01-20-2011, 06:20 PM
Thought this might also be useful for anyone willing to help me with this:

My ipconfig for the desktop:


ipconfig for laptop:

Thanks again guys, anyone needing any further info to help with this don't hesitate to ask. I will do everything I can.

01-20-2011, 08:20 PM
Also if I can't resolve this problem through this thread is there any kind of tech support where I can get someone to help me with this through teamviewer or logmein or some kind of remote access program so they can quickly go over my settings and make any changes?

01-21-2011, 04:27 AM
Did you enter tabs between the columns or spaces? It should be tabs.

And please try with the number 32 instead of 24. I'm not sure whether it helps but its worth a try.

If you can't figure it out (there are lots of helpful sites around if you google for Postgresql network) please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.
But this network configuraton is not part of our basic support.

01-21-2011, 05:11 AM
Thanks for the info I'll try those suggestions, If I cannot solve it I'd like to do the remote session.

By not covered in basic support I'm guessing theres a fee involved? Where can I discuss this further/view rates for this kind of support?

01-21-2011, 05:37 AM
Double checked the tab situation-

The lines that came with the installation are separated by spaces?

So I changed the lines so that they were separated by one tab each, and still same issue.

Should I be using more than one tab?

Changing to /32 as opposed to /24 seemed to do nothing at all as you suspected.

I'm still getting exactly the same error, and while I understand that there are many resources on the internet for PostgreSQL, Ive been working on this on and off for a month and really don't have the time/intelligence to figure it out for myself.

01-21-2011, 10:30 AM
There are no fees for helping you with this. Its just beyond our standard support.
But please mail support to arrange something and we will see what we can do.

01-21-2011, 11:06 PM
thanks for the great support so far, email sent!

01-23-2011, 09:26 PM
Just want to double check that the above email is right? Haven't had a reply as of yet.


01-24-2011, 05:30 AM
Sorry your email was in the queue over the weekend. I just answered.

01-28-2011, 04:33 AM
thankyou for your support in this issue, I'm all sorted now with accessing my db over my home network.

One question though- say I am playing poker on my laptop, db is on desktop, how do I import my played hands on the laptop automatically?

Is there a better way to do this than to set my handhistory folder to shared and have autoimport source my hands using this mehtod?

01-28-2011, 08:38 AM
If your laptop HM uses the desktop database the auto-import should automatically import the hands into the server database.