OP decided to stop sending messages to the list....
---------- Forwarded message ----------
From: David G. Johnston <david.g.johnston@xxxxxxxxx>
Date: Tue, Oct 20, 2015 at 3:13 PM
Subject: Re: Logging on without prompt for password
To: "Rossi, Maria" <maria.rossi@xxxxxxxxxxx>
Cc: Glauco Torres <torres.glauco@xxxxxxxxx>, "scottm@xxxxxxxxxxx" <scottm@xxxxxxxxxxx>
From: David G. Johnston <david.g.johnston@xxxxxxxxx>
Date: Tue, Oct 20, 2015 at 3:13 PM
Subject: Re: Logging on without prompt for password
To: "Rossi, Maria" <maria.rossi@xxxxxxxxxxx>
Cc: Glauco Torres <torres.glauco@xxxxxxxxx>, "scottm@xxxxxxxxxxx" <scottm@xxxxxxxxxxx>
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.
