Clair export import

clair_export_import.sh

#!/bin/bash -x

QUAY_NAMESPACE='quay-enterprise'

CLAIR_POSTGRES_POD=$(oc get -n ${QUAY_NAMESPACE} pods | grep clair-postgres | awk -F\  '{print $1}')

echo "POD: ${CLAIR_POSTGRES_POD}"

oc rsh -n ${QUAY_NAMESPACE} ${CLAIR_POSTGRES_POD} /bin/sh -c  "pg_dump -U postgres -a -t feature -t keyvalue -t namespace -t schema_migrations -t vulnerability -t vulnerability_fixedin_feature clair" > clair_vulnerability.sql  

oc rsh -n ${QUAY_NAMESPACE} ${CLAIR_POSTGRES_POD} /bin/sh -c "pg_dump -U postgres -c -s clair" > clair_clear.sql

exit 0