Re: postgres default database deleted!!

Поиск
Список
Период
Сортировка
От Hilda Raymond
Тема Re: postgres default database deleted!!
Дата
Msg-id feeb312b1001062002j3c465b3ei81feb761d9083d53@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgres default database deleted!!  (Gurjeet Singh <singh.gurjeet@gmail.com>)
Ответы Re: postgres default database deleted!!
Список pgsql-novice
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.gurjeet@gmail.com> wrote:
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



--
Hilda

В списке pgsql-novice по дате отправления:

Предыдущее
От: Hilda Raymond
Дата:
Сообщение: Re: postgres default database deleted!!
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgres default database deleted!!