Re: cannot connect to postgres db, strange error!

Lists: pgsql-admin
From: Nizar Ghazali <nghazali(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: cannot connect to postgres db, strange error!
Date: 2004-05-18 15:42:53
Message-ID: 20040518154253.89886.qmail@web13803.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hi,

Im running postgres 7.4.3 on HP-UX 11.11. When I want
to connect to my db, I have the following error:

psql: FATAL: _mdfd_getrelnfd: cannot open relation
pg_class: Permission denied

Do you have any idea where i have to look. I already
looked at pg_hba.conf file and it looks ok.

Regards



__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nizar Ghazali <nghazali(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: cannot connect to postgres db, strange error!
Date: 2004-05-20 17:46:14
Message-ID: 2950.1085075174@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Nizar Ghazali <nghazali(at)yahoo(dot)com> writes:
> Im running postgres 7.4.3 on HP-UX 11.11. When I want
> to connect to my db, I have the following error:

> psql: FATAL: _mdfd_getrelnfd: cannot open relation
> pg_class: Permission denied

Sounds to me like you started the postmaster as the wrong user
(not the one who did initdb).

regards, tom lane