Thread: Newbie: pg_hba.conf question

Newbie: pg_hba.conf question

From
Marc Poinot
Date:

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

From
"Bogdan Paduraru"
Date:
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

From
Peter Eisentraut
Date:
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

From
Marc Poinot
Date:
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