Configuration items specific to Spilo are listed here.

Docker image

The Docker image containing Patroni and AWS-specific code which constitutes Spilo.

Example: registry.opensource.zalan.do/acid/spilo-9.4:0.76-p1

Postgres WAL S3 bucket

The location to store the pg_basebackup and the archived WAL-files of the PostgreSQL cluster.

Example: example-team-eu-west-1-spilo-app

EC2 instance type

Which EC2 instance type you want to use. Amazon provides many types of instances for different use cases.

Example: m3.large

Amazon Documentation Amazon EC2 Instance Types

ETCD Discovery Domain

What domain to use for etcd discovery.

Example: team.example.com

The supplied domain will be prefixed with _etcd-server-ssl._tcp. or _etcd-server._tcp. to resolve a dns SRV record. This record contains the IP-addresses and ports of the etcd cluster. Example output:

$ dig +noall +answer SRV _etcd-server._tcp.tutorial.team.example.com
_etcd-server._tcp.tutorial.team.example.com. 60 IN      SRV 1 1 2380 ip-172-31-152-102.eu-west-1.compute.internal.
_etcd-server._tcp.tutorial.team.example.com. 60 IN      SRV 1 1 2380 ip-172-31-152-103.eu-west-1.compute.internal.
_etcd-server._tcp.tutorial.team.example.com. 60 IN      SRV 1 1 2380 ip-172-31-161-166.eu-west-1.compute.internal.
_etcd-server._tcp.tutorial.team.example.com. 60 IN      SRV 1 1 2380 ip-172-31-131-14.eu-west-1.compute.internal.
_etcd-server._tcp.tutorial.team.example.com. 60 IN      SRV 1 1 2380 ip-172-31-131-15.eu-west-1.compute.internal.

etcd documentation DNS Discovery

Database Volume Size

The size for the volume containing the Database.

Database Volume Type

What EBS Volume type to use. Currently only three options are available:

  • gp2
  • io1
  • standard

Amazon Documentation Amazon EBS Volume Types

EBS Snapshot ID

When reusing an old EBS snapshot, specify its ID here.

Example: snap-e8bdf4c1

File system for the data partition

What file system to use for your PostgreSQL cluster. Choosing ext4 is a safe bet.

Example: ext4

Blog with a lot of pointers on what Filesystem to choose PostgreSQL performance on EXT4 and XFS

File system mount options

Which mount options for the file system containing the data.

Example: noatime,nodiratime,nobarrier

Scalyr Account key

The key with which Spilo is allowed to write Scalyr logs.

Example: W21hc3RlciA1NjExNDc2XSBBZGQgZ2VuZXJhdGVkIHBI-

Stups documentation Configuring Application Logging

PostgreSQL passwords

The passwords to use for the initial PostgreSQL users. These can be randomly generated and optionally can be encrypted using KMS.

KMS Encryption Key

Which key to use to encrypt the passwords in the template. By using KMS encryption we avoid storing the passwords in plain text anywhere. They will only be available to the EC2 instances running Spilo.