Error while running a restore
1 2 | ERROR: invalid input syntax for type timestamp with time zone: "202"COPY 4 |
Restore Command (I use docker but that isn't the problem)
1 2 3 | 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
1 2 3 | 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