Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres default database deleted!! - Mailing list pgsql-novice

From Gurjeet Singh
Subject Re: postgres default database deleted!!
Date
Msg-id 65937bea1001060245t44145facv16b44c0a59e5de09@mail.gmail.com
Whole thread Raw
In response to postgres default database deleted!!  (Hilda Raymond <hildaraymond@gmail.com>)
Responses Re: postgres default database deleted!!
List pgsql-novice
Tree view
On Wed, Jan 6, 2010 at 1:02 PM, Hilda Raymond <hildaraymond@gmail.com> wrote:



Hi,

 Im new to postgres and and as soon as I listed databases using the psql -l command, i accidentally deleted the postgres default database. Im not sure what to do. Appreciate any help Thank you.


You can simply recreate the DB like so:

create database postgres;

It will take everything from the template1 database and make a copy by the name 'postgres'.

Best regards,
--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.enterprisedb.com

singh.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device

pgsql-novice by date:

Previous
From: Hilda Raymond
Date:
Subject: postgres default database deleted!!
Next
From: Pushpendra Singh Thakur
Date:
Subject: Re: postgres default database deleted!!