Miesvanderlippe

#cloud-config
runcmd:
 - [eval, 'echo $(cat /proc/cmdline) "autoinstall" > /root/cmdline']
 - [eval, 'mount -n --bind -o ro /root/cmdline /proc/cmdline']
 - [eval, 'snap restart subiquity.subiquity-service']

autoinstall:
    version: 1
    identity:
        hostname: hack-nation

adam-p

It's not immediately obvious how to pull down the code for a PR and test it locally. But it's pretty easy. (This assumes you have a remote for the main repo named upstream.)

Getting the PR code

1. Make note of the PR number. For example, Rod's latest is PR #37: Psiphon-Labs/psiphon-tunnel-core#37

2. Fetch the PR's pseudo-branch (or bookmark or rev pointer whatever the word is), and give it a local branch name. Here we'll name it pr37:

$ git fetch upstream pull/37/head:pr37

jmc734

--- php.original.xml	2014-12-06 16:28:15.000000000 -0500
+++ php.xml	2014-12-06 16:27:42.000000000 -0500
@@ -10331,6 +10331,7 @@
 				<Param name="[int options=PGSQL_DML_EXEC]"/>
 			</Overload>
 		</KeyWord>
+		<KeyWord name="php" func="no"/>
 		<KeyWord name="pg_version" func="yes">
 			<Overload retVal="array">
 				<Param name="[resource connection]"/>

rxaviers

People

:bowtie:	😄 :smile:	😆 :laughing:
😊 :blush:	😃 :smiley:	☺️ :relaxed:
😏 :smirk:	😍 :heart_eyes:	😘 :kissing_heart:
😚 :kissing_closed_eyes:	😳 :flushed:	😌 :relieved:
😆 :satisfied:	😁 :grin:	😉 :wink:
😜 :stuck_out_tongue_winking_eye:	😝 :stuck_out_tongue_closed_eyes:	😀 :grinning:
😗 :kissing:	😙 :kissing_smiling_eyes:	😛 :stuck_out_tongue:

rgreenjr

-- 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%'