I'm investigating the use of Postgres for a future project & have installed
beta 8.0 using the windows installer which includes pgadmin III. Everything
works great, I can create tables etc. Connect from external applications...
but, no matter what I do the Backup and Restore options on the pgad
Hi Michael,
In the PostgreSQL data directory on the server, there is a file called
"pg_hba.conf". (It stands for PostgreSQL "Host Based Access"
configuration I think)
This file contains the list of IP addresses plus user names and
databases that people are allowed to connect to remotely. The
Michael J Martin wrote:
Just to mention the error I get is not a 'process isn't running' error
it is:
Error connecting to the server: FATAL: no pg_hba.conf entry for host
"212.159.49.21", user "mike", database "template1", SSL off
As the message tells, you need to edit pg_hba.conf to allow the
Just to mention the error I get is not a 'process isn't running' error
it is:
Error connecting to the server: FATAL: no pg_hba.conf entry for host
"212.159.49.21", user "mike", database "template1", SSL off
Hope this helps.
Michael
Michael J Martin wrote:
I realise this is probably my fault fo
I realise this is probably my fault for not setting up Postgres properly
so may question is how do you setup postgres to play nicely with pgAdmin?
Background:
We're with a host provider who uses FreeBSD and installed postgresql
using their tools, it's running and I can get to it by using the 'ps
