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