[plug] DebNewbie Q?

[sol]

Thanks for your advice Jeremy.
But I'm still stuck. Here's what I got:
(console 1)
postgres at debian:~$ psql
Connection to database 'template1' failed.
ERROR: mdopen: couldn't open /var/lib/postgres/data/pg_shadow: 
Permission denied
(console 2)
debian:/home/sol# destroyuser sol
Connection to database 'template1' failed.
ERROR: mdopen: couldn't open /var/lib/postgres/data/pg_shadow: 
Permission denied
destroyuser: database access failed.

And just for the record:
debian:/home/sol# ls -l /var/lib/postgres/data/pg_shadow
-rw------- 1 sol    postgres    8192 Nov    3    04:00     
/var/lib/postgres/data/pg_shadow

Should I change the user back to postgres with suidregister and then 
createuser sol?

Sol

Jeremy Malcolm wrote:

> sol wrote:
> 
>> Connection to database 'template1' failed.
>> ERROR: mdopen: couldn't open /var/lib/postgres/data/pg_shadow:
>> Permission denied.
>> 
>> Do I need to chmod something here?
> 
> If you answered yes to all the questions then your sol user should be a
> postgres superuser, so you shouldn't be seeing that error.  Are you
> logged in as sol as well?  You need to have a user account on the system
> that is the same as your postgres account.  Also, you can't use psql as
> root (but that is not your problem here).  Try being postgres user and
> see if that makes the errors go away.  If it does, try deleting
> (destroyuser sol) and recreating yourself again.
>