postgresql
Alex Snow
alex_snow at h14me.homelinux.net
Tue Jul 15 20:59:25 EDT 2003
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
More information about the Speakup
mailing list