Re: psql -l

On Tue, Jul 17, 2001 at 04:34:29PM -0400, Tom Lane wrote:
> will trillich <will@serensoft.com> writes:
> > in the old days (7.0.3) i could list databases via
> >     psql -l
> > but these days (7.1) i must
> >     psql -l [-d] nameOfADatabaseFromPreordainedKnowledge
> > probably because of some fuxnored setting. but which?
>
> Sounds like you've got pg_hba.conf set to disallow connections to
> template1, which is what psql tries to connect to when executing
> a plain "psql -l".

here's the totality of pg_hba.conf (sans comments):

# grep -v '#' /etc/postgresql/pg_hba.conf | uniq

local        all                                           trust
host         all         127.0.0.1     255.0.0.0           trust
host         all         192.168.1.0   255.255.255.0       trust
host         all         0.0.0.0       0.0.0.0             crypt

$ psql -V
No database specified

$ psql -V template0
psql (PostgreSQL) 7.1
contains readline, history, multibyte support
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.


curiouser and curiouser.

--
I'd concentrate on "living in the now" because it is fun
and on building a better world because it is possible.
    - Tod Steward

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!