Bkascript l3th2nh

How to setup a Postgres replication with docker and docker-compose

How to use

To run you will need docker and docker-compose installed, and run the command docker-compose up on a folder within this file named docker-compose.yml(attached in this Gist)

How the PGAudit is enable, you will see the queries log and in which database is running which query, this is the main purpose of this Gist, along with have a database with replication working out of the box

To add user with just reading rights to access the database on slave replica

Directories on host machine:

/data/certbot/letsencrypt
/data/certbot/www
Nginx server in docker container

docker run -d --name nginx \

NOTE: make sure you export containers and images in separate directories or it's very likely there will be issues when importing or loading your backups using the following snippets

Export all containers

$ while read image container_id; do 
    docker export $container_id > ${image////_}-${container_id}.tar 
 done &lt; &lt;(docker ps -a -f status=exited | tail -n +2 | awk '{ print $2 " " $1 }')

Render custom blocks

$bid = 'myblock';
$block = \Drupal\block_content\Entity\BlockContent::load($bid);
$render = \Drupal::entityTypeManager()->getViewBuilder('block_content')->view($block);

Render plugin blocks

$block_manager = \Drupal::service('plugin.manager.block');

Point Domain to Amazon Web Services (AWS) EC2 Instance

Open the Amazon Route 53 console at https://console.aws.amazon.com/route53/.
If you are new to Amazon Route 53, you see a welcome page; choose Get Started Now for DNS Management. Otherwise, choose Hosted Zones in the navigation pane.
Choose Create Hosted Zone.
For Domain Name, type your domain name.
Choose Create.
Click the Hosted Zone, edit record set.
In the value, add ec2-54-152-134-146.compute-1.amazonaws.com.
Change your DNS file to point to the IPv4 address (This would be in something like GoDaddy).

	#!/bin/bash

	_images_directory="images.d"
	_containers_directory="containers.d"
	_DIRS=( "$_images_directory" "$_containers_directory" )
	for dir in "${_DIRS[@]}"; do
	if [ ! -d "$dir" ]; then
	mkdir "$dir"
	fi
	done

	function Count(What, Where: String): Integer;
	begin
	Result := 0;
	if Length(What) = 0 then
	exit;
	while Pos(What,Where)>0 do
	begin
	Where := Copy(Where,Pos(What,Where)+Length(What),Length(Where));
	Result := Result + 1;
	end;

	:: Read file "package.json" into variable string, removing line breaks.
	set string=
	for /f "delims=" %%x in (package.json) do set "string=!string!%%x"

	rem Remove quotes
	set string=%string:"=%
	rem Remove braces
	set "string=%string:~2,-2%"
	rem Change colon+space by equal-sign
	set "string=%string:: ==%"

	# Taxonomy terms:
	- https://gist.github.com/facine/35bb291811c146b6fc9e#file-create_taxonomy_term-php

	# Menu links:
	- https://gist.github.com/facine/35bb291811c146b6fc9e#file-create_menu_link-php

	# File items:
	- https://gist.github.com/facine/35bb291811c146b6fc9e#file-create_file-php

	# Nodes:

	I use the first


	—– BEGIN LICENSE —–
	Michael Barnes
	Single User License
	EA7E-821385
	8A353C41 872A0D5C DF9B2950 AFF6F667
	C458EA6D 8EA3C286 98D1D650 131A97AB
	AA919AEC EF20E143 B361B1E7 4C8B7F04