At 12:53 AM 1/25/03 -0600, will trillich wrote:
>any chance you can help onjure a rough draft of what would have
>helped you get up-to-speed? maybe we can help out the next guy
>that way.
>
>just a couple of paragraphs: "Chris's Quick-Start Guide to
>PostGREsql v7.x.x". hmm?
The detailed HTML docs are actually fine.
And there is a short version which works. But sets up what seems to be a
quick for test install with a superuser, no other users, and no startup and
shutdown scripts.
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/installation.html
So far that's much better than the Oracle doc I last saw- a huge thick
installation manual which is written for everyone and no one because it is
full of details for different scenarios. I had to turn to 3rd party Oracle
HOWTO to install Oracle- and it was a lot easier :).
Maybe people want an intermediate version?
From memory my steps are usually:
Follow the INSTALL.TXT, configure, compile, regression test and if ok,
install the software.
Create a pgsql or postgres O/S user.
Set up the filesystem permissions and structure for the "database
cluster/instance".
do the initdb. Includes where you want the instance's logs to go.
Configure O/S to start postgresql instance on bootup (copy contrib scripts
over or write own using the pg_ctl stuff).
psql -U pgsql template1
alter user pgsql with password 'superuserpassword';
create user myuser with password 'blahblah' createdb;
\c - myuser
create database myuser;
edit pg_hba.conf to use passwords (note you may wish to use a different
authentication method).
restart postgresql instance.
Voila, postgresql up with one super user and one power user.
Note that most people won't want to follow my install because requiring
authentication breaks many Postgresql commandline utilities (not sure if
this is changed, since I haven't been using most of them - coz they didn't
work for me ;) ).
HTH,
Link.
