Re: Urgente, postgres down

>
>
> *Fransisco dijo: *
> Tras refrescar mi memoria haciendo lo que deberia haber hecho antes (
> "The Source Luke, use The Source"), he consultado
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/bin/initdb/initdb.c;h=fd50a809ea4f0096c27b7f082dc9576f372e379e;hb=HEAD
> Donde claramente se ve que el orden es t1/t0:
>
> 3 * initdb --- initialize a PostgreSQL installation
> 4 *
> 5 * initdb creates (initializes) a PostgreSQL database cluster (site,
> 6 * instance, installation, whatever). A database cluster is a
> 7 * collection of PostgreSQL databases all managed by the same server.
> 8 *
> 9 * To create the database cluster, we create the directory that
> contains
> 10 * all its data, create the files that hold the global tables, create
> 11 * a few other control files for it, and create three databases: the
> 12 * template databases "template0" and "template1", and a default user
> 13 * database "postgres".
> 14 *
> 15 * The template databases are ordinary PostgreSQL databases.
> template0
> 16 * is never supposed to change after initdb, whereas template1 can be
> 17 * changed to add site-local standard data. Either one can be copied
> 18 * to produce a new database.
> 19 *
> 20 * For largely-historical reasons, the template1 database is the one
> built
> 21 * by the basic bootstrap process. After it is complete, template0
> and
> 22 * the default database, postgres, are made just by copying template1.
>
Entonces, podria eliminar mi template0 y volverlo a crear desde template1?,
claro esta, que esto solo lo haria en caso que no encuentre como diminuir
el XID de template0.

> 24 * To create template1, we run the postgres (backend) program in
> bootstrap
> 25 * mode and feed it data from the postgres.bki library file. After
> this
> 26 * initial bootstrap phase, some additional stuff is created by normal
> 27 * SQL commands fed to a standalone backend. Some of those commands
> are
> 28 * just embedded into this program (yeah, it's ugly), but larger
> chunks
> 29 * are taken from script files.
>
>
>
>
> Francisco Olarte.
>
>