Samy Elashmawy <[EMAIL PROTECTED]> writes:
| Jerry thanks for the info below. Now I am more confused.
|
| I installed the three packackages , pgaccess , postgress and pg_iface.
| ALL form the suse 6.0 distro.
If you do want an initial database, please install pg_datab as well.
| However the suse distro changes all the paths and install
| direcories.
On SuSE Linux, the whole PostgreSQL environment live under
/usr/lib/pgsql -- on request by customers, BTW ;-) And I think, that's a
good idea.
After installing the packages run
rcpostgres start
as root.
Then, from the root account login as the user "postgres"; simply issue
an
su - postgres
Please note the "-" (dash) to get a login shell; this way the postgres
profile fragments at /etc/profile.d/postgres* will be sourced.
As postgres, create users which should be able to manage databases:
createuser
etc.
Login as this user (login shell) an use one of the available
interfaces; start with "createdb".
| >~/.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
Not need to do this; you'll find profile fragments at the above
mentioned place, that are source by /etc/profile
--
Karl Eichwalder
--
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
