Thread: Create Publication v12
I understand in version 15 functionality was added to allow to create a publication for all tables within a schema. How would I need to do this in v12?
Ex.
Schema1:
Table1
Table2
Schema2:
Table1
Table2
?
The documentation for 12 does not show schema.table just table names
Thanks in advanced.
Ex.
Schema1:
Table1
Table2
Schema2:
Table1
Table2
?
The documentation for 12 does not show schema.table just table names
Thanks in advanced.
On Wed, Feb 26, 2025 at 1:17 PM Mike L <giantmetfan@comcast.net> wrote:
I understand in version 15 functionality was added to allow to create a publication for all tables within a schema. How would I need to do this in v12?
If it's a newly added feature in v15 there isn't a way to do the exact same thing in v12. In v12 you can get auto-add and wildcard on the full database only. If you need a subset, schema-based or otherwise, you need to list every entry and you will not have an auto-add behavior.
The documentation for 12 does not show schema.table just table names
Anywhere you can write a table name should be able to accept the full, schema-qualified, name even when it isn't called out explicitly.
David J.
If it has been added to v15, why not upgrade to the newest version? Sounds to me like a sound use case.
Well this is an Aws Aurora Postgresql 12.26 version cluster. The goal to upgrade this clusters, since it ran out of standard support 2/28/25, to 16.6. Due to size of clusters I am doing blue - green upgrade using 'fast clone' then upgrade that clone to 16.6. This will lessen the downtime.
So over 50 schemas in 12.16 publication has to be created in that version to get to 16.6
So over 50 schemas in 12.16 publication has to be created in that version to get to 16.6
On February 26, 2025 3:32:46 PM EST, Thiemo Kellner <thiemo@gelassene-pferde.biz> wrote:
If it has been added to v15, why not upgrade to the newest version? Sounds to me like a sound use case.
Mike L