Fwd: Urgente, postgres down

( Disculpad el duplicado, mande el original solo a Horacio, fallo mio )
Horacio:

On Thu, Feb 14, 2019 at 10:14 AM Horacio Miranda <hmiranda(at)gmail(dot)com> wrote:
> una copia cerrada que no puedes usar.
( hablabamos del t0/t1, t1 es el corazon, etc... pero con el
top-posting no veo como meter la cita correcta ).

No recuerdo ahora, pero no podias usarla especificamente para
regenerar template1?

-- No tengo fuentes de esto en castellano, pero...
Notes from https://www.postgresql.org/docs/11/manage-ag-templatedbs.html

"template1 and template0 do not have any special status beyond the
fact that the name template1 is the default source database name for
CREATE DATABASE. For example, one could drop template1 and recreate it
from template0 without any ill effects. This course of action might be
advisable if one has carelessly added a bunch of junk in template1.
(To delete template1, it must have pg_database.datistemplate =
false.)"

*** Editado al copiar a la lista:

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.
23 *
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.