| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Shubham Khanna <khannashubham1197(at)gmail(dot)com> |
| Cc: | Euler Taveira <euler(at)eulerto(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, "kuroda(dot)hayato(at)fujitsu(dot)com" <kuroda(dot)hayato(at)fujitsu(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Ajin Cherian <itsajin(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, vignesh C <vignesh21(at)gmail(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
| Subject: | Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. |
| Date: | 2025-03-27 06:45:51 |
| Message-ID: | CAA4eK1+PnwEb-bMXHrK1t401dJT-_-XoB=7h+QEcbSEWL-S==A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Mar 26, 2025 at 4:02 PM Shubham Khanna
<khannashubham1197(at)gmail(dot)com> wrote:
>
Let's combine 0001 and 0002.
A few minor comments:
*
+ If database name is not specified in publisher-server, it will try to
+ connect with postgres/template1 database to fetch the databases from
+ primary.
Can we change the above to: "If the database name is not specified in
publisher-server, the postgres database will be used, or if that does
not exist, template1 will be used."
*
+ Create one subscription on the target server for each non-template
+ database on the source server that allows connections, excluding
+ template databases or databases with connection restrictions.
The following text proposed by Euler seems better: "Create one
subscription per database on the target server. Exceptions are
template databases and databases that don't allow connections."
Please use this one at the above and other places where required.
--
With Regards,
Amit Kapila.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladlen Popolitov | 2025-03-27 06:46:47 | Re: Remove useless casts to (char *) |
| Previous Message | Amit Kapila | 2025-03-27 06:29:24 | Re: Fix slot synchronization with two_phase decoding enabled |