skills.rest
BagelHole
BagelHoleCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

postgresql

Administer PostgreSQL databases including installation, configuration, backup, and replication.

46|4|Updated Jan 27, 2026
Search Tags:#database#postgresql#backup#replication#performance tuning#administration
One-click install
npx skills add https://github.com/BagelHole/DevOps-Security-Agent-Skills --skill postgresql-bagelhole
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql
Source: https://github.com/BagelHole/DevOps-Security-Agent-Skills/tree/main/infrastructure/databases/postgresql
Command: npx skills add https://github.com/BagelHole/DevOps-Security-Agent-Skills --skill postgresql-bagelhole

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps manage PostgreSQL databases, addressing the complexities of setup, configuration, backups, and replication for reliable data storage.

Core Features & Use Cases

  • Installation & Setup: Guides through installing PostgreSQL and creating databases and users.
  • Configuration Tuning: Provides key parameters for optimizing performance (postgresql.conf).
  • Backup & Restore: Details methods for backing up and restoring PostgreSQL databases using pg_dump and pg_restore.
  • Replication Setup: Outlines steps for setting up primary and replica servers for high availability.

Quick Start

Install PostgreSQL and create a new database named 'myapp_db' owned by the user 'myapp'.

Frequently Asked Questions about postgresql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up PostgreSQL replication for high availability?▼

PostgreSQL replication setup involves configuring a primary server and one or more replica servers to ensure high availability. This process maintains data integrity and availability through synchronized database copies for failover support.

What's the best way to backup and restore a PostgreSQL database?▼

Backing up and restoring PostgreSQL databases is best handled using the pg_dump and pg_restore utilities. These tools provide reliable methods to create database backups and restore them, ensuring data integrity during operational recovery.

How do I tune PostgreSQL configuration parameters for better performance?▼

Tuning PostgreSQL performance requires modifying key parameters in the postgresql.conf file. Adjusting these configuration settings optimizes database operations and ensures efficient resource utilization for your specific deployment workload.

How do I install PostgreSQL and create a new database with a specific user?▼

Installing PostgreSQL and creating a database involves setting up the server and using administrative commands to define a new database and assign a specific user as its owner. This establishes the foundational environment for application data storage.

When do I need to manage PostgreSQL database administration tasks?▼

PostgreSQL database administration is needed when setting up reliable data storage, addressing the complexities of configuration, backups, and replication. Database administrators and DevOps engineers require these operational practices to ensure data integrity and availability.

Does this PostgreSQL management approach work for DevOps deployment workflows?▼

Yes, this approach addresses the operational needs of DevOps engineers managing PostgreSQL deployments. It covers installation, configuration tuning, backup procedures, and replication setup required for maintaining reliable database infrastructure in automated environments.

Related Skills

Explore More Software Engineering Skills→
Start9LabsStart9Labs
4

start-cli

Manage StartOS servers, packages, backups, networking, and s9pk development via CLI.

Official
Advanced
seb1nseb1n
147

database-backup

Automate PostgreSQL, MySQL, and MongoDB backup planning, scheduling, and verification.

Community
Advanced
arbazkhan971arbazkhan971
26

postgres

Optimize PostgreSQL production performance with tuning, indexing, and replication guidance.

Community
Advanced
samhvw8samhvw8
10

databases

Guide MongoDB and PostgreSQL schema design, query optimization, migrations, and backups.

Community
Advanced