skills.rest
L3DigitalNet
L3DigitalNetOFFICIAL
Explore all skills by this author →
WebsiteGitHub

postgresql

Manages PostgreSQL server installation, configuration, backups, replication, and troubleshooting on Linux.

6|1|Updated Feb 16, 2026
Search Tags:#performance#database#postgresql#backup#sql#linux#administration
One-click install
npx skills add https://github.com/L3DigitalNet/Claude-Code-Plugins --skill postgresql-l3digitalnet
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql
Source: https://github.com/L3DigitalNet/Claude-Code-Plugins/tree/main/plugins/linux-sysadmin/skills/postgresql
Command: npx skills add https://github.com/L3DigitalNet/Claude-Code-Plugins --skill postgresql-l3digitalnet

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance and commands for managing PostgreSQL database servers, ensuring smooth operation, performance, and security.

Core Features & Use Cases

  • Installation & Configuration: Guides through setting up PostgreSQL on various Linux distributions.
  • User & Database Management: Simplifies creating, granting privileges to, and managing users and databases.
  • Backup & Restore: Offers commands for backing up and restoring single or all databases.
  • Performance Tuning: Provides insights into monitoring and optimizing query performance and resource usage.
  • Replication & High Availability: Details setup for streaming replication.
  • Troubleshooting: Addresses common errors and provides diagnostic steps.

Quick Start

Use the postgresql skill to check the status of the PostgreSQL service on your system.

Frequently Asked Questions about postgresql

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

FAQPage Schema
How do I set up streaming replication for PostgreSQL on Linux?▼

To set up streaming replication for PostgreSQL, configure the primary server's pg_hba.conf and postgresql.conf files, then use pg_basebackup on the standby server to clone the database and start replication.

What causes PostgreSQL authentication failures and how do I fix them?▼

PostgreSQL authentication failures usually occur due to misconfigured pg_hba.conf settings or incorrect user privileges. Fix them by verifying authentication methods and ensuring the database user has proper login permissions.

How do I back up and restore a single PostgreSQL database?▼

Back up a single PostgreSQL database using the pg_dump command, and restore it using pg_restore or psql with the appropriate file targeting the specific database.

Do I need SQL and Linux administration knowledge to manage a PostgreSQL server?▼

Yes, managing a PostgreSQL server requires knowledge of SQL for database operations and Linux system administration commands for effective installation, configuration, and service management.

How can I troubleshoot PostgreSQL connection refusals and lock contention?▼

Troubleshoot PostgreSQL connection refusals by checking service status and port configurations, and resolve lock contention by querying pg_locks to identify blocking queries and terminating them if necessary.

What is the best way to tune PostgreSQL query performance and resource usage?▼

The best way to tune PostgreSQL performance is by monitoring query execution plans and resource usage, then adjusting configuration parameters like shared_buffers and work_mem to optimize database operations.

Related Skills

Explore More Software Engineering Skills→
pluginagentmarketplacepluginagentmarketplace
1

postgresql

Automate PostgreSQL administration tasks for production deployments across Linux, macOS, and Docker.

Community
Advanced
adiytharpansaadiytharpansa

database-operator

Manage queries, schemas, and performance across SQL and NoSQL databases.

Community
Intermediate
microsoftmicrosoft
242

azure-postgres

Configure passwordless Entra ID authentication for Azure PostgreSQL Flexible Server.

Official
Advanced
LeandroBenjaminLLeandroBenjaminL

db-admin

Manage database administration tasks for PostgreSQL, MySQL, Redis, and SQLite.

Community
Advanced