Eugene K zen-k

Building pgModeler in MacOS with Homebrew

The official installation instructions for pgModeler recommends installing Xcode and the Enterprise DB distribution of Postgres to fulfill its build requirements. Luckily, Homebrew's got us covered!

Checkout the source

git clone https://github.com/pgmodeler/pgmodeler.git

In order to run this image do: docker-compose up -d to get all up. On first run DB initialization and initial user setup is done like so:

First start a bash in the container: docker-compose exec sentry /bin/bash. Then, inside bash, do sentry upgrade wait until it asks you for an inital user. When finished exit the bash.

When in doubt check with docker-compose ps if all went fine.

Tools

Located in alphabetical order (not prefer)

ab – slow and single threaded, written in C
apib – most of the features of ApacheBench (ab), also designed as a more modern replacement, written in C
baloo – Expressive end-to-end HTTP API testing made easy, written in Go (golang)
bombardier – Fast crossplatform HTTP benchmarking tool, written in Go (golang)
curl-loader – performance loading of various application services and traffic generation, written in C
gatling – High performance load testing framework based on Scala, Akka and Netty, write in Scala

PostgreSQL Streaming Replication With Docker

The *.txt files here hold user and database parameters. Specifically, replication.txt contains the user/role and password to use for replication. Whereas database.txt contains an initial database, user/role and password to create on the master.

Run the master:

$ fig run -d master

Wait for it to start up completely. Start the slave:

	DUMP
	// pod-name name of the postgres pod
	// postgres-user database user that is able to access the database
	// database-name name of the database
	kubectl exec [pod-name] -- bash -c "pg_dump -U [postgres-user] [database-name]" > database.sql

	RESTORE
	// pod-name name of the postgres pod
	// postgres-user database user that is able to access the database
	// database-name name of the database

	global
	log 127.0.0.1 local0 debug
	chroot /var/lib/haproxy
	user haproxy
	group haproxy
	daemon
	tune.ssl.default-dh-param 2048

	defaults
	log global

	frontend https
	bind :80
	bind 0.0.0.0:443 ssl crt /etc/haproxy/mydomain.com.pem
	reqadd X-Forwarded-Proto:\ https

	redirect scheme https if !{ ssl_fc }

	acl docker_registry_domain hdr(host) -i docker-register.mydomain.com
	# This is a hack for docker not always sending basic auth data
	acl docker_token hdr(Authorization:) -i Token