Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Logging on without prompt for password - Mailing list pgsql-admin

From David G. Johnston
Subject Fwd: Logging on without prompt for password
Date
Msg-id CAKFQuwZj5KSyfJnBSmYp9MMMiHHXqoqSz_pKYXH=jo5XrRM36A@mail.gmail.com
Whole thread Raw
In response to Logging on without prompt for password  ("Rossi, Maria" <maria.rossi@jackson.com>)
List pgsql-admin
Tree view
OP decided to stop sending messages to the list....

---------- Forwarded message ----------
From: David G. Johnston <david.g.johnston@gmail.com>
Date: Tue, Oct 20, 2015 at 3:13 PM
Subject: Re: [ADMIN] Logging on without prompt for password
To: "Rossi, Maria" <maria.rossi@jackson.com>
Cc: Glauco Torres <torres.glauco@gmail.com>, "scottm@openscg.com" <scottm@openscg.com>


On Tue, Oct 20, 2015 at 3:03 PM, Rossi, Maria <maria.rossi@jackson.com> wrote:

No, am not using pgbouncer

Pg_dumpall is running with in the server

Here’s a portion of my pg_hba.conf

                host    all             bmcap01        127.0.0.1/32            trust

                host    all             psgdba           127.0.0.1/32            trust

 

I tried this one,   this is working:   (ye-hey!!)

                pg_dumpall -p 40101 -h 127.0.0.1 -U psgdba



​You should acquire an understanding of the difference between "host" and "local" - only the former of which uses TCP/IP addresses and ports.

Once that is done the following will make a bit more sense:

host
Name of host to connect to. If this begins with a slash, it specifies Unix-domain communication rather than TCP/IP communication; the value is the name of the directory in which the socket file is stored. The default behavior when host is not specified is to connect to a Unix-domain socket in /tmp (or whatever socket directory was specified when PostgreSQL was built). On machines without Unix-domain sockets, the default is to connect to localhost.

Note especially the default behavior on the "Unix-domain" socket system - which you are using.

David J.
​

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Fwd: Logging on without prompt for password
Next
From: "David G. Johnston"
Date:
Subject: Fwd: Logging on without prompt for password