Re: Re: Restore template1 - Mailing list pgsql-admin

From Oliver Elphick
Subject Re: Re: Restore template1
Date
Msg-id 200012202240.eBKMe4P00769@linda.lfix.co.uk
Whole thread Raw
In response to Re: Restore template1  (Luis Sousa <llsousa@ualg.pt>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: "Michael B. Babakov"
Date:
Subject: RE:
Next
From: R D
Date:
Subject: Is that a bug?