| Step | Arguments | | | Status |
|---|
| Start of Pipeline - (1 min 16 sec in block) | | | | |
| node - (1 min 14 sec in block) | | | | |
| node block - (1 min 14 sec in block) | | | | |
| stage - (2 sec in block) | Declarative: Checkout SCM | | | |
| stage block (Declarative: Checkout SCM) - (1.5 sec in block) | | | | |
| checkout - (1.3 sec in self) | | | | |
| withEnv - (1 min 11 sec in block) | GIT_BRANCH, GIT_COMMIT, GIT_PREVIOUS_COMMIT, GIT_PREVIOUS_SUCCESSFUL_COMMIT, GIT_URL | | | |
| withEnv block - (1 min 11 sec in block) | | | | |
| withEnv - (1 min 11 sec in block) | DOCKER_IMAGE, BACKUP_RETENTION, COMPOSE_FILE | | | |
| withEnv block - (1 min 11 sec in block) | | | | |
| timeout - (1 min 9 sec in block) | | | | |
| timeout block - (1 min 9 sec in block) | | | | |
| timestamps - (1 min 8 sec in block) | | | | |
| timestamps block - (1 min 8 sec in block) | | | | |
| stage - (5.9 sec in block) | Checkout | | | |
| stage block (Checkout) - (3.8 sec in block) | | | | |
| script - (3.3 sec in block) | | | | |
| script block - (3.1 sec in block) | | | | |
| cleanWs - (0.29 sec in self) | | | | |
| checkout - (1.4 sec in self) | | | | |
| echo - (46 ms in self) | ✅ Code checked out successfully | | | |
| pwd - (99 ms in self) | | | | |
| echo - (0.13 sec in self) | 📂 Working directory: /var/jenkins_home/workspace/postgres-deploy | | | |
| echo - (77 ms in self) | 🌿 Git branch: null | | | |
| echo - (0.69 sec in self) | 🏷️ Git commit: ade1f21be3ea31e81a6f387d5d2dfb8a955ff3da | | | |
| stage - (5.2 sec in block) | Validate Configuration | | | |
| stage block (Validate Configuration) - (3.3 sec in block) | | | | |
| script - (3 sec in block) | | | | |
| script block - (2.8 sec in block) | | | | |
| echo - (0.11 sec in self) | 🔍 Validating configuration files... | | | |
| fileExists - (0.15 sec in self) | docker-compose.yml | | | |
| echo - (0.1 sec in self) | ✅ Found: docker-compose.yml | | | |
| fileExists - (0.17 sec in self) | postgresql/conf/postgresql.conf | | | |
| echo - (0.25 sec in self) | ✅ Found: postgresql/conf/postgresql.conf | | | |
| fileExists - (0.18 sec in self) | postgresql/conf/pg_hba.conf | | | |
| echo - (0.13 sec in self) | ✅ Found: postgresql/conf/pg_hba.conf | | | |
| fileExists - (0.13 sec in self) | postgresql/init/01-init-database.sh | | | |
| echo - (0.11 sec in self) | ✅ Found: postgresql/init/01-init-database.sh | | | |
| fileExists - (0.15 sec in self) | .env.example | | | |
| echo - (72 ms in self) | ✅ Found: .env.example | | | |
| sh - (0.42 sec in self) |
echo "🐳 Validating Docker Compose files..."
docker-compose -f docker-compose.yml config --quiet
| | | |
| sh - (0.36 sec in self) |
echo "🗄️ Validating PostgreSQL configuration..."
# Basic syntax check for postgresql.conf
grep -E '^(shared_buffers|effective_cache_size|work_mem)' postgresql/conf/postgresql.conf
| | | |
| sh - (0.36 sec in self) |
echo "🔐 Checking Jenkins credentials configuration..."
echo "ℹ️ Note: Make sure you have configured these Jenkins credentials:"
echo " - postgres-password (Secret Text): Your PostgreSQL password"
echo " - postgres-db (String, optional): Database name (default: postgres)"
echo " - postgres-user (String, optional): Database user (default: postgres)"
echo "📝 Configure in: Jenkins → Manage Jenkins → Manage Credentials → (global)"
| | | |
| stage - (1.8 sec in block) | System Health Check | | | |
| stage block (System Health Check) - (1.5 sec in block) | | | | |
| script - (1.2 sec in block) | | | | |
| script block - (0.96 sec in block) | | | | |
| echo - (0.13 sec in self) | 🔍 Checking system resources... | | | |
| sh - (0.68 sec in self) |
if ! docker info >/dev/null 2>&1; then
echo "❌ Docker is not running"
exit 1
fi
echo "✅ Docker is running"
# Check system resources
echo "💾 Memory information:"
free -h
echo "💿 Disk space:"
df -h .
echo "🖥️ CPU information:"
nproc
| | | |
| stage - (35 sec in block) | Deploy PostgreSQL | | | |
| stage block (Deploy PostgreSQL) - (35 sec in block) | | | | |
| echo - (0.11 sec in self) | Warning, empty changelog. Have you run checkout? | | | |
| echo - (0.29 sec in self) | Warning, empty changelog. Have you run checkout? | | | |
| echo - (0.28 sec in self) | Warning, empty changelog. Have you run checkout? | | | |
| echo - (0.3 sec in self) | Warning, empty changelog. Have you run checkout? | | | |
| script - (33 sec in block) | | | | |
| script block - (32 sec in block) | | | | |
| echo - (0.1 sec in self) | 🚀 Deploying PostgreSQL... | | | |
| sh - (0.5 sec in self) | chmod +x postgresql/scripts/*.sh | | | |
| withCredentials - (32 sec in block) | | | | |
| withCredentials block - (31 sec in block) | | | | |
| sh - (31 sec in self) | | | | |
| echo - (50 ms in self) | ✅ PostgreSQL deployed successfully | | | |
| stage - (5.6 sec in block) | Verify Deployment | | | |
| stage block (Verify Deployment) - (5.3 sec in block) | | | | |
| script - (5 sec in block) | | | | |
| script block - (4.7 sec in block) | | | | |
| echo - (1.8 sec in self) | 🔍 Verifying deployment... | | | |
| withCredentials - (1.8 sec in block) | | | | |
| withCredentials block - (1.2 sec in block) | | | | |
| sh - (1.1 sec in self) | | | | |
| echo - (51 ms in self) | ✅ Deployment verification completed | | | |
| stage - (3.8 sec in block) | Performance Test | | | |
| stage block (Performance Test) - (3.6 sec in block) | | | | |
| script - (3.3 sec in block) | | | | |
| script block - (3.1 sec in block) | | | | |
| echo - (1.3 sec in self) | ⚡ Running performance tests... | | | |
| withCredentials - (1 sec in block) | | | | |
| withCredentials block - (0.67 sec in block) | | | | |
| sh - (0.59 sec in self) | | | | |
| echo - (49 ms in self) | ✅ Performance tests completed | | | |
| stage - (5 sec in block) | Create Backup | | | |
| stage block (Create Backup) - (3.2 sec in block) | | | | |
| script - (2.8 sec in block) | | | | |
| script block - (2.7 sec in block) | | | | |
| echo - (0.24 sec in self) | 💾 Creating deployment backup: jenkins_backup_20251123_024610.sql | | | |
| withCredentials - (2.1 sec in block) | | | | |
| withCredentials block - (1.7 sec in block) | | | | |
| sh - (1.6 sec in self) | | | | |
| archiveArtifacts - (0.18 sec in self) | | | | |
| stage - (5.3 sec in block) | Declarative: Post Actions | | | |
| stage block (Declarative: Post Actions) - (5.1 sec in block) | | | | |
| script - (1.7 sec in block) | | | | |
| script block - (1.5 sec in block) | | | | |
| echo - (0.94 sec in self) | 📋 Pipeline completed with status: SUCCESS | | | |
| echo - (84 ms in self) |
🎯 PostgreSQL Deployment Pipeline
📅 Build: 29
🌿 Branch: null
🏷️ Commit: ade1f21b
⏱️ Duration: 1 min 15 sec and counting
✅ Status: SUCCESS
| | | |
| sh - (0.34 sec in self) | find jenkins_backups -name "*.sql" -type f | sort -r | tail -n +6 | xargs rm -f || true | | | |
| script - (1.3 sec in block) | | | | |
| script block - (0.17 sec in block) | | | | |
| echo - (42 ms in self) | 🎉 PostgreSQL deployment successful! | | | |
| script - (1.7 sec in block) | | | | |
| script block - (1.2 sec in block) | | | | |
| echo - (62 ms in self) | 🧹 Cleaning up workspace... | | | |
| sh - (0.38 sec in self) | rm -f *.tmp || true | | | |
| echo - (40 ms in self) | ✅ Keeping containers running for automated backups (main branch or production) | | | |
