Install PostgreSQL of desired version on Ubuntu using Ansible
Ansible is so great and simple tool that even I can use it! 🙂 Here is a very simple playbook to install PostgreSQL of desired version on Ubuntu 14+: --- # this should work for any latest versions of Ubuntu and PostgreSQL # although tested only with Ubuntu 14 and Pg...Tags
aggregate functions
array functions
BSD
CAST command
COPY command
CREATE FUNCTION
CTID
current_query
data file
date time
dblink
deadlock
dependencies
DOMAIN command
EXISTS command
FOR cycle
freeze
IF...ELSE...END IF
information_schema
installation
JSON
operation system
parser
performance
pg_bulkload
pg_catalog
pg_class
pg_constraint
pg_database
pg_locks
pg_stat_activity
pg_stat_bgwriter
plv8
psql
recursive select
server configuration
string functions
system columns
system functions
TODO
vacuum
VALUES command
WAL log
window functions
xmin transaction ID
Recent Posts
- Check published and subscribed tables for PRIMARY KEYs
- Event triggers in PostgreSQL 11
- Repair referenced sequences on tables
- Problems with autovacuum during high load on server
- How to get information about partitions for new native partitioning in PostgreSQL
- Check / terminate postgresql processes
- How to check blocked queries
- Bash script – dump structures of parent tables one by one and upload them to Google storage
- Bash script – dump functions one by one and upload them to Google storage
- Bash script – dump tables one by one and upload dumps to Google storage
- Transaction ID wraparound error
- Block some user from connecting into PostgreSQL
- Setting logical replication is not entirely straight forward…
- Show source code of trigger function
- Default “postgres” database – how to re-create it
- PostgreSQL point in time recovery – experiences
- Experiences with PostgreSQL Google Cloud SQL
- Similarity of two strings – experiences
- Bash script for emergency stop of PostgreSQL
- Build latest pgloader from sources (Debian 9)
- Temporary tablespace – small notes
- Simple plpgsql script to set select only privileges for new user on a database
- pg_basebackup – bash script for backup and archiving on Google storage
- pg_basebackup – experiences
- pg_basebackup / pg-barman – restore tar backup
- pg-barman – check HW config of a server / instance
- Streaming replication – increase of max_connections on master can shutdown all your replicas
- Streaming replication / pg-barman – archiving WAL logs using script
- Add new disk and tablespace to PostgreSQL master and replica
- Hanging PostgreSQL session when called from GO lang or node.js program
- error: duplicate key value violates unique constraint pg_type_typname_nsp_index
- Dump and restore postgresql users (roles)
- Bash script – clone PostgreSQL replica
- Ansible – simple playbook for installing PostgreSQL on Ubuntu/ Debian
- SQL injection in PostgreSQL