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
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('','')); |