0

Based on the official doc, CREATE PUBLICATION command is available on PostgreSQL 10 and later. However, I have a requirement to replicate PostgreSQL 9.5 to BigQuery using datastream, which require us to create a publication and a replication slot.

My question, can I create a pglogical node and replication set to achieve the same result as CREATE PUBLICATION command?

Command using pglogical:

SELECT pglogical.create_node(
    node_name := 'provider1',
    dsn := 'host=server_host port=5432 dbname=db_name'
);

SELECT pglogical.replication_set_add_all_tables('default', ARRAY['public']);

Command using publication:

CREATE PUBLICATION db_publication FOR ALL TABLES;

After above command, we need to create the replication slot with the following command:

SELECT PG_CREATE_LOGICAL_REPLICATION_SLOT('slot_name', 'pgoutput');

which seems are available on PostgreSQL 9.5.

If it's not possible to only use pglogical command, is there any alternative to replicate the DB to BigQuery? Thanks

1
  • Upgrade PostgreSQL rather than toying with fickle replication solutions. Commented Aug 28, 2023 at 6:28

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.