On Tuesday 13 November 2001 13:18, you wrote: > hi andre! > > thx very much for the advice! it worked! :) > > out of curiosity, are you using postgres as mandrake pre-installed it (in > /var/lib/pgsql/data) or have you changed the location and create your own > db/installation? > > thx again! :) > > At 11:09 01/11/13 -0500, you wrote: > >On Tuesday 13 November 2001 01:41, you wrote: > > > i'm trying to create a new user in postgres (createuser [user]), but > > > when logged in as root or any other user, i get "permission denied". i > > > tried to "su postgres", but it prompts me for the password, which seems > > > to have been set by default by mandrake. does anyone know what it is? > > > if i log in as root and 1) change the password or 2) remove the > > > postgres user and create a new one with a new password, will the > > > postgres startup service still work? > > > > > > > > > thank you very much, > > > > > > a linux and postgres newbie... > > > >Hi tek1! > > > >I sure hope you'll get better help than this! (I'm going through the > > learning curve for Postgresql from LM8.0). > > > >I'll be using PostgreSQL with Linux-Kontor (an accounting package), and > > the install instructions for Postgresql are fairly clear. You might want > > to check them out. > > > >Anyway, while as root user, change the password for the user "postgres" -- > >then exit the root shell. > > > >su postgres [use your new password when it prompts you] > > > >To answer your questions: > >1) I've done it, and the postgres startup service still seems to work > > (though I'm having all sorts of probs with postmaster and its refusal to > > accept connection in the gui Postgresql Access. > > > >2) Hopefully?? Check out the Newbie Mail Archive: RE:[ newbie] postgresql. > >There were an articleson what you were asking. > > > >Wish I could help more . . . > >Andre > >
Hi tek! Nope. I'm using the pre-installed version. Btw, shortly after I sent the last reply, I solved my problems with gui Postgresql Access. In case you run into the same problem: it took me three days to figure this one out - I forgot to su to root (and exit after!) for: bash$ export DISPLAY=<hostname>:0.0 As soon as I had entered this, of course I could access the db! (A big duhh here!). I've found that if I plug away at something long enough, I get to know the program. I was going to change LM's directory settings, but after reading enough, I left them alone. I works great! Btw the listing from Konrad Hernblad?? was mine -- I don't know how that happened! Now comes the fun stuff -- formatting the table structure. Have fun! Regards, Andre -- Please pray the Holy Rosary to end the holocaust of abortion and terrorism. For a free Cenacle Scriptural Rosary Booklet -- http://www.webhart.net/csrb/
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com