Re: pg_hba.conf errors

From: Serkan Bektaş <sbektas(at)karincaint(dot)com(dot)tr>
To: "pgsql-gen Newsgroup" <(at)Basebeans(dot)compgsql-gen(at)basebeans(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_hba.conf errors
Date: 2002-03-22 16:50:32
Message-ID: NGBBKAHEKENENJFJMBDGCEAJCCAA.sbektas@karincaint.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of pgsql-gen
Newsgroup
Sent: 22 Mart 2002 Cuma 18:40
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] pg_hba.conf errors

Subject: pg_hba.conf errors
From: "alt.cybercafes" <pmunis(at)hotmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Tkach 2002-03-22 17:07:54 Re: A general database question!
Previous Message tony 2002-03-22 16:47:08 OR problems