BestHub
Sign in
Tag

psql

1 views collected around this technical thread.

Raymond Ops
Raymond Ops
Dec 21, 2024 · Databases

Why Does PostgreSQL Show “FATAL: password authentication failed for user ‘postgres’” and How to Fix It?

This guide explains why a PostgreSQL connection attempt fails with “FATAL: password authentication failed for user ‘postgres’”, outlines common causes such as wrong passwords and misconfigured postgresql.conf or pg_hba.conf, and provides step‑by‑step solutions including password reset, config correction, trust authentication and environment rebuild.

ConfigurationPostgreSQLTroubleshooting
0 likes · 6 min read
Why Does PostgreSQL Show “FATAL: password authentication failed for user ‘postgres’” and How to Fix It?
Qunar Tech Salon
Qunar Tech Salon
Jul 13, 2015 · Databases

Mapping MySQL Commands and Features to PostgreSQL psql Equivalents

This article compares MySQL client commands and features with their PostgreSQL psql equivalents, covering general command‑line options, SQL‑level operations such as showing tables, creating tables, listing databases, using databases, handling auto‑increment, process lists, global variables, and function‑level differences, plus practical code snippets.

Command-lineMySQLPostgreSQL
0 likes · 6 min read
Mapping MySQL Commands and Features to PostgreSQL psql Equivalents