Re: postgres default database deleted!!

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.

--
Hilda

--
Hilda

if you have deleted the database named "postgres", no need to worry, it was
empty.

2010/1/6 Hilda Raymond <hildaraymond(at)gmail(dot)com>

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

--
Pushpendra Singh Thakur

COREEXPERTS Technologies Private Limited
Business Process Automation & IT Support Services
http://www.corexprts.com
Phone - 91-761-4070036
Fax - 91-761-4010530
SMS - 91-799-66554

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

Thank you :-)

On Wed, Jan 6, 2010 at 4:14 PM, Pushpendra Singh Thakur <
thakur(at)corexprts(dot)com> wrote:

> if you have deleted the database named "postgres", no need to worry, it was
> empty.
>
> 2010/1/6 Hilda Raymond <hildaraymond(at)gmail(dot)com>
>
>
>>
>>
>> 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.
>>
>> --
>> Hilda
>>
>>
>>
>>
>> --
>> Hilda
>>
>>
>
>
> --
> Pushpendra Singh Thakur
>
> COREEXPERTS Technologies Private Limited
> Business Process Automation & IT Support Services
> http://www.corexprts.com
> Phone - 91-761-4070036
> Fax - 91-761-4010530
> SMS - 91-799-66554
>

--
Hilda

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

Hilda Raymond <hildaraymond(at)gmail(dot)com> writes:
> the problem is psql doesn't work after deleting this db. Guessing
> re-installing is the option.

Sure it does, just connect to some other database.

regards, tom lane