Topics

select

Setup postgreSQL RDS using Ansible

Setting up PostgreSQL on RDS using ansible is a bit tricky because the main user on RDS is not a SUPERUSER and roles membership is not automatically granted for ex: “ERROR: must be member of role ..” is quite common. Here is a working solution:

Install Sphinx 2.0.4 on CentOS 6.2

– Make sure to check CentOS, PHP-FPM, Nginx, memcached and MYSQL posts.

– Get fresh RPM from sphinxsearch.com

– Install Sphinx

rpm -Uhv http://sphinxsearch.com/files/sphinx-2.0.4-1.rhel6.x86_64.rpm

– Create sample MySQL database

use name attribute for input instead of id for use with label

you need Jquery:

<label for="myinput"></label><input name="myinput" type="text" value="text here" />
$('label').live('click', function(e){
        if( $(e.target).is(':input') ) return;
        var i = $(':input[name="' + $(this).attr('for') + '"]')
        i.is(':checkbox') ? i.attr('checked', !i.attr('checked') ) : i.focus().select();
    })

Get average server load

This function should work on Unix as on windows