davidc0le opened a new issue #6712:
URL: https://github.com/apache/trafficcontrol/issues/6712
## This Bug Report affects these Traffic Control components:
- Traffic Ops
## Current behavior:
This issue is similar to #4984 . When running postinstall twice when using
the Postgres backend for Traffic Vault, the load_schema operation for Traffic
Vault causes an error. The command _db/admin --trafficvault -env=production
load_schema_ is executed by the postinstall. The error is as follows:
```
ALTER TABLE ONLY dnssec
ADD CONSTRAINT dnssec_pkey PRIMARY KEY (cdn);
ERROR: multiple primary keys for table "dnssec" are not allowed
Can't create database tables
```
## Expected behavior:
As per #4984, running postinstall twice should be possible without errors.
## Steps to reproduce:
Run Postinstall with postgres being used for the Traffic Vault backend.
Run Postinstall again with the same input
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
