AidHamza

-- Good reference : http://big-elephants.com/2013-09/exploring-query-locks-in-postgres/

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 

AidHamza

[example.org]
listen = /srv/vhtdocs/example.org/log/.php-fpm.sock
listen.owner = example_org
listen.group = www-data
listen.mode = 0660

user = example_org
group = example_org

pm = dynamic

AidHamza

UPDATE wp_options SET option_value = replace(option_value, 'http://servier.appsdoc.com', 'http://www.jambeslegeres.ma') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://servier.appsdoc.com','http://www.jambeslegeres.ma');

UPDATE wp_posts SET post_content = replace(post_content, 'http://servier.appsdoc.com', 'http://www.jambeslegeres.ma');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://servier.appsdoc.com','http://www.jambeslegeres.ma');

AidHamza

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

AidHamza

All credit: http://stackoverflow.com/questions/4006324/how-to-atomically-delete-keys-matching-a-pattern-with-redis

redis-cli [options] KEYS "prefix:*" | xargs redis-cli [options] DEL

AidHamza