github.com/insionng/yougam@v0.0.0-20170714101924-2bc18d833463/libraries/lib/pq/.travis.yml (about)

     1  language: go
     2  
     3  go:
     4    - 1.4
     5    - 1.5
     6    - 1.6
     7    - tip
     8  
     9  before_install:
    10    - psql --version
    11    - sudo /etc/init.d/postgresql stop
    12    - sudo apt-get -y --purge remove postgresql libpq-dev libpq5 postgresql-client-common postgresql-common
    13    - sudo rm -rf /var/lib/postgresql
    14    - wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
    15    - sudo sh -c "echo deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main $PGVERSION >> /etc/apt/sources.list.d/postgresql.list"
    16    - sudo apt-get update -qq
    17    - sudo apt-get -y -o Dpkg::Options::=--force-confdef -o Dpkg::Options::="--force-confnew" install postgresql-$PGVERSION postgresql-server-dev-$PGVERSION postgresql-contrib-$PGVERSION
    18    - sudo chmod 777 /etc/postgresql/$PGVERSION/main/pg_hba.conf
    19    - echo "local     all         postgres                          trust" > /etc/postgresql/$PGVERSION/main/pg_hba.conf
    20    - echo "local     all         all                               trust" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    21    - echo "hostnossl all         pqgossltest 127.0.0.1/32          reject" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    22    - echo "hostnossl all         pqgosslcert 127.0.0.1/32          reject" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    23    - echo "hostssl   all         pqgossltest 127.0.0.1/32          trust"  >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    24    - echo "hostssl   all         pqgosslcert 127.0.0.1/32          cert"  >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    25    - echo "host      all         all         127.0.0.1/32          trust" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    26    - echo "hostnossl all         pqgossltest ::1/128               reject" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    27    - echo "hostnossl all         pqgosslcert ::1/128               reject" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    28    - echo "hostssl   all         pqgossltest ::1/128               trust" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    29    - echo "hostssl   all         pqgosslcert ::1/128               cert" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    30    - echo "host      all         all         ::1/128               trust" >> /etc/postgresql/$PGVERSION/main/pg_hba.conf
    31    - sudo install -o postgres -g postgres -m 600 -t /var/lib/postgresql/$PGVERSION/main/ certs/server.key certs/server.crt certs/root.crt
    32    - sudo bash -c "[[ '${PGVERSION}' < '9.2' ]] || (echo \"ssl_cert_file = 'server.crt'\" >> /etc/postgresql/$PGVERSION/main/postgresql.conf)"
    33    - sudo bash -c "[[ '${PGVERSION}' < '9.2' ]] || (echo \"ssl_key_file = 'server.key'\" >> /etc/postgresql/$PGVERSION/main/postgresql.conf)"
    34    - sudo bash -c "[[ '${PGVERSION}' < '9.2' ]] || (echo \"ssl_ca_file = 'root.crt'\" >> /etc/postgresql/$PGVERSION/main/postgresql.conf)"
    35    - sudo sh -c "echo 127.0.0.1 postgres >> /etc/hosts"
    36    - sudo ls -l /var/lib/postgresql/$PGVERSION/main/
    37    - sudo cat /etc/postgresql/$PGVERSION/main/postgresql.conf
    38    - sudo chmod 600 $PQSSLCERTTEST_PATH/postgresql.key
    39    - sudo /etc/init.d/postgresql restart
    40  
    41  env:
    42    global:
    43      - PGUSER=postgres
    44      - PQGOSSLTESTS=1
    45      - PQSSLCERTTEST_PATH=$PWD/certs
    46      - PGHOST=127.0.0.1
    47    matrix:
    48      - PGVERSION=9.5 PQTEST_BINARY_PARAMETERS=yes
    49      - PGVERSION=9.4 PQTEST_BINARY_PARAMETERS=yes
    50      - PGVERSION=9.3 PQTEST_BINARY_PARAMETERS=yes
    51      - PGVERSION=9.2 PQTEST_BINARY_PARAMETERS=yes
    52      - PGVERSION=9.1 PQTEST_BINARY_PARAMETERS=yes
    53      - PGVERSION=9.0 PQTEST_BINARY_PARAMETERS=yes
    54      - PGVERSION=9.5 PQTEST_BINARY_PARAMETERS=no
    55      - PGVERSION=9.4 PQTEST_BINARY_PARAMETERS=no
    56      - PGVERSION=9.3 PQTEST_BINARY_PARAMETERS=no
    57      - PGVERSION=9.2 PQTEST_BINARY_PARAMETERS=no
    58      - PGVERSION=9.1 PQTEST_BINARY_PARAMETERS=no
    59      - PGVERSION=9.0 PQTEST_BINARY_PARAMETERS=no
    60  
    61  script:
    62   - go test -v ./...
    63  
    64  before_script:
    65   - psql -c 'create database pqgotest' -U postgres
    66   - psql -c 'create user pqgossltest' -U postgres
    67   - psql -c 'create user pqgosslcert' -U postgres