pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: pg_hba.conf
9+ messages / 5 participants
[nested] [flat]
* pg_hba.conf
@ 2000-09-04 17:15 Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 07:47 ` Re: pg_hba.conf Christopher Sawtell <csawtell@xtra.co.nz>
0 siblings, 1 reply; 9+ messages in thread
From: Craig May @ 2000-09-04 17:15 UTC (permalink / raw)
To: pgsql-sql
Hi,
I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX, database
XXX." I've modified the pg_hba.conf.sample file to allow all access, however
still getting the same message. Any suggestions?
Regards,
Craig May
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_hba.conf
2000-09-04 17:15 pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
@ 2000-09-04 07:47 ` Christopher Sawtell <csawtell@xtra.co.nz>
2000-09-04 18:50 ` Re: pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
0 siblings, 1 reply; 9+ messages in thread
From: Christopher Sawtell @ 2000-09-04 07:47 UTC (permalink / raw)
To: craig.may@s2.enthdimension.com.au, Craig May <craig.may@s2.enthdimension.com.au>; pgsql-sql
On Tue, 05 Sep 2000, Craig May wrote:
> Hi,
>
> I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX, database
> XXX." I've modified the pg_hba.conf.sample file to allow all access, however
> still getting the same message. Any suggestions?
you have copied pg_hba.conf.sample to pg_hba.conf havn't you?
If that dosn't work check the permissions. The file has to readable by the
pgsql server/backend.
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ xtra . co . nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
-->> Please refrain from using HTML or WORD attachments in e-mails to me <<--
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_hba.conf
2000-09-04 17:15 pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 07:47 ` Re: pg_hba.conf Christopher Sawtell <csawtell@xtra.co.nz>
@ 2000-09-04 18:50 ` Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 09:11 ` Re: pg_hba.conf drfrog@smartt.com
2000-09-04 10:19 ` Re: pg_hba.conf Jan Wieck <janwieck@Yahoo.com>
0 siblings, 2 replies; 9+ messages in thread
From: Craig May @ 2000-09-04 18:50 UTC (permalink / raw)
To: pgsql-sql
I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres.
The file is located in /usr/lib/pgsql/. I'm still receiving the same error.
On Mon, 04 Sep 2000 07:47:08 Christopher Sawtell wrote:
> On Tue, 05 Sep 2000, Craig May wrote:
> > Hi,
> >
> > I'm recieving an error "No pg_hba.conf entry for host XXX, usr XXX,
database
> > XXX." I've modified the pg_hba.conf.sample file to allow all access,
however
> > still getting the same message. Any suggestions?
> you have copied pg_hba.conf.sample to pg_hba.conf havn't you?
>
> If that dosn't work check the permissions. The file has to readable by the
> pgsql server/backend.
>
> --
> Sincerely etc.,
>
> NAME Christopher Sawtell
> CELL PHONE 021 257 4451
> ICQ UIN 45863470
> EMAIL csawtell @ xtra . co . nz
> CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
>
> -->> Please refrain from using HTML or WORD attachments in e-mails to me
<<--
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_hba.conf
2000-09-04 17:15 pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 07:47 ` Re: pg_hba.conf Christopher Sawtell <csawtell@xtra.co.nz>
2000-09-04 18:50 ` Re: pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
@ 2000-09-04 09:11 ` drfrog@smartt.com
1 sibling, 0 replies; 9+ messages in thread
From: drfrog@smartt.com @ 2000-09-04 09:11 UTC (permalink / raw)
To: craig.may@s2.enthdimension.com.au; +Cc: pgsql-sql
Craig May wrote:
>
> I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres.
> The file is located in /usr/lib/pgsql/. I'm still receiving the same error.
>
if you are running redhat 6.X as i suspect
you should place that file in /var/lib/pgsql
not /usr/lib/pgsql
check /etc/rc.d/init.d/postgresql
to make sure {if you are under redhat}
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_hba.conf
2000-09-04 17:15 pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 07:47 ` Re: pg_hba.conf Christopher Sawtell <csawtell@xtra.co.nz>
2000-09-04 18:50 ` Re: pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
@ 2000-09-04 10:19 ` Jan Wieck <janwieck@Yahoo.com>
2000-09-05 11:11 ` Re: pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
1 sibling, 1 reply; 9+ messages in thread
From: Jan Wieck @ 2000-09-04 10:19 UTC (permalink / raw)
To: craig.may@s2.enthdimension.com.au; +Cc: pgsql-sql
Craig May wrote:
> I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres.
> The file is located in /usr/lib/pgsql/. I'm still receiving the same error.
Network setup? Contents of pg_hba.conf? How should someone
tell you what's wrong with the information you gave us that
far?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_hba.conf
2000-09-04 17:15 pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 07:47 ` Re: pg_hba.conf Christopher Sawtell <csawtell@xtra.co.nz>
2000-09-04 18:50 ` Re: pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 10:19 ` Re: pg_hba.conf Jan Wieck <janwieck@Yahoo.com>
@ 2000-09-05 11:11 ` Craig May <craig.may@s2.enthdimension.com.au>
0 siblings, 0 replies; 9+ messages in thread
From: Craig May @ 2000-09-05 11:11 UTC (permalink / raw)
To: pgsql-sql
Ok,
Here are all the details:
Redhat 6.1
pgsql 7.0
Firewall open on port 3456
pg_hba.conf contains the following line
host all 0.0.0.0 0.0.0.0 trust
and is now located in both:
/usr/lib/pgsql/ and /var/lib/pgsql/
This file is owned by "postgres".
The error message is as follows:
"No pg_pba.conf entry for host 203.36.78.179, usr root, database reflexions"
I'm using the postgresql jdbc driver. The machines are on the same subnet,
however, there are no additional relations between the machines. The connection
is successful from localhost. Finally, I have restarted the postgresql service
between every change.
Regards.
Craig May
Enth Dimension
http://www.enthdimension.com.au
On Mon, 04 Sep 2000 10:19:35 Jan Wieck wrote:
> Craig May wrote:
>
> > I've renamed the file to "pg_hba.conf". It's owner and groug are now
postgres.
> > The file is located in /usr/lib/pgsql/. I'm still receiving the same
error.
>
> Network setup? Contents of pg_hba.conf? How should someone
> tell you what's wrong with the information you gave us that
> far?
>
>
> Jan
>
> --
>
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #================================================== JanWieck@Yahoo.com #
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_hba.conf
@ 2000-09-05 11:28 Craig May <craig.may@s2.enthdimension.com.au>
0 siblings, 0 replies; 9+ messages in thread
From: Craig May @ 2000-09-05 11:28 UTC (permalink / raw)
To: pgsql-sql
Found it!
The file should be located in /var/lib/pgsql/data/
Thanks for your help all =)
Craig May
Enth Dimension
http://www.enthdimension.com.au
On Tue, 05 Sep 2000 11:11:25 Craig May wrote:
> Ok,
>
> Here are all the details:
>
> Redhat 6.1
> pgsql 7.0
> Firewall open on port 3456
>
> pg_hba.conf contains the following line
>
> host all 0.0.0.0 0.0.0.0 trust
>
> and is now located in both:
>
> /usr/lib/pgsql/ and /var/lib/pgsql/
>
> This file is owned by "postgres".
>
> The error message is as follows:
>
> "No pg_pba.conf entry for host 203.36.78.179, usr root, database reflexions"
>
> I'm using the postgresql jdbc driver. The machines are on the same subnet,
> however, there are no additional relations between the machines. The
connection
> is successful from localhost. Finally, I have restarted the postgresql
service
> between every change.
>
> Regards.
> Craig May
>
> Enth Dimension
> http://www.enthdimension.com.au
>
>
> On Mon, 04 Sep 2000 10:19:35 Jan Wieck wrote:
> > Craig May wrote:
> >
> > > I've renamed the file to "pg_hba.conf". It's owner and groug are now
> postgres.
> > > The file is located in /usr/lib/pgsql/. I'm still receiving the same
> error.
> >
> > Network setup? Contents of pg_hba.conf? How should someone
> > tell you what's wrong with the information you gave us that
> > far?
> >
> >
> > Jan
> >
> > --
> >
> > #======================================================================#
> > # It's easier to get forgiveness for being wrong than for being right. #
> > # Let's break this rule - forgive me. #
> > #================================================== JanWieck@Yahoo.com #
> >
^ permalink raw reply [nested|flat] 9+ messages in thread
* pg_hba.conf
@ 2004-03-10 04:12 azwa@nc.com.my
0 siblings, 0 replies; 9+ messages in thread
From: azwa@nc.com.my @ 2004-03-10 04:12 UTC (permalink / raw)
To: pgsql-sql
Hi,
i try to connect to my database as $ psql dwnc biosadm but got the error
"psql: FATAL: No pg_hba.conf entry for host localhost, user
biosadm, database dwnc"
Below are the detail in pg_hba.conf
# TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
local all all
trust
host all all 127.0.0.1
255.255.255.255 trust
host all all 192.168.1.45
255.255.255.0 trust
host dwnc biosadm 192.168.1.45
255.255.255.0 trust
the line in bold has been deleted before i connect to database . then i
shutdown the database using following command :
pg_ctl -D /usr/local/pgsql/data stop -m fast
followed by startup database :
postmaster -D /usr/local/pgsql/data > logg 2>&1 &
Does anybody know why does the above error occur when trying to connect
database and try connect through client using pgadmin??? thanks in advance
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: pg_hba.conf
@ 2004-03-10 05:39 azwa@nc.com.my
0 siblings, 0 replies; 9+ messages in thread
From: azwa@nc.com.my @ 2004-03-10 05:39 UTC (permalink / raw)
To: pgsql-sql
Hi,
by the way i've settle my connection problem between client application
and server itself . this is happen because of editing the parameter in
pg_hba.conf
while the environment(database was running) was active. tq
azwa@postgresql.org
Sent by: pgsql-sql-owner@postgresql.org
12:12 PM Today
To: pgsql-sql@postgresql.org
cc:
Subject: [SQL] pg_hba.conf
Hi,
i try to connect to my database as $ psql dwnc biosadm but got the
error
"psql: FATAL: No pg_hba.conf entry for host localhost,
user
biosadm, database dwnc"
Below are the detail in pg_hba.conf
# TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
local all all
trust
host all all 127.0.0.1
255.255.255.255 trust
host all all 192.168.1.45
255.255.255.0 trust
host dwnc biosadm 192.168.1.45
255.255.255.0 trust
the line in bold has been deleted before i connect to database . then i
shutdown the database using following command :
pg_ctl -D /usr/local/pgsql/data stop -m fast
followed by startup database :
postmaster -D /usr/local/pgsql/data > logg 2>&1 &
Does anybody know why does the above error occur when trying to connect
database and try connect through client using pgadmin??? thanks in advance
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2004-03-10 05:39 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-04 17:15 pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 07:47 ` Christopher Sawtell <csawtell@xtra.co.nz>
2000-09-04 18:50 ` Craig May <craig.may@s2.enthdimension.com.au>
2000-09-04 09:11 ` drfrog@smartt.com
2000-09-04 10:19 ` Jan Wieck <janwieck@Yahoo.com>
2000-09-05 11:11 ` Craig May <craig.may@s2.enthdimension.com.au>
2000-09-05 11:28 Re: pg_hba.conf Craig May <craig.may@s2.enthdimension.com.au>
2004-03-10 04:12 pg_hba.conf azwa@nc.com.my
2004-03-10 05:39 Re: pg_hba.conf azwa@nc.com.my
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox