Hi! I'm using Sequel to read the pgbouncer admin / stats database. pgbouncer acts like a PostgreSQL server, albeit it does not itself have relations. It does return information when one runs "SHOW clients" or "SHOW pools" for example. From psql, I can get the actual data I want, but Sequel's introspection capabilities get in the way:
2013-02-15 14:15:34.810639500 /usr/lib/ruby/vendor_ruby/sequel/adapters/postgres.rb:196:in `async_exec': PGError: ERROR: invalid command 'SELECT oid, typname FROM pg_type where typtype = 'b'', use SHOW HELP; (Sequel::DatabaseConnectionError) 2013-02-15 14:15:34.810876500 from /usr/lib/ruby/vendor_ruby/sequel/adapters/postgres.rb:196:in `block (2 levels) in execute' 2013-02-15 14:15:34.811113500 from /usr/lib/ruby/vendor_ruby/sequel/database/logging.rb:28:in `log_yield' 2013-02-15 14:15:34.815156500 from /usr/lib/ruby/vendor_ruby/sequel/adapters/postgres.rb:196:in `block in execute' 2013-02-15 14:15:34.815424500 from /usr/lib/ruby/vendor_ruby/sequel/adapters/postgres.rb:176:in `check_disconnect_errors' Is there a way to skip the introspection? Looking at http://sequel.rubyforge.org/plugins.html, I see nothing which sounds like what I need to do. Thanks! François Sample psql output: pgbouncer=> SHOW pools; database | user | cl_active | cl_waiting | sv_active | sv_idle | sv_used | sv_tested | sv_login | maxwait ------------------------------------+-----------------+-----------+------------+-----------+---------+---------+-----------+----------+--------- pgbouncer | pgbouncer | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 svanalytics_production_batch | svanbatch | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 svanalytics_production_interactive | svaninteractive | 14 | 27 | 10 | 0 | 0 | 0 | 0 | 0 (3 rows) -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
