Guides tagged “postgresql”
Step-by-step MdmHost guides about postgresql, sorted A-Z.
19 guides
Analyze PostgreSQL Query Plans with EXPLAIN ANALYZE
Use EXPLAIN ANALYZE to see the plan PostgreSQL actually ran, read scan and join nodes, and fix slow queries caused by bad row estimates or missing indexes.
Back up and restore PostgreSQL with pg_dump and pg_restore
Back up a PostgreSQL database with pg_dump, save roles with pg_dumpall, and restore with psql or pg_restore, including parallel jobs for large databases.
Back up MySQL and PostgreSQL databases in Docker containers
Dump MySQL, MariaDB and PostgreSQL databases that run inside Docker containers, compress the files, and ship them off the server with restic.
Configure PostgreSQL Remote Access with pg_hba.conf
Allow PostgreSQL remote access by setting listen_addresses, adding pg_hba.conf rules and opening the firewall, then verify the connection from a client.
Create PostgreSQL users, roles and databases
Create a PostgreSQL login role and a database for your application, set a password, grant the right privileges on the database and schema, and manage ownership.
Find Slow PostgreSQL Queries with pg_stat_statements
Enable the pg_stat_statements extension on PostgreSQL and use it to find the queries consuming the most time on your server.
Fix PostgreSQL "Too Many Clients Already" Errors
Diagnose and fix the PostgreSQL FATAL: sorry, too many clients already error by finding idle backends, tuning max_connections and adding a connection pooler.
Fix PostgreSQL Password Authentication Failed for User
Diagnose and fix the PostgreSQL "password authentication failed for user" error by checking pg_hba.conf rules, resetting the role password and reloading the server.
Install PostgreSQL and create your first database
Install PostgreSQL, create a role and database for your app, enable password logins, connect remotely without exposing the port, and take backups with pg_dump.
Install the latest PostgreSQL from the official PGDG repository
Add the PostgreSQL project's own apt or dnf repository to get a current major version on Ubuntu, Debian, AlmaLinux or Rocky Linux, and run more than one version side by side.
Manage database servers in Plesk: local, remote, MariaDB and PostgreSQL
Add local or remote MySQL, MariaDB and PostgreSQL servers in Plesk, set the default database server, change the admin password and upgrade MariaDB safely.
PostgreSQL Point-in-Time Recovery with WAL Archiving
Set up WAL archiving and restore a PostgreSQL cluster to an exact second with point-in-time recovery, using pg_basebackup, archive_command and a recovery target.
psql cheat sheet: essential PostgreSQL commands
The psql commands you need day to day, from connecting and listing databases, tables and roles to running SQL files and exporting query results to CSV.
Reset the PostgreSQL postgres user password
Set or reset the password of the postgres superuser, and regain access when normal logins fail by trusting local connections for a moment and then reverting.
Self-host n8n workflow automation with Docker
Run n8n on your own Linux VPS with Docker Compose and PostgreSQL, then publish the editor over HTTPS behind a reverse proxy.
Set Up PostgreSQL Streaming Replication on a Linux VPS
Configure a PostgreSQL primary with a replication role and slot, clone it with pg_basebackup, and bring up a standby that streams WAL in real time.
Troubleshoot PostgreSQL Locks and Blocking Queries
Find the session holding a PostgreSQL lock, read pg_locks and pg_stat_activity, and cancel or terminate blocking queries without losing data.
Tune PostgreSQL Autovacuum and VACUUM Settings
Autovacuum defaults are built for large servers, not small VPSs. This guide shows how to adjust thresholds, cost limits and per-table settings to control table bloat.
Upgrade PostgreSQL with pg_upgrade: A Safe Major Version Upgrade
Move a PostgreSQL cluster to a new major version with pg_upgrade, including the compatibility check, the upgrade run and the post-upgrade analyze.
Browse by topic
- Getting startedYour first hour with a new server: access, logins and basics.69 guides
- cPanelFiles, databases, email, domains and every cPanel tool, step by step.37 guides
- WHM & resellingWHM, packages, reseller accounts, WHMReseller and running a hosting brand.49 guides
- WordPressInstall, secure, speed up, migrate and fix WordPress sites.40 guides
- Email & webmailMailboxes, webmail, forwarders, spam filters and email delivery.37 guides
- DomainsRegistering, transferring and managing domains and nameservers.20 guides
- SSL certificatesFree AutoSSL, Let's Encrypt, paid certificates and HTTPS.19 guides
- CloudLinuxCloudLinux setup and use: LVE limits, CloudLinux Manager, CageFS and PHP/Node.js selectors.31 guides
- LiteSpeedLiteSpeed Web Server, LSCache and the LiteSpeed Cache plugin: install, settings and tuning.30 guides
- Imunify360Malware scanning, firewall and proactive defence with Imunify360.23 guides
- SoftaculousInstall, update, clone and back up apps with Softaculous.23 guides
- WP SquaredcPanel's WordPress platform: sites, plugins, staging and backups.9 guides
- SitePadBuild and publish websites with the SitePad builder.9 guides
- SitejetDesign, edit and publish sites with the Sitejet builder.9 guides
- WHMResellerAlpha and master resellers with WHMReseller: install, setup and use.12 guides
- VirtFusionInstall, set up and manage VirtFusion: hypervisors, packages, servers and WHMCS integration.7 guides
- VirtualizorManage your VPS with Virtualizor: power, OS reinstall, VNC, IPs and backups.30 guides
- PleskWebsites, email, databases and settings in the Plesk panel.52 guides
- DirectAdminUsers, domains, email and reseller tools in DirectAdmin.40 guides
- WHMCSBilling, automation, products and client management with WHMCS.51 guides
- Control panelscPanel & WHM, Plesk, DirectAdmin and other panels on your VPS.106 guides
- SecurityKeys, passwords, firewalls and keeping a server patched.115 guides
- Networking & DNSIP addresses, reverse DNS, ports and traffic.34 guides
- Websites & appsWeb servers, WordPress, PHP, Node.js, SSL and app hosting.52 guides
- DatabasesMySQL, MariaDB, PostgreSQL, Redis and MongoDB on a VPS.64 guides
- Billing & accountInvoices, renewals, the client area and your account.9 guides
- TroubleshootingWhen something is not working: checks and fixes.68 guides
- Linux VPSSSH, packages, services and everyday Linux administration.70 guides
- Windows VPS & RDPRemote Desktop, Windows Server settings and Admin RDP tips.58 guides
- Docker & DevOpsContainers, Git deploys, automation, monitoring and backups.58 guides
Still stuck?
Ask MdmHost AI for a quick answer, or open a ticket and our team will take a look. We are here 24/7.