This is link of another guide -> http://debabhishek.com/writes/Installing-and-Running-TextSecure-Signal-Server-on-Windows/
Author: Aqnouch Mohammed aqnouch.mohammed@gmail.com
This paper is a quickstart for anyone aims to setup a working Signal Server.
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), 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(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |