Thread: Newbie: pg_hba.conf question
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
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
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/
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