logical replication help

From: Stuart Watson <wtsnstrt(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: logical replication help
Date: 2022-08-15 14:24:41
Message-ID: CACeu7zKzJWTQRbG9nOSWfAzFfdW2a1svvFxVoTUnhQ4nXUHORg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi there

We have a ruby on rails application that does a full rebuild daily.
Currently we have 1 web server running nginx and a db server running
postgres 10.

Currently the rebuild takes the site down for a couple of hours.

My plan to solve this is to create a second postgres server and carry out
the db rebuild daily on this new server and then use logical replication to
copy this back to to the original server, before updating the ruby on rails
applications database.yml file to point to the new database.

Will this solution work? Is there anything I should be aware of?

There are other databases on the original server hence the reason for doing
logical replication.

Thanks

Stuart

Browse pgsql-admin by date

  From Date Subject
Next Message Satyamnaidu Gokeda 2022-08-16 19:20:10
Previous Message Ron 2022-08-12 05:08:20 Re: a question about Point-in-Time Recovery (PITR)