Обсуждение: 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
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
if you have deleted the database named "postgres", no need to worry, it was empty.
--
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
2010/1/6 Hilda Raymond <hildaraymond@gmail.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
Thank you :-)
--
Hilda
On Wed, Jan 6, 2010 at 4:14 PM, Pushpendra Singh Thakur <thakur@corexprts.com> wrote:
if you have deleted the database named "postgres", no need to worry, it was empty.2010/1/6 Hilda Raymond <hildaraymond@gmail.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.
--
Hilda
On Wed, Jan 6, 2010 at 4:15 PM, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
You can simply recreate the DB like so: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.
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
Hilda Raymond <hildaraymond@gmail.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