Re: postgresSQL: howto start the machinery

[Britton <fsblk@aurora.uaf.edu>]

You have to be user postgres to create postgreSQL users.  As root,
you can become any username you want like this:

su username


Britton Kerin
__
GNU GPL: "The Source will be with you... always."

On Tue, 30 Jan 2001, Olivier Billet wrote:

> Hi everyone,
>
> i'd like to use postgreSQL but running createuser as root
> throw me this error message :
>
> | $  createuser
> | Connection to database 'template1' failed.
> | FATAL 1:  SetUserId: user 'root' is not in 'pg_shadow'
> |
> | createuser: database access failed.
>
> how to set up the postgresql machinery ?
>
> Thanks,
> Olivier.
>