| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John J. Urbaniak | 2010-01-06 19:14:16 | Error on Vacuum? |
| Previous Message | Pushpendra Singh Thakur | 2010-01-06 10:44:45 | Re: postgres default database deleted!! |