Re: psql -l

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: will trillich <will(at)serensoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql -l
Date: 2001-07-17 20:34:29
Message-ID: 26349.995402069@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

will trillich <will(at)serensoft(dot)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".

regards, tom lane

In response to

  • psql -l at 2001-07-17 16:11:56 from will trillich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-17 20:47:46 Re: Foreign Keys
Previous Message Peter Eisentraut 2001-07-17 19:26:02 Re: psql -l

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-07-17 20:36:45 Re: Re: Idea: recycle WAL segments, don't delete/recreate 'em
Previous Message Tom Lane 2001-07-17 20:26:56 Re: pg_depend