This is an internal documentation. There is a good chance you’re looking for something else. See Disclaimer.

Databases

• Clean up Unsed DBs
  • Useful Queries
• Connect to Database
  • Option a) via OpenShift
  • Option b) via ssh
• Copy/Dump/Restore Database
  • Copy Database
  • Dump Database
  • Restore Database
  • Copy database using WITH TEMPLATE
• Move Database between Servers
• Pre-Move
• Move
• Post-Move
• Postgres Replication
  • What to do if Replication Streaming on Postgres fails
• Psql Tips and Tricks
  • Getting Help
  • Enable Extended Output
  • Change Password
• Postgres Remote Access
  • Using SSH Port Forwarding
  • Direct Access
• SQL Snippets (Nice)
  • User Management
  • Jobs (Task_execution)
• SQL Snippets (Postgres)
  • Show Queries Running in Postgres
  • Forcibly Close Connections to DB
• Scripts (Postgres)
  • n2sql-on-all-dbs
  • n2change-db-owner
  • n2passwd