Re: Switch to Linux Dev Questions
От | David |
---|---|
Тема | Re: Switch to Linux Dev Questions |
Дата | |
Msg-id | 20060506212125.GA1333@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Switch to Linux Dev Questions (<operationsengineer1@yahoo.com>) |
Ответы |
Re: Switch to Linux Dev Questions
|
Список | pgsql-novice |
On Sat, May 06, 2006 at 08:27:09AM -0700, operationsengineer1@yahoo.com wrote: > > On 5/6/06, operationsengineer1@yahoo.com > > <operationsengineer1@yahoo.com> wrote: > > > hi all, > > Hello again! > > > why do i have to su to root before i su to postgres (in order to > > > run psql)? i tried to su from my username and it asked for a > > > password and said authentication failed - there is no password. > > For security reasons service-accounts are commonly password-less, > > and the account disabled. Usually one achieves that with a passwd > > -l <account> That way only root is able to switch to that user if it > > is (for some reason) required. > thanks for the explanations. it makes sense now. no > password means one must login from root to protect the > account. This question has been answered quite well. However, to take it one step further, if you want to get a bit fancy, you can su from the user straight to postgres in one command thus: su -c 'su postgres -c "psql blah"' Then, when you exit psql, you drop straight back to the user instead of root. Do note that you may have to watch out for quoting perhaps escaping the quotes if you need quotes in the command (where I used "psql blah"), since both the single and double quotes are being used. Bruno Wolfe suggested using the -U option for psql, but I use 'ident sameuser' authentication for postgres, and the -U method doesn't work for me. > > > also, i tried help in psql and when i got to the > > end, > > > i was stuck. there was no intuitive way to get > > out. > > > i just saw END with no way to do anything - i > > closed > > > the session and started again. > > \q ... it may not be "intuitive", but it's > > well-documented. > > actually, it wouldn't let me type anything. i believe > i tried \q b/c i am aware of it, but nothign would > type over the END that was displayed on the shell. > > if it happens again, i will type \q and see if i just > missed it last time. Actually, in this case, you're in a pager ('less' or 'more' probably) and you simply type "q" to exit the pager. If I try "\q", it beeps on the "\" but then exits on the "q". This is the case also (at least the way my system is set up) when you're displaying a select query when it's more than one screen long. pressing SPACE or PAGE DOWN (probably) will scroll down one screen, pressing "b" or PAGE UP (probably) will scroll up - well, if you are not familiar with the pager, find out what pager is being used (probably "less") and check the manpage for it. There are several features that you will find useful. You might even try "man pager". There are several pagers and many distributions use a default name "pager" which acts as sort of an alias for the actual pager you use.
В списке pgsql-novice по дате отправления: