| 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: | Whole Thread | Raw Message | 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
| 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('','')); |