Re: Granting permission to root.

On 24 Jul 2002, montfort wrote:

> How can I grant permission to root so that the root user can create
> and drop databases?

From a UNIX/Linux command prompt as root

    su - postgres
    createuser --createdb --adduser root

From a psql prompt logged in as postgres to template1

    CREATE USER root CREATEDB CREATEUSER;

Other options for assigning passwords, groups and other options is
avaliable by doing

    createuser -?

from the command prompt or

    \h create user

from the psql prompt


Actually the best deal is to buy, both or either, Bruce's book, The
Mammoth book (O'Reilly) or check out the docs.


Rod
--
  "Open Source Software - Sometimes you get more than you paid for..."