Permission denied errors

From: zeki(at)mokhtarzada(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: Permission denied errors
Date: 2005-08-22 15:19:05
Message-ID: Pine.LNX.4.44.0508221111530.27868-100000@members.freewebs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Hello all, I woke up this morning and found my installation of Postgres
(7.3.2) spewing the following error message:

ERROR: cannot count blocks for ev_log -- open failed: Permission denied
ERROR: cannot count blocks for ev_log -- open failed: Permission denied
ERROR: cannot count blocks for ev_log -- open failed: Permission denied
ERROR: cannot count blocks for ev_log -- open failed: Permission denied

Now it seems as though the database is somehow diseased. I can select and
insert data in all of the other tables in the database but I can not
create tables:

# create table test_tab (idfield int);
ERROR: cannot create test_tab: Permission denied

I also can not dump data out of ev_log:

pg_dump: ERROR: cannot count blocks for ev_log -- open failed: Permission
denied
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "ev_log" failed:
PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY
public.ev_log (logid, eventtype, username, ipaddress, eventdata, ts) TO
stdout;

Any ideas?

I'm willing to dump and reload, but I'd like to get the data out of the
log table if possible.

-Zeki

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-08-22 15:26:36 Re: BUG #1839: insert into table (column) values (nullif('',''));
Previous Message Michael Fuhr 2005-08-22 15:07:27 Re: BUG #1839: insert into table (column) values (nullif('',''));