Hello,
He had a drive fail in an array and the spare kicked in to replace the
failed drive. However, when I query a specific table, I get the below
error:
ERROR: could not open file
pg_tblspc/16412/PG_9.0_201008051/16419/5875980.7 (target block
2968776487): No such file or directory
When I
tablespace?
On Thu, 2011-03-31 at 08:38 -0400, Tony Capobianco wrote:
Hello,
He had a drive fail in an array and the spare kicked in to replace the
failed drive. However, when I query a specific table, I get the below
error:
ERROR: could not open file
pg_tblspc/16412/PG_9.0_201008051/16419
I've issued the following statement:
grant select on all tables in schema support to backup;
When I perform a pgdump of the support schema with the backup user it
works fine. If I create a new table within the support schema, pgdump
fails on the support schema. To rectify, I issue the grant