Re: pg_restore with connection limit 0

2019-11-27 Thread Олег Самойлов
> 27 нояб. 2019 г., в 18:14, Adrian Klaver > написал(а): > Why not use pg_hba.conf to allow only connection from superuser for duration? We considered this, but we don't have direct access to the linux server, only sql connection. The application run in a kubernetes, etc. The most simple ap

Re: pg_restore with connection limit 0

2019-11-27 Thread Adrian Klaver
On 11/27/19 7:06 AM, Олег Самойлов wrote: Hi all. I have task to refresh a test database from a production database (with masking) on the fly. To make masking we use pg_restore --create with three stages restoration. And one of the problem is daemons writing concurrently in the time of the re

pg_restore with connection limit 0

2019-11-27 Thread Олег Самойлов
Hi all. I have task to refresh a test database from a production database (with masking) on the fly. To make masking we use pg_restore --create with three stages restoration. And one of the problem is daemons writing concurrently in the time of the restoration of a database. I need to block the