Skip site navigation (1) Skip section navigation (2)

Re: postgres default database deleted!!

From: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
To: Hilda Raymond <hildaraymond(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: postgres default database deleted!!
Date: 2010-01-06 10:45:16
Message-ID: 65937bea1001060245t44145facv16b44c0a59e5de09@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, Jan 6, 2010 at 1:02 PM, Hilda Raymond <hildaraymond(at)gmail(dot)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(dot)gurjeet(at){ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device

In response to

Responses

pgsql-novice by date

Next:From: John J. UrbaniakDate: 2010-01-06 19:14:16
Subject: Error on Vacuum?
Previous:From: Pushpendra Singh ThakurDate: 2010-01-06 10:44:45
Subject: Re: postgres default database deleted!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group