...connection summary: SELECT COUNT(*) AS cnt, usename FROM pg_stat_activity GROUP BY usename ORDER BY cnt DESC; Open transactions with their minimum needed transaction ID SELECT pid, datname, usename...
...state, backend_xmin FROM pg_stat_activity WHERE backend_xmin IS NOT NULL ORDER BY age(backend_xmin) DESC; Transactions To get the current transaction ID: SELECT * FROM txid_current...
...throw an error when this is omitted: AND c.relkind = 'i' AND i.indisready AND i.indisvalid ORDER BY c.relpages DESC; This requires superuser permissions to install the amcheck extension to the server...
WHERE am.amname = 'btree' AND c.relpersistence != 't' AND c.relkind = 'i' AND i.indisready AND i.indisvalid ORDER BY c.relpages DESC; " databases=$(psql -tAc "SELECT datname FROM pg_database WHERE datistemplate = false;")
...puppetdb_query( "resources [ parameters, title ]{ exported=true and type = 'Nagios_service' and parameters.ensure != 'absent' order by certname, title }" ) Then we join the queried services with our template file { '/etc/naemon/conf.d/services.cfg':
...You can ignore the field. The second number fs_passno This field determines the order of partition to fsck. Every partition that have seen more than Maximum mount count will...
...that the mysqladmin-command is used to check if the server is running in order to rotate the log: # vim /etc/logrotate.d/mysql-server /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/mariadb-slow.log /var/log/mysql/error.log { daily rotate 7 missingok create...
127.0.0.1:6379[1]> KEYS * [possibly long output or "empty list or set"] In order to delete the keys you need to select the DB first and then remove all...
...with two bundlers being loaded (an old one and a new one, in that order, doesn't work well). https://github.com/phusion/passenger/issues/2409#issuecomment-1029361123
...the certificate. It's also possible that the certificate chain is in the wrong order. Make sure that the server certificate is the first. This is also necessary for nginx...
You will need to look here and find your own device. Look for the "bootable CD" download, which will give...
Best results in other decks
config.before(:suite) { puts 'BEFORE :suite' } config.after(:suite) { puts 'AFTER :suite' } end describe 'order of hook execution' do around(:all) do |each| puts 'AROUND BEFORE :all' each.run puts 'AROUND...
When you call a method on an object, Ruby looks for the implementation of that method. It looks in the...