Database "postgres"

Started by woger151about 19 years ago4 messagesgeneral
Jump to latest
#1woger151
woger151@jqpx37.cotse.net

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: woger151 (#1)
Re: Database "postgres"

"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

#3woger151
woger151@jqpx37.cotse.net
In reply to: woger151 (#1)
Re: Database "postgres"

"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.

In reply to: woger151 (#3)
Re: Database "postgres"

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
---------------------------------------------------------------