By type
+ /dbcmd-config/db_migrator_pg_policy_init.sh
Initializing policyadmin...
321 blocks
Preparing upgrade release version: 0800
Preparing upgrade release version: 0900
Preparing upgrade release version: 1000
Preparing upgrade release version: 1100
Preparing upgrade release version: 1200
Preparing upgrade release version: 1300
Done
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
CREATE TABLE
CREATE TABLE
INSERT 0 1
name | version
-------------+---------
policyadmin | 0
(1 row)
id | script | operation | from_version | to_version | tag | success | attime
----+--------+-----------+--------------+------------+-----+---------+--------
(0 rows)
policyadmin: upgrade available: 0 -> 1300
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
NOTICE: relation "schema_versions" already exists, skipping
CREATE TABLE
CREATE TABLE
NOTICE: relation "policyadmin_schema_changelog" already exists, skipping
upgrade: 0 -> 1300
rc=0
> upgrade 0100-jpapdpgroup_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0110-jpapdpstatistics_enginestats.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0120-jpapdpsubgroup_policies.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0130-jpapdpsubgroup_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0150-jpatoscacapabilityassignment_attributes.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0160-jpatoscacapabilityassignment_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0170-jpatoscacapabilityassignment_occurrences.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0180-jpatoscacapabilityassignment_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0190-jpatoscacapabilitytype_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0200-jpatoscacapabilitytype_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0210-jpatoscadatatype_constraints.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0220-jpatoscadatatype_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0230-jpatoscadatatype_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0240-jpatoscanodetemplate_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0250-jpatoscanodetemplate_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0260-jpatoscanodetype_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0270-jpatoscanodetype_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0280-jpatoscapolicy_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0290-jpatoscapolicy_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0300-jpatoscapolicy_targets.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0310-jpatoscapolicytype_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0320-jpatoscapolicytype_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0330-jpatoscapolicytype_targets.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0340-jpatoscapolicytype_triggers.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0350-jpatoscaproperty_constraints.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0360-jpatoscaproperty_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0370-jpatoscarelationshiptype_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0380-jpatoscarelationshiptype_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0390-jpatoscarequirement_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0400-jpatoscarequirement_occurrences.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0410-jpatoscarequirement_properties.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0420-jpatoscaservicetemplate_metadata.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0430-jpatoscatopologytemplate_inputs.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0440-pdpgroup_pdpsubgroup.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0450-pdpgroup.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0460-pdppolicystatus.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0470-pdp.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0480-pdpstatistics.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0490-pdpsubgroup_pdp.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0500-pdpsubgroup.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0510-toscacapabilityassignment.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0520-toscacapabilityassignments.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0540-toscacapabilitytype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0550-toscacapabilitytypes.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0570-toscadatatype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0580-toscadatatypes.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0590-toscadatatypes_toscadatatype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0600-toscanodetemplate.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0610-toscanodetemplates.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0620-toscanodetemplates_toscanodetemplate.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0630-toscanodetype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0640-toscanodetypes.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0650-toscanodetypes_toscanodetype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0660-toscaparameter.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0670-toscapolicies.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0680-toscapolicies_toscapolicy.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0690-toscapolicy.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0700-toscapolicytype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0710-toscapolicytypes.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0720-toscapolicytypes_toscapolicytype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0730-toscaproperty.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0740-toscarelationshiptype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0750-toscarelationshiptypes.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0770-toscarequirement.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0780-toscarequirements.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0790-toscarequirements_toscarequirement.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0800-toscaservicetemplate.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0810-toscatopologytemplate.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0820-toscatrigger.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0850-FK_ToscaNodeType_requirementsName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0940-PdpPolicyStatus_PdpGroup.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0980-FK_ToscaNodeType_requirementsName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1050-FK_ToscaTopologyTemplate_policyName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0100-pdp.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0110-idx_tsidx1.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0120-pk_pdpstatistics.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0130-pdpstatistics.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0140-pk_pdpstatistics.sql
UPDATE 0
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0150-pdpstatistics.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0160-jpapdpstatistics_enginestats.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0170-jpapdpstatistics_enginestats.sql
UPDATE 0
INSERT 0 1
rc=0
> upgrade 0180-jpapdpstatistics_enginestats.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0190-jpapolicyaudit.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0200-JpaPolicyAuditIndex_timestamp.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0210-sequence.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0220-sequence.sql
INSERT 0 1
INSERT 0 1
rc=0
> upgrade 0100-jpatoscapolicy_targets.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0110-jpatoscapolicytype_targets.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0120-toscatrigger.sql
DROP TABLE
INSERT 0 1
rc=0
> upgrade 0130-jpatoscapolicytype_triggers.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0140-toscaparameter.sql
DROP TABLE
INSERT 0 1
rc=0
> upgrade 0150-toscaproperty.sql
DROP TABLE
DROP TABLE
DROP TABLE
INSERT 0 1
rc=0
> upgrade 0160-jpapolicyaudit_pk.sql
ALTER TABLE
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0170-pdpstatistics_pk.sql
ALTER TABLE
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0180-jpatoscanodetemplate_metadata.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0100-upgrade.sql
msg
---------------------------
upgrade to 1100 completed
(1 row)
INSERT 0 1
rc=0
> upgrade 0100-jpapolicyaudit_renameuser.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0110-idx_tsidx1.sql
DROP INDEX
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0120-audit_sequence.sql
CREATE TABLE
INSERT 0 1
INSERT 0 1
rc=0
> upgrade 0130-statistics_sequence.sql
CREATE TABLE
INSERT 0 1
INSERT 0 1
rc=0
> upgrade 0100-pdpstatistics.sql
DROP TABLE
INSERT 0 1
rc=0
> upgrade 0110-jpapdpstatistics_enginestats.sql
DROP TABLE
INSERT 0 1
rc=0
> upgrade 0120-statistics_sequence.sql
DROP TABLE
INSERT 0 1
INSERT 0 1
policyadmin: OK: upgrade (1300)
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
CREATE TABLE
NOTICE: relation "schema_versions" already exists, skipping
NOTICE: relation "policyadmin_schema_changelog" already exists, skipping
CREATE TABLE
name | version
-------------+---------
policyadmin | 1300
(1 row)
id | script | operation | from_version | to_version | tag | success | attime
-----+---------------------------------------------------------------+-----------+--------------+------------+-------------------+---------+----------------------------
1 | 0100-jpapdpgroup_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:22.208714
2 | 0110-jpapdpstatistics_enginestats.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:22.309272
3 | 0120-jpapdpsubgroup_policies.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:22.482059
4 | 0130-jpapdpsubgroup_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:22.603673
5 | 0140-jpapdpsubgroup_supportedpolicytypes.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:22.695382
6 | 0150-jpatoscacapabilityassignment_attributes.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:22.784758
7 | 0160-jpatoscacapabilityassignment_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:22.93557
8 | 0170-jpatoscacapabilityassignment_occurrences.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.032274
9 | 0180-jpatoscacapabilityassignment_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.158109
10 | 0190-jpatoscacapabilitytype_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.246187
11 | 0200-jpatoscacapabilitytype_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.344712
12 | 0210-jpatoscadatatype_constraints.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.466674
13 | 0220-jpatoscadatatype_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.615221
14 | 0230-jpatoscadatatype_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.697358
15 | 0240-jpatoscanodetemplate_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.82306
16 | 0250-jpatoscanodetemplate_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:23.939113
17 | 0260-jpatoscanodetype_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:24.161384
18 | 0270-jpatoscanodetype_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:25.40869
19 | 0280-jpatoscapolicy_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:26.018254
20 | 0290-jpatoscapolicy_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:27.016383
21 | 0300-jpatoscapolicy_targets.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:27.391619
22 | 0310-jpatoscapolicytype_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:27.911786
23 | 0320-jpatoscapolicytype_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:28.80956
24 | 0330-jpatoscapolicytype_targets.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:29.009056
25 | 0340-jpatoscapolicytype_triggers.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:29.936262
26 | 0350-jpatoscaproperty_constraints.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:30.373586
27 | 0360-jpatoscaproperty_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:30.552625
28 | 0370-jpatoscarelationshiptype_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:30.686605
29 | 0380-jpatoscarelationshiptype_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:30.833381
30 | 0390-jpatoscarequirement_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:30.964158
31 | 0400-jpatoscarequirement_occurrences.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:31.054034
32 | 0410-jpatoscarequirement_properties.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:31.196653
33 | 0420-jpatoscaservicetemplate_metadata.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:31.332843
34 | 0430-jpatoscatopologytemplate_inputs.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:31.473132
35 | 0440-pdpgroup_pdpsubgroup.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:31.620214
36 | 0450-pdpgroup.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:31.763129
37 | 0460-pdppolicystatus.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:31.86252
38 | 0470-pdp.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:32.102242
39 | 0480-pdpstatistics.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:32.212893
40 | 0490-pdpsubgroup_pdp.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:32.360581
41 | 0500-pdpsubgroup.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:32.682072
42 | 0510-toscacapabilityassignment.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:32.915145
43 | 0520-toscacapabilityassignments.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.019962
44 | 0530-toscacapabilityassignments_toscacapabilityassignment.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.127342
45 | 0540-toscacapabilitytype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.243389
46 | 0550-toscacapabilitytypes.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.333149
47 | 0560-toscacapabilitytypes_toscacapabilitytype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.482092
48 | 0570-toscadatatype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.677665
49 | 0580-toscadatatypes.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.759959
50 | 0590-toscadatatypes_toscadatatype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.842441
51 | 0600-toscanodetemplate.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:33.937358
52 | 0610-toscanodetemplates.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:34.014129
53 | 0620-toscanodetemplates_toscanodetemplate.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:34.139233
54 | 0630-toscanodetype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:34.227859
55 | 0640-toscanodetypes.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:34.304801
56 | 0650-toscanodetypes_toscanodetype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:34.420566
57 | 0660-toscaparameter.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:34.928779
58 | 0670-toscapolicies.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:35.492841
59 | 0680-toscapolicies_toscapolicy.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:35.916742
60 | 0690-toscapolicy.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:36.27883
61 | 0700-toscapolicytype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:36.527075
62 | 0710-toscapolicytypes.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:36.621544
63 | 0720-toscapolicytypes_toscapolicytype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:36.75093
64 | 0730-toscaproperty.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:36.884564
65 | 0740-toscarelationshiptype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:37.013343
66 | 0750-toscarelationshiptypes.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:37.141773
67 | 0760-toscarelationshiptypes_toscarelationshiptype.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:37.289374
68 | 0770-toscarequirement.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:37.396384
69 | 0780-toscarequirements.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:37.562951
70 | 0790-toscarequirements_toscarequirement.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:37.690922
71 | 0800-toscaservicetemplate.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.011666
72 | 0810-toscatopologytemplate.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.128693
73 | 0820-toscatrigger.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.271813
74 | 0830-FK_ToscaNodeTemplate_capabilitiesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.365482
75 | 0840-FK_ToscaNodeTemplate_requirementsName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.452547
76 | 0850-FK_ToscaNodeType_requirementsName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.579346
77 | 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.753507
78 | 0870-FK_ToscaServiceTemplate_dataTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.881876
79 | 0880-FK_ToscaServiceTemplate_nodeTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:38.99594
80 | 0890-FK_ToscaServiceTemplate_policyTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.087013
81 | 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.200596
82 | 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.335165
83 | 0920-FK_ToscaTopologyTemplate_policyName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.456487
84 | 0940-PdpPolicyStatus_PdpGroup.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.545886
85 | 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.637965
86 | 0960-FK_ToscaNodeTemplate_capabilitiesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.713228
87 | 0970-FK_ToscaNodeTemplate_requirementsName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.815367
88 | 0980-FK_ToscaNodeType_requirementsName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.907726
89 | 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:39.995766
90 | 1000-FK_ToscaServiceTemplate_dataTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:40.079162
91 | 1010-FK_ToscaServiceTemplate_nodeTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:40.201859
92 | 1020-FK_ToscaServiceTemplate_policyTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:40.284924
93 | 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:40.378316
94 | 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:40.514205
95 | 1050-FK_ToscaTopologyTemplate_policyName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:40.659264
96 | 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql | upgrade | 0 | 0800 | 2406251049340800u | 1 | 2025-06-24 10:49:40.789311
97 | 0100-pdp.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:40.873889
98 | 0110-idx_tsidx1.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:40.970553
99 | 0120-pk_pdpstatistics.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.042887
100 | 0130-pdpstatistics.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.11593
101 | 0140-pk_pdpstatistics.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.207034
102 | 0150-pdpstatistics.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.278117
103 | 0160-jpapdpstatistics_enginestats.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.348689
104 | 0170-jpapdpstatistics_enginestats.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.414455
105 | 0180-jpapdpstatistics_enginestats.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.500623
106 | 0190-jpapolicyaudit.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.60923
107 | 0200-JpaPolicyAuditIndex_timestamp.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.716003
108 | 0210-sequence.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.831021
109 | 0220-sequence.sql | upgrade | 0800 | 0900 | 2406251049340900u | 1 | 2025-06-24 10:49:41.904512
110 | 0100-jpatoscapolicy_targets.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.002238
111 | 0110-jpatoscapolicytype_targets.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.09731
112 | 0120-toscatrigger.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.173288
113 | 0130-jpatoscapolicytype_triggers.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.362678
114 | 0140-toscaparameter.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.442185
115 | 0150-toscaproperty.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.523445
116 | 0160-jpapolicyaudit_pk.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.60871
117 | 0170-pdpstatistics_pk.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.737204
118 | 0180-jpatoscanodetemplate_metadata.sql | upgrade | 0900 | 1000 | 2406251049341000u | 1 | 2025-06-24 10:49:42.817092
119 | 0100-upgrade.sql | upgrade | 1000 | 1100 | 2406251049341100u | 1 | 2025-06-24 10:49:42.909514
120 | 0100-jpapolicyaudit_renameuser.sql | upgrade | 1100 | 1200 | 2406251049341200u | 1 | 2025-06-24 10:49:43.036108
121 | 0110-idx_tsidx1.sql | upgrade | 1100 | 1200 | 2406251049341200u | 1 | 2025-06-24 10:49:43.142936
122 | 0120-audit_sequence.sql | upgrade | 1100 | 1200 | 2406251049341200u | 1 | 2025-06-24 10:49:43.281291
123 | 0130-statistics_sequence.sql | upgrade | 1100 | 1200 | 2406251049341200u | 1 | 2025-06-24 10:49:43.380671
124 | 0100-pdpstatistics.sql | upgrade | 1200 | 1300 | 2406251049341300u | 1 | 2025-06-24 10:49:43.461418
125 | 0110-jpapdpstatistics_enginestats.sql | upgrade | 1200 | 1300 | 2406251049341300u | 1 | 2025-06-24 10:49:43.543925
126 | 0120-statistics_sequence.sql | upgrade | 1200 | 1300 | 2406251049341300u | 1 | 2025-06-24 10:49:43.635963
(126 rows)
policyadmin: OK @ 1300
Initializing clampacm...
97 blocks
Preparing upgrade release version: 1400
Preparing upgrade release version: 1500
Preparing upgrade release version: 1600
Preparing upgrade release version: 1601
Preparing upgrade release version: 1700
Preparing upgrade release version: 1701
Done
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
NOTICE: relation "schema_versions" already exists, skipping
CREATE TABLE
CREATE TABLE
INSERT 0 1
name | version
----------+---------
clampacm | 0
(1 row)
id | script | operation | from_version | to_version | tag | success | attime
----+--------+-----------+--------------+------------+-----+---------+--------
(0 rows)
clampacm: upgrade available: 0 -> 1701
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
CREATE TABLE
NOTICE: relation "schema_versions" already exists, skipping
NOTICE: relation "clampacm_schema_changelog" already exists, skipping
CREATE TABLE
upgrade: 0 -> 1701
rc=0
> upgrade 0100-automationcomposition.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0200-automationcompositiondefinition.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0300-automationcompositionelement.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0400-nodetemplatestate.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0500-participant.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0600-participantsupportedelements.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0700-ac_compositionId_index.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0800-ac_element_fk_index.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0900-dt_element_fk_index.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 1000-supported_element_fk_index.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 1100-automationcompositionelement_fk.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1200-nodetemplate_fk.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 1300-participantsupportedelements_fk.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0100-automationcomposition.sql
ALTER TABLE
UPDATE 0
INSERT 0 1
rc=0
> upgrade 0200-automationcompositiondefinition.sql
ALTER TABLE
UPDATE 0
INSERT 0 1
rc=0
> upgrade 0300-participantreplica.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0400-participant.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0500-participant_replica_fk_index.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0600-participant_replica_fk.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0700-automationcompositionelement.sql
UPDATE 0
INSERT 0 1
rc=0
> upgrade 0800-nodetemplatestate.sql
UPDATE 0
INSERT 0 1
rc=0
> upgrade 0100-automationcomposition.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0200-automationcompositionelement.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0100-automationcomposition.sql
UPDATE 0
INSERT 0 1
rc=0
> upgrade 0200-automationcompositionelement.sql
UPDATE 0
UPDATE 0
INSERT 0 1
rc=0
> upgrade 0100-message.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0200-messagejob.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0300-messagejob_identificationId_index.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0100-automationcompositionrollback.sql
CREATE TABLE
INSERT 0 1
rc=0
> upgrade 0200-automationcomposition.sql
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0300-automationcompositionelement.sql
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0400-automationcomposition_fk.sql
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0500-automationcompositiondefinition.sql
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0600-nodetemplatestate.sql
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0700-mb_identificationId_index.sql
CREATE INDEX
INSERT 0 1
rc=0
> upgrade 0800-participantreplica.sql
UPDATE 0
UPDATE 0
ALTER TABLE
INSERT 0 1
rc=0
> upgrade 0900-participantsupportedacelements.sql
UPDATE 0
UPDATE 0
ALTER TABLE
INSERT 0 1
INSERT 0 1
clampacm: OK: upgrade (1701)
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
CREATE TABLE
NOTICE: relation "schema_versions" already exists, skipping
NOTICE: relation "clampacm_schema_changelog" already exists, skipping
CREATE TABLE
name | version
----------+---------
clampacm | 1701
(1 row)
id | script | operation | from_version | to_version | tag | success | attime
----+--------------------------------------------+-----------+--------------+------------+-------------------+---------+----------------------------
1 | 0100-automationcomposition.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:45.142118
2 | 0200-automationcompositiondefinition.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:45.70742
3 | 0300-automationcompositionelement.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:46.114581
4 | 0400-nodetemplatestate.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:46.320136
5 | 0500-participant.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:46.442301
6 | 0600-participantsupportedelements.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:46.580124
7 | 0700-ac_compositionId_index.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:46.669898
8 | 0800-ac_element_fk_index.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:46.776926
9 | 0900-dt_element_fk_index.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:46.875217
10 | 1000-supported_element_fk_index.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:46.995139
11 | 1100-automationcompositionelement_fk.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:47.070208
12 | 1200-nodetemplate_fk.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:47.175236
13 | 1300-participantsupportedelements_fk.sql | upgrade | 1300 | 1400 | 2406251049571400u | 1 | 2025-06-24 10:49:47.307284
14 | 0100-automationcomposition.sql | upgrade | 1400 | 1500 | 2406251049571500u | 1 | 2025-06-24 10:49:47.488432
15 | 0200-automationcompositiondefinition.sql | upgrade | 1400 | 1500 | 2406251049571500u | 1 | 2025-06-24 10:49:47.589595
16 | 0300-participantreplica.sql | upgrade | 1400 | 1500 | 2406251049571500u | 1 | 2025-06-24 10:49:47.839526
17 | 0400-participant.sql | upgrade | 1400 | 1500 | 2406251049571500u | 1 | 2025-06-24 10:49:47.93447
18 | 0500-participant_replica_fk_index.sql | upgrade | 1400 | 1500 | 2406251049571500u | 1 | 2025-06-24 10:49:48.172712
19 | 0600-participant_replica_fk.sql | upgrade | 1400 | 1500 | 2406251049571500u | 1 | 2025-06-24 10:49:48.280993
20 | 0700-automationcompositionelement.sql | upgrade | 1400 | 1500 | 2406251049571500u | 1 | 2025-06-24 10:49:48.388126
21 | 0800-nodetemplatestate.sql | upgrade | 1400 | 1500 | 2406251049571500u | 1 | 2025-06-24 10:49:48.892127
22 | 0100-automationcomposition.sql | upgrade | 1500 | 1600 | 2406251049571600u | 1 | 2025-06-24 10:49:49.520138
23 | 0200-automationcompositionelement.sql | upgrade | 1500 | 1600 | 2406251049571600u | 1 | 2025-06-24 10:49:50.407462
24 | 0100-automationcomposition.sql | upgrade | 1501 | 1601 | 2406251049571601u | 1 | 2025-06-24 10:49:50.791754
25 | 0200-automationcompositionelement.sql | upgrade | 1501 | 1601 | 2406251049571601u | 1 | 2025-06-24 10:49:51.414237
26 | 0100-message.sql | upgrade | 1600 | 1700 | 2406251049571700u | 1 | 2025-06-24 10:49:51.587185
27 | 0200-messagejob.sql | upgrade | 1600 | 1700 | 2406251049571700u | 1 | 2025-06-24 10:49:51.716881
28 | 0300-messagejob_identificationId_index.sql | upgrade | 1600 | 1700 | 2406251049571700u | 1 | 2025-06-24 10:49:51.844905
29 | 0100-automationcompositionrollback.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.005772
30 | 0200-automationcomposition.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.173994
31 | 0300-automationcompositionelement.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.272477
32 | 0400-automationcomposition_fk.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.350684
33 | 0500-automationcompositiondefinition.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.4502
34 | 0600-nodetemplatestate.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.561136
35 | 0700-mb_identificationId_index.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.682266
36 | 0800-participantreplica.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.777407
37 | 0900-participantsupportedacelements.sql | upgrade | 1601 | 1701 | 2406251049571701u | 1 | 2025-06-24 10:49:52.899208
(37 rows)
clampacm: OK @ 1701
Initializing pooling...
4 blocks
Preparing upgrade release version: 1600
Done
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
NOTICE: relation "schema_versions" already exists, skipping
CREATE TABLE
CREATE TABLE
INSERT 0 1
name | version
---------+---------
pooling | 0
(1 row)
id | script | operation | from_version | to_version | tag | success | attime
----+--------+-----------+--------------+------------+-----+---------+--------
(0 rows)
pooling: upgrade available: 0 -> 1600
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
NOTICE: relation "schema_versions" already exists, skipping
CREATE TABLE
CREATE TABLE
NOTICE: relation "pooling_schema_changelog" already exists, skipping
upgrade: 0 -> 1600
rc=0
> upgrade 0100-distributed.locking.sql
CREATE TABLE
CREATE INDEX
CREATE INDEX
INSERT 0 1
INSERT 0 1
pooling: OK: upgrade (1600)
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
CREATE TABLE
NOTICE: relation "schema_versions" already exists, skipping
CREATE TABLE
NOTICE: relation "pooling_schema_changelog" already exists, skipping
name | version
---------+---------
pooling | 1600
(1 row)
id | script | operation | from_version | to_version | tag | success | attime
----+------------------------------+-----------+--------------+------------+-------------------+---------+----------------------------
1 | 0100-distributed.locking.sql | upgrade | 1500 | 1600 | 2406251050051600u | 1 | 2025-06-24 10:49:53.999608
(1 row)
pooling: OK @ 1600
Initializing operationshistory...
6 blocks
Preparing upgrade release version: 1600
Done
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
NOTICE: relation "schema_versions" already exists, skipping
CREATE TABLE
CREATE TABLE
INSERT 0 1
name | version
-------------------+---------
operationshistory | 0
(1 row)
id | script | operation | from_version | to_version | tag | success | attime
----+--------+-----------+--------------+------------+-----+---------+--------
(0 rows)
operationshistory: upgrade available: 0 -> 1600
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
NOTICE: relation "schema_versions" already exists, skipping
CREATE TABLE
CREATE TABLE
NOTICE: relation "operationshistory_schema_changelog" already exists, skipping
upgrade: 0 -> 1600
rc=0
> upgrade 0100-ophistory_id_sequence.sql
CREATE TABLE
INSERT 0 1
INSERT 0 1
rc=0
> upgrade 0110-operationshistory.sql
CREATE TABLE
CREATE INDEX
CREATE INDEX
INSERT 0 1
INSERT 0 1
operationshistory: OK: upgrade (1600)
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-------------------+----------+----------+-----------------+-------------+-------------+------------+-----------+----------------------------
clampacm | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
migration | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
operationshistory | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyadmin | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
policyclamp | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
pooling | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =Tc/postgres +
| | | | | | | | postgres=CTc/postgres +
| | | | | | | | "policy-user"=CTc/postgres
postgres | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | |
template0 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf-8 | en_US.utf-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(9 rows)
NOTICE: relation "schema_versions" already exists, skipping
CREATE TABLE
NOTICE: relation "operationshistory_schema_changelog" already exists, skipping
CREATE TABLE
name | version
-------------------+---------
operationshistory | 1600
(1 row)
id | script | operation | from_version | to_version | tag | success | attime
----+--------------------------------+-----------+--------------+------------+-------------------+---------+----------------------------
1 | 0100-ophistory_id_sequence.sql | upgrade | 1500 | 1600 | 2406251050071600u | 1 | 2025-06-24 10:49:55.294202
2 | 0110-operationshistory.sql | upgrade | 1500 | 1600 | 2406251050071600u | 1 | 2025-06-24 10:49:55.428928
(2 rows)
operationshistory: OK @ 1600