pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCreate Publication v12
4+ messages / 3 participants
[nested] [flat]
* Create Publication v12
@ 2025-02-26 20:16 Mike L <giantmetfan@comcast.net>
0 siblings, 2 replies; 4+ messages in thread
From: Mike L @ 2025-02-26 20:16 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Create Publication v12
@ 2025-02-26 20:22 David G. Johnston <david.g.johnston@gmail.com>
parent: Mike L <giantmetfan@comcast.net>
1 sibling, 0 replies; 4+ messages in thread
From: David G. Johnston @ 2025-02-26 20:22 UTC (permalink / raw)
To: Mike L <giantmetfan@comcast.net>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Create Publication v12
@ 2025-02-26 20:32 Thiemo Kellner <thiemo@gelassene-pferde.biz>
parent: Mike L <giantmetfan@comcast.net>
1 sibling, 1 reply; 4+ messages in thread
From: Thiemo Kellner @ 2025-02-26 20:32 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
If it has been added to v15, why not upgrade to the newest version? Sounds to me like a sound use case.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Create Publication v12
@ 2025-03-03 17:59 Mike L <giantmetfan@comcast.net>
parent: Thiemo Kellner <thiemo@gelassene-pferde.biz>
0 siblings, 0 replies; 4+ messages in thread
From: Mike L @ 2025-03-03 17:59 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-03-03 17:59 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-26 20:16 Create Publication v12 Mike L <giantmetfan@comcast.net>
2025-02-26 20:22 ` David G. Johnston <david.g.johnston@gmail.com>
2025-02-26 20:32 ` Thiemo Kellner <thiemo@gelassene-pferde.biz>
2025-03-03 17:59 ` Mike L <giantmetfan@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox