Show data directory

sql

SHOW data_directory;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Server Control and Cluster Management

Find the active `postgresql.conf` path.

Open In sheetsqlsame section

Create a new PostgreSQL data directory.

Open In sheetbashsame section

Start a PostgreSQL server from a data directory.

Open In sheetbashsame section

Stop the server with fast shutdown mode.

Open In sheetbashsame section

Restart the server cleanly.

Open In sheetbashsame section

Probe whether the server is accepting connections.

Open In sheetbashsame section