From: | Alexey Rodriguez Yakushev <alexey(at)dicyt(dot)umss(dot)edu(dot)bo> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_hba.conf problems with Postgresql 7.0.2 |
Date: | 2000-10-17 09:53:20 |
Message-ID: | Pine.LNX.4.21.0010170847520.17230-100000@pascal.dicyt.umss.edu.bo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi guys, i have discovered my stupid error. When PostgreSQL 7 is
installed it creates a new directory called data in /var/lib/pgsql, but
the installation does not erase old configuration files so i edited the
old pg_hba.conf instead of the new one in data. I hope this information
will be useful to you. Bye!!
Alexey
On Fri, 13 Oct 2000, Alexey Rodriguez Yakushev wrote:
> Hello guys, i have downloaded and installed PostgreSQL 7.0.2 as
> rpms for redhat. Everything seems to be working, except remote
> authentication, i just added this simple line to pg_hba.conf and it
> doesn't work. BTW i restarted the daemon every time i made a change.
>
> host all 166.114.102.20 255.255.255.255 trust
>
> I can't connect to DB server from 166.114.102.20 when trying to connect i
> get an error message.
>
> $ psql -uh <server host> guia # i answer to username and password
>
>
>
> psql: No pg_hba.conf entry for host 166.114.102.20, user postgres,
> database guia
>
>
>
> I am pretty sure this worked in previous versions. Any hint will be very
> helpful. Please reply directly to me since i am not subscribed to the
> mailing list. Thanks.
> Alexey
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Toma Vailikit | 2000-10-17 13:19:15 | Too many open files in system |
Previous Message | Michel Decima | 2000-10-17 09:24:17 | pltcl, linker and statistical functions |