Thread: newbie question:

I have been expirementing with PostgreSQL
but now I have compiled PHP with PostgreSQL
I need an superuser to call the database from my scripts.

Postgres is already defined as the superuser but how
can I set the superuser password ?
Is there a admin script just like MySQL or should
I insert it into the pg_??(group,user) table on the
default database ?

please let me know


Leon

ALTER USER postgres WITH PASSWORD '[enter password]'

http://www.postgresql.org/users-lounge/docs/7.0/user/sql-alteruser.htm

----- Original Message -----
From: "Leon van Dongen" <Leonvd@kabelfoon.nl>
To: <pgsql-general@postgresql.org>
Sent: Monday, December 18, 2000 1:56 AM
Subject: [GENERAL] newbie question:


> I have been expirementing with PostgreSQL
> but now I have compiled PHP with PostgreSQL
> I need an superuser to call the database from my scripts.
>
> Postgres is already defined as the superuser but how
> can I set the superuser password ?
> Is there a admin script just like MySQL or should
> I insert it into the pg_??(group,user) table on the
> default database ?
>
> please let me know
>
>
> Leon