Re: postgres default database deleted!!

the problem is psql doesn't work after deleting this db. Guessing
re-installing is the option.

On Wed, Jan 6, 2010 at 4:15 PM, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>wrote:

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

--
Hilda