Warning: is_dir(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/virtuals/98151/virtual) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php:465) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/disable-xml-rpc-pingback/disable-xml-rpc-pingback.php on line 51
Replication Archives - PostgreSQL Candies

Check published and subscribed tables for PRIMARY KEYs

This problem can happen when you published some tables but later when you perform UPDATE operation you get error like this: ERROR: cannot update table “xxxxxx” because it does not have a replica identity and publishes updatesHINT: To enable updating the...

Setting logical replication is not entirely straight forward…

Logical replication in PostgreSQL 10 and 11 is amazing but make it working is not entirely straight forward and has some small gotchas. Also you can have specific problems with WAL segments if you publish and subscribe huge amount of the data. Another specific problem...

Add new disk and tablespace to PostgreSQL master and replica

This text may be “too obvious” but it also can save some nerves to someone 🙂 I might need it if you have PostgreSQL mater and replica(s) virtual instances with streaming replication and suddenly you face a problem with disk being too full and (as usual)...

Bash script – clone PostgreSQL replica

This script helps you create new PostgreSQL replica by cloning existing one. You have to prepare your new machine/ instance with as much the same environment as possible to your previous one. You definitely need the same main version of PostgreSQL and preferably also...