Robert Copelan wrote:
>
> I have just installed PostgreSQL from the distribution CDs. However I don't
> find the commands below.
> Do I need to run them from a particular directory?
> Robert
>
I'll assume a standard installation for postgres, pgaccess and pg_iface
...
The documentation for all the packages are in the the appropriate
subdirectory of:
/usr/doc/packages/
Under it you will find /posgres, /pg_iface, /pgaccess and /mpsql.
Under the postgres directory is the /html directory. Loading the
index.html and selecting the "Installation" URL, you can go to chapter
3, "Installation:. Step 14 and 15 are very important, but rather than
putting the stuff (if the install didn't already do it) in
~/.bash_profile or ~/.profile, put it in /etc/profile.
In /etc/profile you can put
PGLIB=/usr/lib/pgsql/lib
PGDATA=/var/lib/pgsql/data
export PGLIB
export PGDATA
in the 'for DIR' loop insert somewhere:
/usr/lib/pgsql/lib \
/usr/lib/pgsql/bin \
/var/lib/pgsql/data \
These settings let PostgreSQL know here it's libraries were installed
and where the data is located.
If the boot process doesn't already install the PostgreSQL deamon,
postmaster, then you need to fire it up with the -i argument from the
postgres account using:
postmaster -i >>~/server.log 2>&1 &
The chapter 3 gives other techniques and switches for the postmaster,
especially page 13 which gives a method of installing postmaster via
inittab in a way that causes it to respawn if it get closed down for any
reason. I chose not to use that method. I want to control when it
starts and when it stops. I don't want it running if I am not using it.
Like any good Linux user you will want to read through the documentation
once before you start messing around. Also, once you get it installed,
going through the tutorial, which features psql, is a very good idea.
Also, after installing pgaccess, when you fire it up it will ask for a
hostname, a user name, and a database. If you followed the tutorial
then you already have an account (created from the template1 account)
that contains the 'weather' database and some data in it.
JLK
--
JLK
Linux, because it's STABLE, the source code is included, the price is
right.
--
To get out of this list, please send email to [EMAIL PROTECTED] with
this text in its body: unsubscribe suse-linux-e
Check out the SuSE-FAQ at http://www.suse.com/Support/Doku/FAQ/ and the
archive at http://www.suse.com/Mailinglists/suse-linux-e/index.html
