On Wed, 2005-03-09 at 01:32, Eduardo Mambrilla MartÃnez wrote:
> I made a mistake, I droped the template0 database...
> How can I recreate it?

Do you still have template1?  If so, connect in single user mode, enter:
postgres template1
create database template0 with template template1
update pg_database set datallowconn = false where datname='template0';

Use CTRL-D to exit.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to