/usr/share/postgresql/10/extension/pglogical--2.1.0--2.1.1.sql is in postgresql-10-pglogical 2.1.1-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 | ALTER TABLE pglogical.local_sync_status ADD COLUMN sync_statuslsn pg_lsn NULL;
UPDATE pglogical.local_sync_status SET sync_statuslsn = '0/0';
ALTER TABLE pglogical.local_sync_status ALTER COLUMN sync_statuslsn SET NOT NULL;
|