Thread: Restore template1
There's a way to backup template1 to restore it when happens a disaster without installing again PostgreSQL ??? Regards -- Luis Sousa Tecnico Superior de Informatica Gabinete de Assessoria e Planeamento Universidade do Algarve
On Mon, Dec 18, 2000 at 03:49:18PM +0000, Luis Sousa wrote: > There's a way to backup template1 to restore it when happens a disaster > without installing again PostgreSQL ??? Doesn't "initdb" create the template1 database? -- Ragnar Kjørstad
What really does "initdb" ? It creates a new database system but is for use of the user that created her !!! Luis Sousa Ragnar Kjørstad wrote: > On Mon, Dec 18, 2000 at 03:49:18PM +0000, Luis Sousa wrote: > > There's a way to backup template1 to restore it when happens a disaster > > without installing again PostgreSQL ??? > > Doesn't "initdb" create the template1 database? > > -- > Ragnar Kjørstad
Luis Sousa wrote: >What really does "initdb" ? > >It creates a new database system but is for use of the user that created her >!!! initdb creates the database structure including a database (template1) which is the model for all other databases created in the future. The whole structure is owned by the UNIX user who ran initdb and a PostgreSQL user of the same name is created. This user is the PostgreSQL administrator, who can create other users (PostgreSQL users, not Unix users) and databases. He can give other users the right to create databases; tables in a database belong to the PostgreSQL user who creates the tables. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "And she shall bring forth a son, and thou shall call his name JESUS; for he shall save his people from their sins." Matthew 1:21