> For the complete documentation index, see [llms.txt](https://dev-notes.vinguyen.blog/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dev-notes.vinguyen.blog/notes/deployment-and-operation/database/postgresql.md).

# PostgreSQL

- [PostgreSQL - Create a new primary key auto-increment column](https://dev-notes.vinguyen.blog/notes/deployment-and-operation/database/postgresql/postgresql-create-a-new-primary-key-auto-increment-column.md)
- [Generate uuid for all records in a table PostgreSQL](https://dev-notes.vinguyen.blog/notes/deployment-and-operation/database/postgresql/generate-uuid-for-all-records-in-a-table-postgresql.md)
- [Backup & Import all database PostgreSQL Inside Docker Container](https://dev-notes.vinguyen.blog/notes/deployment-and-operation/database/postgresql/backup-and-import-all-database-postgresql-inside-docker-container.md): Backup/dump & restore/import PostgreSQL Database running inside a container
- [Backup & Import single database PostgreSQL Inside Docker Container](https://dev-notes.vinguyen.blog/notes/deployment-and-operation/database/postgresql/backup-and-import-single-database-postgresql-inside-docker-container.md): Backup/dump & restore/import PostgreSQL Database running inside a container
- [PostgreSQL - Create user & grant permission on a database](https://dev-notes.vinguyen.blog/notes/deployment-and-operation/database/postgresql/postgresql-create-user-and-grant-permission-on-a-database.md): Create user & grant permission on a PostgreSQL database
- [PostgeSQL - Backup database via remote ssh server](https://dev-notes.vinguyen.blog/notes/deployment-and-operation/database/postgresql/postgesql-backup-database-via-remote-ssh-server.md): Backup a database from a remote server or via a server that have access permssion to local machine
- [Clean up pg walfile](https://dev-notes.vinguyen.blog/notes/deployment-and-operation/database/postgresql/clean-up-pg-walfile.md)