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 >
