Re: Lost my postgres database? - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Lost my postgres database?
Date
Msg-id dcc563d10904121718p5cb5f2f1lef30f83c5999948b@mail.gmail.com
Whole thread Raw
In response to Lost my postgres database?  (Kevin Bailey <kbailey@freewayprojects.com>)
List pgsql-admin
On Sun, Apr 12, 2009 at 6:08 PM, Kevin Bailey
<kbailey@freewayprojects.com> wrote:
> Hi,
>
> Just looking into an old 7.4 based server and the '\l' command isn't showing
> a database called 'postgres' - template0 and template1 are there.
>
> Is this expected on 7.4?  I've read the docs and can't see any mention of
> this DB.  Should this DB exist?

Yep.  template1 used to be the primary database for what the purpose
the postgres database now serves.  You only get the template0/1
databases in 7.4

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lost my postgres database?
Next
From: Kevin Bailey
Date:
Subject: Re: Lost my postgres database?