[ADMIN] drive failure

2011-03-31 Thread Tony Capobianco
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

Re: [ADMIN] drive failure

2011-03-31 Thread Tony Capobianco
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

[ADMIN] grant select pg 9.0.3

2012-05-02 Thread Tony Capobianco
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