Error while running a restore
ERROR: invalid input syntax for type timestamp with time zone: "202"
COPY 4
Restore Command (I use docker but that isn’t the problem)
zcat ${RECOVERY_FILE} | docker run --env PGPASSWORD -i --rm \
postgres:14.5 psql -d ${DB_NAME} \
-h ${DB_HOST} -p ${DB_PORT} -U ${DB_USER}
Cause
Corrupt backup file. Rerun backup
Backup Command
docker run --env PGPASSWORD --rm \
postgres:14.5 pg_dump --clean -d ${DB_NAME} -h ${DB_HOST} \
-p ${DB_PORT} -U ${DB_USER} | gzip > ${BACKUP_TO}
0 Comments