Fwd: Logging on without prompt for password

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:35 PM
Subject: Re: Logging on without prompt for password
To: "Rossi, Maria" <maria.rossi@xxxxxxxxxxx>


On Tue, Oct 20, 2015 at 3:24 PM, Rossi, Maria <maria.rossi@xxxxxxxxxxx> wrote:

Thanks for the explanation.  Am relatively new to postgres and its not much used in our shop, hence my difficulty.

But was I using a Unix socket?   I thought I was using host.    The name did not start with a ‘/’,  that’s why am thinking ‘host’.



​Can you please bottom-post (or inline) like the rest of us​.

You said you were trying this:

/usr/pgsql-9.3/bin/pg_dumpall" -U bmcap01 -s -x

Since you do not specify a host here it uses the Unix-socket.  The socket also has a port so saying "-p XXXX" doesn't change the how.  Once you added "-h 127..." it then choose the TCP/IP protocol.

Since your pg_hba.conf file section you showed only defines trust for "host" connections on 127... they didn't match you connection until you added "-h"

The overloaded usage of "socket" and "port" and "host" here makes this area ripe for confusion among the uninitiated.

David J.



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux