Re: psql -l

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: will trillich <will(at)serensoft(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: psql -l
Date: 2001-07-17 21:25:56
Message-ID: 200107172125.f6HLPup11802@candle.pha.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".

Ewe, I never realized the problems with disabling template1
connections.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dr. Evil 2001-07-17 22:08:01 PG rules!
Previous Message will trillich 2001-07-17 21:16:46 Re: editor with syntax-highlighting for PL/PGSQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Bill Studenmund 2001-07-17 22:07:01 Re: pg_depend
Previous Message Gregory Wood 2001-07-17 20:54:29 Re: psql -l