Hi all,
I was not quite sure if this is the right forum for this question (if it
aint.oh well).
I have had a postgresql server up and running smoothly for 1.5 years now -
no problems at all..but:
I now need to be able to administer the server remotely, as well as allow
remote logins from a WAN.
Now, I have set up all the appropriate port forwarding, made sure that there
are no problems with firewalls on the server.but the dratted thing will not
allow any connections from a remote pgAdmin.
I am fairly sure this is a result of a problem with pf_hba.conf.Can anyone
advise how to configure pg_hba.conf to permit connections from any subnet
and ip? I know this is not really a good idea, but if the connection works,
at least then I know where the problem is! As it is, I cannot be sure
exactly where the connection failure is. Very annoying!
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
