Re: Re: Restore template1

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