cloudquery notes - 7.6.2021

gistfile1.txt

# Copy image from GHCR into private ECR

aws ecr get-login-password --region eu-west-1 | docker login --username AWS --password-stdin 835367859851.dkr.ecr.eu-west-1.amazonaws.com

docker pull ghcr.io/cloudquery/cloudquery:0.13.4
docker tag ghcr.io/cloudquery/cloudquery:0.13.4 835367859851.dkr.ecr.eu-west-1.amazonaws.com/cloudquery:0.13.4
docker push 835367859851.dkr.ecr.eu-west-1.amazonaws.com/cloudquery:0.13.4


# Run Postgres locally

docker run --rm -p 5433:5432 postgres psql -h localhost -p 5432 -U postgres -d postgres

export CQ_DSN="host=localhost user=postgres password=pass DB.name=postgres port=5432"

cloudquery fetch --enable-console-log

cloudquery policy --enable-console-log


# Connect locally to posgres

export PGPASSWORD=pass
psql --host=localhost -Upostgres -dpostgres