Karl Eichwalder wrote:
>
> 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
True. As I said in my intial note to Samy, I had removed Postgres from
my system several months ago while I tested other db engines like
Oracle, Sybase, MySQL and some others, and when I reinstalled it I used
the latest version from www.PosgreSQL.com and compiled and installed it
manually. Thanks for the additional guidance to Samy!
JLK
>
> --
> Karl Eichwalder
--
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
