[ADMIN] grant select pg 9.0.3
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 statement again. How can I avoid having to issue the grant each time I create a new table? Thanks. Tony -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] drive failure
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 change to this directory, the file in question does not exist. Am I to assume that I'm completely hosed? If the spare kicked in, what happened to the file listed above? Any hints would be most appreciated. Thanks. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] drive failure
We were able to determine through a few of our queries that an index was corrupt. We did this through the process of elimination however. As a result, I have two questions: How can I determine that we have a corrupt index? How can I determine which datafile (5875980.x) is related to which 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/5875980.7 (target block 2968776487): No such file or directory When I change to this directory, the file in question does not exist. Am I to assume that I'm completely hosed? If the spare kicked in, what happened to the file listed above? Any hints would be most appreciated. Thanks. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
