Vi Nguyen's Dev Notes
Ctrlk
  • 📓Dev Notes
  • Deployment & Operation
    • Docker Container
    • Git
    • Ansible
    • Linux
    • Database
      • Check if database is reachable with nc
      • PostgreSQL
        • 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
      • Mysql
    • Ngnix
  • Docker-compose samples
  • Homelab
  • Development
    • Development Notes
  • My Resources
    • Blog
    • Geek Tools
    • Dev Note Github Repo
Powered by GitBook
On this page
  1. Deployment & Operation
  2. Database

PostgreSQL

PostgreSQL - Create a new primary key auto-increment columnGenerate uuid for all records in a table PostgreSQLBackup & Import all database PostgreSQL Inside Docker ContainerBackup & Import single database PostgreSQL Inside Docker ContainerPostgreSQL - Create user & grant permission on a databasePostgeSQL - Backup database via remote ssh serverClean up pg walfile