(wherever it says url.com, use your server's domain or IP)
Login to new server as root, then add a deploy user
sudo useradd --create-home -s /bin/bash deploy
sudo adduser deploy sudo
sudo passwd deploy
And Update the new password
worker_processes 1; | |
error_log logs/rtmp_error.log debug; | |
pid logs/nginx.pid; | |
events { | |
worker_connections 1024; | |
} | |
http { |
-- 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 | |
FROM pg_stat_activity | |
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
(wherever it says url.com, use your server's domain or IP)
Login to new server as root, then add a deploy user
sudo useradd --create-home -s /bin/bash deploy
sudo adduser deploy sudo
sudo passwd deploy
And Update the new password
#ifdef ENABLE_DEBUG | |
#define DebugLog(format, args...) \ | |
NSLog(@"%s, line %d: " format "\n", \ | |
__func__, __LINE__, ## args); | |
#else | |
#define DebugLog(format, args...) do {} while(0) | |
#endif | |
// sample use | |
DebugLog("number: %d ; class %p", count, className); |