jcardus/delete-positions-repack.sh

Created November 4, 2025 13:56

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jcardus/e978dc3ddbb60630040e65dc5b2d58e6.js"></script>
Save jcardus/e978dc3ddbb60630040e65dc5b2d58e6 to your computer and use it in GitHub Desktop.

Download ZIP

delete-positions-repack.sh

Raw

delete-positions-repack.sh

-#!/bin/bash
-DB="traccar"
-USER="neondb_owner"
-HOST="ep-late-cherry-a460jx6n.us-east-1.aws.neon.tech"
-export PGOPTIONS='-c idle_in_transaction_session_timeout=0'
-pg_repack -h $HOST -U $USER -d $DB --table=tc_positions -k -e

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment