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
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) |