Skip to content

Instantly share code, notes, and snippets.

@dro248

dro248/postgres.sh

Forked from mrw34/postgres.sh
Created April 13, 2021 12:08
Show Gist options
  • Save dro248/46c4b9a8223b12af7e5135890e9dc60a to your computer and use it in GitHub Desktop.
Save dro248/46c4b9a8223b12af7e5135890e9dc60a to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @mrw34 mrw34 revised this gist May 9, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -7,7 +7,7 @@ openssl rsa -in privkey.pem -passin pass:abcd -out server.key
    openssl req -x509 -in server.req -text -key server.key -out server.crt
    chmod 600 server.key
    test $(uname -s) == Linux && chown 70 server.key
    docker run -d --name postgres -v "$(pwd)/server.crt:/var/lib/postgresql/server.crt:ro" -v "$(pwd)/server.key:/var/lib/postgresql/server.key:ro" postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key
    docker run -d --name postgres -e POSTGRES_HOST_AUTH_METHOD=trust -v "$(pwd)/server.crt:/var/lib/postgresql/server.crt:ro" -v "$(pwd)/server.key:/var/lib/postgresql/server.key:ro" postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key

    sleep 1

  2. @mrw34 mrw34 revised this gist Jan 26, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -6,7 +6,7 @@ openssl req -new -text -passout pass:abcd -subj /CN=localhost -out server.req -k
    openssl rsa -in privkey.pem -passin pass:abcd -out server.key
    openssl req -x509 -in server.req -text -key server.key -out server.crt
    chmod 600 server.key
    test $(uname -s) == Linux && echo chown 70 server.key
    test $(uname -s) == Linux && chown 70 server.key
    docker run -d --name postgres -v "$(pwd)/server.crt:/var/lib/postgresql/server.crt:ro" -v "$(pwd)/server.key:/var/lib/postgresql/server.key:ro" postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key

    sleep 1
  3. @mrw34 mrw34 revised this gist Nov 7, 2019. 1 changed file with 0 additions and 1 deletion.
    1 change: 0 additions & 1 deletion postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -12,4 +12,3 @@ docker run -d --name postgres -v "$(pwd)/server.crt:/var/lib/postgresql/server.c
    sleep 1

    docker run --rm -it --link postgres postgres:12-alpine psql -h postgres -U postgres
    # Ensure that you see "SSL connection"
  4. @mrw34 mrw34 revised this gist Nov 7, 2019. 1 changed file with 2 additions and 3 deletions.
    5 changes: 2 additions & 3 deletions postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -6,9 +6,8 @@ openssl req -new -text -passout pass:abcd -subj /CN=localhost -out server.req -k
    openssl rsa -in privkey.pem -passin pass:abcd -out server.key
    openssl req -x509 -in server.req -text -key server.key -out server.crt
    chmod 600 server.key
    # If you're on Linux:
    chown 70 server.key
    docker run -d --name postgres -v $(pwd)/server.crt:/var/lib/postgresql/server.crt:ro -v $(pwd)/server.key:/var/lib/postgresql/server.key:ro postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key
    test $(uname -s) == Linux && echo chown 70 server.key
    docker run -d --name postgres -v "$(pwd)/server.crt:/var/lib/postgresql/server.crt:ro" -v "$(pwd)/server.key:/var/lib/postgresql/server.key:ro" postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key

    sleep 1

  5. @mrw34 mrw34 revised this gist Nov 7, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -8,7 +8,7 @@ openssl req -x509 -in server.req -text -key server.key -out server.crt
    chmod 600 server.key
    # If you're on Linux:
    chown 70 server.key
    docker run -d --name postgres -v $PWD/server.crt:/var/lib/postgresql/server.crt:ro -v $PWD/server.key:/var/lib/postgresql/server.key:ro postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key
    docker run -d --name postgres -v $(pwd)/server.crt:/var/lib/postgresql/server.crt:ro -v $(pwd)/server.key:/var/lib/postgresql/server.key:ro postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key

    sleep 1

  6. @mrw34 mrw34 revised this gist Oct 30, 2019. 1 changed file with 5 additions and 3 deletions.
    8 changes: 5 additions & 3 deletions postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -2,13 +2,15 @@

    set -euo pipefail

    openssl req -new -text -passout pass:abcd -subj /CN=localhost -out server.req
    openssl req -new -text -passout pass:abcd -subj /CN=localhost -out server.req -keyout privkey.pem
    openssl rsa -in privkey.pem -passin pass:abcd -out server.key
    openssl req -x509 -in server.req -text -key server.key -out server.crt
    chmod 600 server.key
    # If you're on Linux:
    chown 70 server.key
    docker run -d --name postgres -v $PWD/server.crt:/var/lib/postgresql/server.crt:ro -v $PWD/server.key:/var/lib/postgresql/server.key:ro postgres:11-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key
    docker run -d --name postgres -v $PWD/server.crt:/var/lib/postgresql/server.crt:ro -v $PWD/server.key:/var/lib/postgresql/server.key:ro postgres:12-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key

    sleep 1

    docker run --rm -it --link postgres postgres:11-alpine psql -h postgres -U postgres
    docker run --rm -it --link postgres postgres:12-alpine psql -h postgres -U postgres
    # Ensure that you see "SSL connection"
  7. @mrw34 mrw34 revised this gist May 5, 2019. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -6,6 +6,7 @@ openssl req -new -text -passout pass:abcd -subj /CN=localhost -out server.req
    openssl rsa -in privkey.pem -passin pass:abcd -out server.key
    openssl req -x509 -in server.req -text -key server.key -out server.crt
    chmod 600 server.key
    chown 70 server.key
    docker run -d --name postgres -v $PWD/server.crt:/var/lib/postgresql/server.crt:ro -v $PWD/server.key:/var/lib/postgresql/server.key:ro postgres:11-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key

    sleep 1
  8. @mrw34 mrw34 revised this gist Feb 11, 2019. 1 changed file with 6 additions and 4 deletions.
    10 changes: 6 additions & 4 deletions postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -1,11 +1,13 @@
    #!/bin/bash

    set -eu -o pipefail
    set -euo pipefail

    openssl req -new -text -passout pass:abcd -subj /CN=localhost -out server.req
    openssl rsa -in privkey.pem -passin pass:abcd -out server.key
    openssl req -x509 -in server.req -text -key server.key -out server.crt
    chmod og-rwx server.key
    docker run -d --name postgres -v postgres:/var/lib/postgresql/data -v $PWD/server.crt:/var/lib/postgresql/data/server.crt -v $PWD/server.key:/var/lib/postgresql/data/server.key postgres:9-alpine -c ssl=on
    chmod 600 server.key
    docker run -d --name postgres -v $PWD/server.crt:/var/lib/postgresql/server.crt:ro -v $PWD/server.key:/var/lib/postgresql/server.key:ro postgres:11-alpine -c ssl=on -c ssl_cert_file=/var/lib/postgresql/server.crt -c ssl_key_file=/var/lib/postgresql/server.key

    docker run --rm -it --link postgres postgres:9-alpine psql -h postgres -U postgres
    sleep 1

    docker run --rm -it --link postgres postgres:11-alpine psql -h postgres -U postgres
  9. @mrw34 mrw34 revised this gist Aug 16, 2017. No changes.
  10. @mrw34 mrw34 created this gist Aug 16, 2017.
    11 changes: 11 additions & 0 deletions postgres.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    #!/bin/bash

    set -eu -o pipefail

    openssl req -new -text -passout pass:abcd -subj /CN=localhost -out server.req
    openssl rsa -in privkey.pem -passin pass:abcd -out server.key
    openssl req -x509 -in server.req -text -key server.key -out server.crt
    chmod og-rwx server.key
    docker run -d --name postgres -v postgres:/var/lib/postgresql/data -v $PWD/server.crt:/var/lib/postgresql/data/server.crt -v $PWD/server.key:/var/lib/postgresql/data/server.key postgres:9-alpine -c ssl=on

    docker run --rm -it --link postgres postgres:9-alpine psql -h postgres -U postgres