dtvuong
dankrause
/ postgresql_recursive.sql
Last active
February 26, 2024 16:03
An example of creating a recursive postgresql query to generate data about parent-child relationships within a single table.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE test | |
| ( | |
| id INTEGER, | |
| parent INTEGER | |
| ); | |
| INSERT INTO test (id, parent) VALUES | |
| (1, NULL), | |
| (2, 1), |
bugcy013
/ rundeck-email notification setup
Created
August 14, 2016 02:38
rundeck-email notification setup
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /etc/rundeck/profile change | |
| -Drundeck.config.location=/etc/rundeck/rundeck-config.properties \ | |
| to | |
| -Drundeck.config.location=/etc/rundeck/rundeck-config.groovy \ | |
| and my /etc/rundeck/rundeck-config.groovy | |
| looks like: | |
| grails.serverURL="https://172.20.22.76:4443" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [Unit] | |
| Description=Jenkins | |
| After=network.target | |
| Requires=network.target | |
| [Service] | |
| Type=simple | |
| EnvironmentFile=/etc/sysconfig/jenkins | |
| ExecStart=/usr/bin/java ${JENKINS_JAVA_OPTIONS} -jar /usr/lib/jenkins/jenkins.war --httpPort=${JENKINS_PORT} --httpListenAddress=${JENKINS_LISTEN_ADDRESS} ${JENKINS_ARGS} | |
| Restart=always |