Software⏱️ 2 min read📅 2026-05-31

How to Fix: `pg_tblspc` missing after installation of latest version of OS X (Yosemite or El Capitan)

Postgres directory issue after OS X update.

Quick Answer: Try reinstalling postgres with the `--initdb` option to recreate the pg_tblspc directory.

The `pg_tblspc` directory is a crucial part of the Postgres database, and its absence can cause issues during startup. In OS X Yosemite or El Capitan, this directory may not be created by default after installing the latest version of the operating system.

🔍 Why This Happens

  • [Cause]

🚀 How to Resolve This Issue

Method 1: Create the `pg_tblspc` Directory

  1. Step 1: Run the command `sudo rm -rf /usr/local/var/postgres` to delete the existing Postgres directory.

Method 2: Use a Postgres Installer

  1. Step 1: Install the Homebrew Postgres package using `brew install postgres`.

💡 Conclusion

By following these steps, you should be able to resolve the issue and get your Postgres database up and running smoothly.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions