Обсуждение: pg_hba.conf errors

Поиск
Список
Период
Сортировка

pg_hba.conf errors

От
pgsql-gen Newsgroup (@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




Re: pg_hba.conf errors

От
Serkan Bektaş
Дата:
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