Hi. Thanks for the info. That cleared up a few things.On Tue, Jul 15, 2003 at 03:57:29PM -0700, Hugh Esco wrote: > 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 > > > > _______________________________________________ > Speakup mailing list > Speakup at braille.uwo.ca > http://speech.braille.uwo.ca/mailman/listinfo/speakup
