Newbie: pg_hba.conf question

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

Newbie: pg_hba.conf question

От:
Marc Poinot <Marc.Poinot@onera.fr>
Дата:


Hi all,
I'm trying to use psql on SGI irix 6.
The build and install process seems to be ok, but
when I try to run the regress test suite, the
client commands failed. The postmaster had
started correctly, but no way to connect it.

The error looks like a well known one (see chapter 12 of
admin guide), but I cannot solve it:

The client says:

marcvs> psql
psql: No pg_hba.conf entry for host localhost, user marcvs, database marcvs

The pg_hba.conf in the PGDATA actually contains a line with:

local all trust

- Any well known install problem ?

-MP- 
 
-----------------------------------------------------------------------
 Marc POINOT             Alias: marcvs        Email: poinot@onera.fr
 ONERA -MFE/DSNA/ELSA    Tel: 01.46.73.42.84  Info: elsa-info@onera.fr
 29, Div. Leclerc        Fax: 01.46.73.41.66  Site:     
 92322 Chatillon FRANCE  Project: elsA        Web: http://www.onera.fr

Storing data question

От:
"Bogdan Paduraru" <bpaduraru@petar.ro>
Дата:
Hi all,
I wonder if I can store the contents of a file ? For exmple I have a file
named myfile.txt and I want to store everything that is in it in a table in
a field of type text. Is this possible? Is there any SQL statement to
perform that or some utility?

Thanx,

Bogdan

Re: Newbie: pg_hba.conf question

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
Marc Poinot writes:

> marcvs> psql
> psql: No pg_hba.conf entry for host localhost, user marcvs, database marcvs
> 
> The pg_hba.conf in the PGDATA actually contains a line with:
> 
> local all trust

"local" is not the same a "localhost".  The former refers to a Unix domain
socket connection, the latter to a TCP/IP connection, which requires a
"host" record in pg_hba.conf.  To use a "local" connection you need to
unset the PGHOST environment variable, in case you have it set.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

Re: Newbie: pg_hba.conf question

От:
Marc Poinot <Marc.Poinot@onera.fr>
Дата:
Peter Eisentraut wrote:
> 
> Marc Poinot writes:
> 
> > marcvs> psql
> > psql: No pg_hba.conf entry for host localhost, user marcvs, database marcvs
> >
> > The pg_hba.conf in the PGDATA actually contains a line with:
> >
> > local all trust
> 
> "local" is not the same a "localhost".  The former refers to a Unix domain
> socket connection, the latter to a TCP/IP connection, which requires a
> "host" record in pg_hba.conf.  To use a "local" connection you need to
> unset the PGHOST environment variable, in case you have it set.
> 
Thanks for the answer.
Actually, I did rebuild the software with a -n32 mode instead of
the -64 (our SGI default). I works perfectly, but we also made
some adds for distant hosts in pg_hba.conf, thus I cannot really
tell you which modification was the right one.

-MP- 

-----------------------------------------------------------------------
 Marc POINOT             Alias: marcvs        Email: poinot@onera.fr
 ONERA -MFE/DSNA/ELSA    Tel: 01.46.73.42.84  Info: elsa-info@onera.fr
 29, Div. Leclerc        Fax: 01.46.73.41.66  Site:     
 92322 Chatillon FRANCE  Project: elsA        Web: http://www.onera.fr
FAQ