postgres db deleted and recreated... "No directory, logging in with HOME=/" error...

hi all,

thanks for the good information and advise. i've
learned something from everyone's replies. i have
open office open and i'm keeping good notes.

i'm now reading up on how to create a role for my os
user so that the os user can have full privileges on
the db.

i think this won't be a problem.

so why am i posting, you ask? great question. ;-)

well, i dropped the "postgres" db in order to create a
"rails" db. i tried to do some stuff and i kept
getting the error that postgres didn't exist. then i
remembered that was likely because it was the default
db required to work with other dbs.

ooops!

i had created a postgres db earlier, so i thought
deleting postgres would only impact what i had
previously created (i think postgres already existed
in the distro, now that i look back).

anyway, i recreated postgres, but when i "su -
postgres"... i get the following error:

No directory, logging in with HOME=/

i think i must've deleted a directory when i deleted
postgres and it wasn't recreated when i recreated
postgres.

what can i do, if anything, to get back on track after
delting and recreating the postgres db? i'm running
simply mepis, which is based on debian.

as always, tia...

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com