Postgres Pro
Downloads
Home   >   mailing lists

Thread: Database "postgres"

Database "postgres"

From
"woger151"
Date:
I assume it's harmless to drop the database named "postgres" (named after
the DB superuser)?

Re: Database "postgres"

From
Tom Lane
Date:
"woger151" <woger151@jqpx37.cotse.net> writes:
> I assume it's harmless to drop the database named "postgres" (named after
> the DB superuser)?

You might want to recreate it afterwards, since various tools expect it
to be there (for instance createdb, createuser, "psql -l" will all fail
by default if it isn't there).  But there's nothing especially magic
about it.

            regards, tom lane

Re: Database "postgres"

From
"woger151"
Date:
> "woger151" <woger151@jqpx37.cotse.net> writes:
>> I assume it's harmless to drop the database named "postgres" (named after
>> the DB superuser)?
>
> You might want to recreate it afterwards, since various tools expect it
> to be there (for instance createdb, createuser, "psql -l" will all fail
> by default if it isn't there).  But there's nothing especially magic
> about it.
>
> regards, tom lane

Thanks for the quick response!  And if your email address is correct, at a
very early hour in the morning.

Re: Database "postgres"

From
Raymond O'Donnell
Date:
woger151 wrote:

> Thanks for the quick response!  And if your email address is correct, at
> a very early hour in the morning.

Our Tom never sleeps.....

Ray.


---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------