[ADMIN] information_schema.tables view does not exist

2011-12-19 Thread Lukasz Brodziak
Hello, I got a database from client to be migrated from 8.2.4 to 9.0 and I got an error ERROR: could not open relation 1663/206914/10780: No such file or directory. When I checked pg_class for the oid it occured to be information_schema.tables view. Is there anyway of restoring the view? pgAdmin

Re: [ADMIN] Index error on recovery

2011-12-19 Thread K P Manoj
No, all my index B-Tree Index Thanks Manoj K P 2011/12/18 杨晓青 > is your index a hash index? xlog does not include the changes on hash > index,your must rebuild hash index after recovery from xlog. > > > 2011/12/16 K P Manoj > >> Hi >> >> The details given below is for a test server, that I br

Re: [ADMIN] information_schema.tables view does not exist

2011-12-19 Thread Tom Lane
Lukasz Brodziak writes: > I got a database from client to be migrated from 8.2.4 to 9.0 and I got an > error ERROR: could not open relation 1663/206914/10780: No such file or > directory. > When I checked pg_class for the oid it occured to be > information_schema.tables view. Is there anyway of r

[ADMIN] Giving postgres roles 'sudo'-like access

2011-12-19 Thread Mario Splivalo
I need to have postgres role to be able to cancel queries run by that same role. I know that I can kill the client connection that started the query, but I also need to have that role connect to postgres and kill some of it's running queries. It's on postgres 9.1.1, running on Debian Squeeze. On

Re: [ADMIN] Giving postgres roles 'sudo'-like access

2011-12-19 Thread Craig James
On 12/19/11 10:04 AM, Mario Splivalo wrote: I need to have postgres role to be able to cancel queries run by that same role. I know that I can kill the client connection that started the query, but I also need to have that role connect to postgres and kill some of it's running queries. It's on

Re: [ADMIN] information_schema.tables view does not exist

2011-12-19 Thread Lukasz Brodziak
We have a function which checks if certain tables exist in tables view it simply runs select over the view and if it returns no rows function creates table. In this case it ends up with the error in subject. Fortunately I managed to repair the db. PgAdmin did not show the create script for the view

[ADMIN] PG export/import encoding issue

2011-12-19 Thread Scott Toland
Hi guys I have a 8.4 install that I am moving to a new DB server running 9.0. This is all well and god for the most part, except when it comes to restoring the data in several of the tables. See the problem is the old schema was an ASCII neutral zone, and the new server has the schema set for U