start pglogical subscription from a specific lsn

2024-09-22 Thread plsqlvids01 plsqlvids01
Hi, Is it possible to start a pglogical subscription from a specific lsn? I am on 16.2 pg version and pglogical extension version is 2.4.4, don't see any argument to pass lsn in pglogical.create_subscription function.

unable to upgrade postgres extensions

2024-08-21 Thread plsqlvids01 plsqlvids01
AWS RDS Postgres database on v12.17 is upgraded to v16.1, as per https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-16x am trying to upgrade pg_cron and pgaudit extensions but it keeps throwing the same error, how to upgrade them? p

use of postgres reg* datatypes in user tables?

2024-08-18 Thread plsqlvids01 plsqlvids01
What is the use of postgres regclass datatype in user tables? When would one want to use them when regular data types are available? If any tables have these data types, since pg_upgrade would fail, what data types should those be converted to? ``` postgres=> select version();