p wrote: >> here's all i did: >> >> 1. # su postgres >> >> 2. createuser <foo> >> >> 3. createdb <foo> >> >> 4. $ psql <data-base foo: the "foo" for #3 above> >> >> >> >> synopsis: >> >> 1: to change to postres "administrator"; >> >> 2: to create "user"/non-root access (to the postgres >> "server"); >> >> 3: to create a database; >> >> 4: to start a "console" session of postgresql. (or, >> if you want a gui "frontend," try (apt-get install) >> pgaccess or gtksql.) >> >> >> hth. >> >> bentley taylor. >> >> // > >...sorry, upon re-reading your email, i should have just >said that "$ su postgres" should be "# su postgres" (or >in other words, it should be setup as "root.")
No, that's not necessary and makes no difference, except that in the latter case, it would be root's environment rather than the logged-in user's that would be used. The only real difference from doing 'su postgres' as root is that you would not be asked for a password. What you should do, however, is 'su - postgres' which will read the login environment for the postgres user. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "If my people, which are called by my name, shall humble themselves, and pray, and seek my face, and turn from their wicked ways; then will I hear from heaven, and will forgive their sin, and will heal their land." II Chronicles 7:14
