pg_dump fails sanity check
От | Braeus Sabaco |
---|---|
Тема | pg_dump fails sanity check |
Дата | |
Msg-id | 3A71C973.72CBB54@romanlegion.com обсуждение исходный текст |
Список | pgsql-general |
Using version 7.0.2 (system is production, so I can't take it down for minor releases) I enter: $ pg_dump romanlegion > rdb.backup and I get: failed sanity check, table usergames was not found Ok, fair enough, so: $ psql romanlegion romanlegion=# \d usergames Table "usergames" Attribute | Type | Modifier ------------+---------+---------- gameuserid | integer | not null gameplayed | integer | not null Index: unique_played romanlegion=# select * from usergames ; gameuserid | gameplayed ------------+------------ 10 | 1 <snip> 442 | 10 (477 rows) romanlegion=# Now, it can find the table, describe the table, select from the table, and the more complex queries I do on the site work just fine also. I can make sure it is where I expect it to be. $ su postgres Password: $ ls /var/lib/pgsql/data/base/romanlegion/usergames -al -rw------- 1 postgres postgres 40960 Jan 25 23:43 /var/lib/pgsql/data/base/romanlegion/usergames So now I'm out of ideas. Is there some known bug? Or is this just being weird?
В списке pgsql-general по дате отправления: