| From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Luis Sousa <llsousa(at)ualg(dot)pt> |
| Cc: | Ragnar Kjørstad <postgres(at)ragnark(dot)vestdata(dot)no>, pgsql Admin Mailing List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Re: Restore template1 |
| Date: | 2000-12-20 22:40:03 |
| Message-ID: | 200012202240.eBKMe4P00769@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)Elphick(at)lfix(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | R D | 2000-12-21 08:14:57 | Is that a bug? |
| Previous Message | Michael B. Babakov | 2000-12-20 19:42:32 | RE: |