millerd wrote:
>
> When trying to start up postgres for the first time (using the suse
> support data base PostgresSQL: First steps as a guide)
>From my experience,this should do the trick.
#Ok,if i remember ??.
#as root.....
#first remove any postgres.lock files you may have in /tmp or /var/tmp
#then, to make sure do..
/sbin/init.d/postgres stop
#This ensures that the postmaster daemon stops so we can
#do our modifications.
su postgres
#pico .bashrc (or any favorite editor)
#add the following...
export PGLIB=/usr/lib/pgsql/lib
export PGDATA=/var/lib/pgsql/data
#save this...
#Then type..
source .bashrc
#this renews your bashlogin without logging out
exit
#as root...
/sbin/init.d/postgres start
#you should see that postmaster now runs.
su postgres
createuser denis
exit
#Also make sure that the stanza START_POSTGRES in /etc/rc_config reads
#yes.yast can do this or you edit by hand.This ensures that postmaster
is
#started on boot.
#then as user denis
#edit your .bashrc to include the following
export PGLIB=/usr/lib/pgsql/lib
export PGDATA=/var/lib/pgsql/data
#as before do
source .bashrc
createdb databasename
#then..
psql databasename
# You will/may find this procedure useful again if you upgrade
# postgres or it fails to works at sometime.Always dump your databases
# down before an upgrade.
#I hope this helps,its from memory so..
#have fun.
--
Myfish.
Email [EMAIL PROTECTED]
0 0
o
`---'
-
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
archiv at http://www.suse.com/Mailinglists/suse-linux-e/index.html
