Re: [ADMIN] How to track down locks held by recovery process on a slave?

2013-10-05 Thread reiner peterke
First thought is make sure you are looking in the right database. pg_locks shows data over the entire server, not just the connected database. pg_class exists for each database so if you are connected to 'my_database' but the object is in 'your_database', it won't show up in pg_class on 'my_data

Re: [ADMIN] uuid extension not available

2013-10-10 Thread reiner peterke
it sounds like you are missing the contrib code. if you built from source you need to go to the contrib directory and run make, make install. if you installed from a package you need to install the appropriate contrib package. reiner sent by smoke signals at great danger to my self. On 1