pg_hba.conf errors

Started by pgsql-gen Newsgroupabout 24 years ago2 messagesgeneral
Jump to latest
#1pgsql-gen Newsgroup
pgsql-gen@basebeans.com

Subject: pg_hba.conf errors
From: "alt.cybercafes" <pmunis@hotmail.com>
===
What do this error means?
FATAL 1: No pg_hba.conf entry for host 192.168.1.4, user postgres, database
template1
FATAL 1: user "password=" does not exist

#2Serkan Bektaş
sbektas@karincaint.com.tr
In reply to: pgsql-gen Newsgroup (#1)
Re: pg_hba.conf errors

I think you are trying to connect PostgreSQL with PgExplorer or PgAdmin...
this is an example pg_hba.conf file

local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 192.168.1.4 255.255.255.0 trust

You have to change the pg_hba.conf file for your need.(Host Based Access
Configuration)
You can find other examples in the file remarks.

and

is user name 'postgres' in your database?
if it isn't or if you are not sure try 'pgsql'.

I hope this helps...

Serkan

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of pgsql-gen
Newsgroup
Sent: 22 Mart 2002 Cuma 18:40
To: pgsql-general@postgresql.org
Subject: [GENERAL] pg_hba.conf errors

Subject: pg_hba.conf errors
From: "alt.cybercafes" <pmunis@hotmail.com>
===
What do this error means?
FATAL 1: No pg_hba.conf entry for host 192.168.1.4, user postgres, database
template1
FATAL 1: user "password=" does not exist

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster