On Jul 21, 2010, at 8:48 PM, Fujii Masao wrote: > On Wed, Jul 21, 2010 at 7:29 PM, Robert Haas <robertmh...@gmail.com> wrote: >> On Wed, Jul 21, 2010 at 1:07 AM, Fujii Masao <masao.fu...@gmail.com> wrote: >>> On Tue, Jul 20, 2010 at 11:14 PM, Robert Haas <robertmh...@gmail.com> wrote: >>>> OK, committed. >>> >>> When I specify the path of the directory for the Unix-domain socket >>> as the host, \conninfo doesn't mention that this connection is based >>> on the Unix-domain socket. Is this intentional? >>> >>> $ psql -h"/tmp" -c"\conninfo" >>> You are connected to database "postgres" on host "/tmp" at port "5432" >>> as user "postgres". >>> >>> I expected that something like >>> >>> You are connected to database "postgres" via local socket on >>> "/tmp" at port "5432" as user "postgres". >> >> :-( >> >> No, I didn't realize the host field could be used that way. It's true >> that you get a fairly similar message from \c, but that's not exactly >> intuitive either. >> >> rhaas=# \c - - /tmp - >> You are now connected to database "rhaas" on host "/tmp". > > OK. The attached patch makes \conninfo command emit the following > message if the host begins with a slash: > > $ psql -h/tmp -c"\conninfo" > You are connected to database "postgres" via local socket on > "/tmp" at port "5432" as user "postgres". > > Similarly, it makes \c command emit the following message in that > case: > > $ psql -hlocalhost -c"\c - - /tmp -" > You are now connected to database "postgres" via local socket on "/tmp".
If we print the local socket when it's been explicitly set via the host= param, why not display the actual socket path in the general local socket case? Also, while we're still tweaking this patch, I've had a couple requests for the SSL status of the connection as well; does this seem like a generally useful parameter to display as well? Regards, David -- David Christensen End Point Corporation da...@endpoint.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
