postgresql

[Hugh Esco]

The postgreSQL Admin Manual says that the short take on installation goes
as follows:

./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

Your administrative control over the database server is exercised by the
postgres user.  Adding a postgres user in the OS and using it to invoke
the script to create the Template0 and Template1 databases (that's the
initdb script spoken of above), will set up the server and as the postgres
user, allow you full administrative control.

-- Hugh Esco

On Tue, 15 Jul 2003, Alex Snow wrote:

> Hi all. Anhyone know how to add the root user in postgresql? I followed
> the installation/configuration instructions included but I couldn't find
> anything about the root user. however I cand really do anything bc it
> says there is no root user.
>
> _______________________________________________
> Speakup mailing list
> Speakup at braille.uwo.ca
> http://speech.braille.uwo.ca/mailman/listinfo/speakup
>