postgresql-go

README

How to run docker image with PostreSQL

docker run --name go-postgres -e POSTGRES_PASSWORD=TestSecret -e POSTGRES_DB=peopledatabase -p 5432:5432 -d postgres:12-alpine

Database migration

CREATE TABLE peopleinfo ( birthday text, names text, occupation text );

docker run -v code/migrations:/migrations --network host migrate/migrate -path=/migrations/ -database postgres://postgres:TestSecret@172.17.0.2:5432/peopledatabase?sslmode=disable up 1

postgres://username:password@localhost/dbname

PgAdmin

docker run -p 555:80 \
    -e "PGADMIN_DEFAULT_EMAIL=user@domain.com" \
    -e "PGADMIN_DEFAULT_PASSWORD=SuperSecret" \
    -d dpage/pgadmin4

Env variables

export DBPORT=5432 export DBHOST=localhost export DBUSER=postgres export DBPASS=TestSecret export DBNAME=peopledatabase

curl check

curl -X GET -I http://localhost:8080/server -o /dev/null -w '%{http_code}\n' -s

Github release

export GITHUB_TOKEN="" ghr v1.0.0 code/release/