|
|
Re: User Problem In PostgreSQL on Mac OS X: msg#00258
db.postgresql.novice
|
Subject: |
Re: User Problem In PostgreSQL on Mac OS X |
Actually, mine is called postgre without the 's'. Does he have to have
a directory under users?
On Sunday, February 23, 2003, at 05:34 PM, David C. Oshel wrote:
yup ... try "su - postgres" with an ess
there's no /Users/postgre, but there's a /Users/postgres
On Sunday, February 23, 2003, at 04:32 PM, Robert Prather wrote:
Well, I said you'd be hearing from me again. From a command prompt I
type "su - postgre" and enter the password. It says "su: no
directory" and doesn't let me change users. Any idea which directory
it's looking for?
Robert
On Sunday, February 23, 2003, at 03:54 PM, David C.Oshel wrote:
If you're using vanilla OS X, you probably have not enabled the root
user -- which is Mac OS X default behavior for a reason.
Rather than launching a giant project to find out how to enable
root, just use Terminal and enter "sudo su". You will get the usual
sudoers lecture (engrave it on your soul, even if you have only one
user), and you will find yourself staring at the root prompt. God
help you.
This trick is slightly less omnipotent than actually logging in as
root, but the difference between disaster and catastrophe is not
worth mentioning.
Be sure to enter "exit" after you have accomplished the precisely
exact one single thing you needed to masquerade as root for.
D
On Sunday, February 23, 2003, at 02:39 PM, brew@xxxxxxxxxxx wrote:
Now for the stupid part: I forgot the password for that user. I
installed it using FINK and everything went well as I recall. Do I
need to uninstall the software? If so, is there an easy way to do
this?
OS X is Unix (or Unix-like), right? The classic way around this is
sign
on as root and then use passwd to change the password for user
postgres.
I've forgotten the postgres user password myself as have probably
half the
people on this list!
brew
---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
--
David C. Oshel mailto:dcoshel@xxxxxxxx
Cedar Rapids, Iowa http://soli.inav.net/~dcoshel
``Raffiniert ist der Herrgot, aber boshaft ist er nicht." - A.
Einstein
---------------------------(end of
broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Robert Prather
8476873608@xxxxxxxxxxxxxx
--
David C. Oshel mailto:dcoshel@xxxxxxxx
Cedar Rapids, Iowa http://soli.inav.net/~dcoshel
``Raffiniert ist der Herrgot, aber boshaft ist er nicht." - A. Einstein
Robert Prather
8476873608@xxxxxxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|