Configuring pg_squeeze
======================

1. Add ``pg_squeeze`` to the ``shared_preload_libraries`` parameter:

.. code:: ini

      shared_preload_libraries = pg_squeeze

..  Note::
   If `shared_preload_libraries`  has other extensions, then you can add `pg_squeeze`  to the list. The order doesn't matter.  !!!

1. Add these changes to ``postgresql.conf`` :

.. code:: shell

     wal_level = logical
     max_replication_slots = 1 # ... or add 1 to the current value.

1. Restart Postgres.

2. Create the ``pg_squeeze`` extension in your database:

.. code:: shell

     CREATE EXTENSION pg_squeeze;

..  Note ::
   When upgrading a database cluster with `pg_squeeze`  installed (either using `pg_dumpall` /`pg_restore`  or `pg_upgrade` ), make sure that the new cluster has `pg_squeeze`  in `shared_preload_libraries`  before you upgrade. Otherwise the upgrade fails.