Vi Nguyen's Dev Notes
search
Ctrlk
  • 📓Dev Noteschevron-right
  • Deployment & Operation
    • Docker Containerchevron-right
    • Git
    • Ansiblechevron-right
    • Linuxchevron-right
    • Databasechevron-right
      • Check if database is reachable with nc
      • PostgreSQLchevron-right
        • PostgreSQL - Create a new primary key auto-increment column
        • Generate uuid for all records in a table PostgreSQL
        • Backup & Import all database PostgreSQL Inside Docker Container
        • Backup & Import single database PostgreSQL Inside Docker Container
        • PostgreSQL - Create user & grant permission on a database
        • PostgeSQL - Backup database via remote ssh server
        • Clean up pg walfile
      • Mysqlchevron-right
    • Ngnixchevron-right
  • Docker-compose sampleschevron-right
  • Homelabchevron-right
  • Development
    • Development Notes
  • My Resources
    • Blogarrow-up-right-from-square
    • Geek Toolsarrow-up-right-from-square
    • Dev Note Github Repoarrow-up-right-from-square
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. Deployment & Operationchevron-right
  2. Database

PostgreSQL

PostgreSQL - Create a new primary key auto-increment columnchevron-rightGenerate uuid for all records in a table PostgreSQLchevron-rightBackup & Import all database PostgreSQL Inside Docker Containerchevron-rightBackup & Import single database PostgreSQL Inside Docker Containerchevron-rightPostgreSQL - Create user & grant permission on a databasechevron-rightPostgeSQL - Backup database via remote ssh serverchevron-rightClean up pg walfilechevron-right