Skip to content
This repository was archived by the owner on Nov 24, 2025. It is now read-only.
This repository was archived by the owner on Nov 24, 2025. It is now read-only.

'admin' tool should use pq #4954

@ocket8888

Description

@ocket8888

I'm submitting a ...

  • improvement request (usability, performance, tech debt, etc.)

Traffic Control components affected ...

  • other

Current behavior:

admin shells out to subprocess using a psql binary` for database operations.

Expected / new behavior:

The admin tool should use a postgresql adapter to make database connections instead of relying on shelling out to a psql binary somewhere in the system's path. That'd make database errors more transparent (I'm currently getting the extremely helpful error message "unable to determine if user already exists: exit status 2"), and would eliminate the dependency on the postgresql client.

Metadata

Metadata

Assignees

Labels

databaserelating to setup/installation/structure of the Traffic Ops databaselow difficultythe estimated level of effort to resolve this issue is lowlow impactaffects only a small portion of a CDN, and cannot itself break onenew featureA new feature, capability or behaviortoolsrelated to tools outside of main components, e.g. 'compare'

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions