Where does PostgreSQL store the database?

by

To see where the data directory is, use this query.

show data_directory;

To see all the run-time parameters, use

show all;

You can create tablespaces to store database objects in other parts of the filesystem. To see tablespaces, which might not be in that data directory, use this query.

SELECT *, pg_tablespace_location(oid) FROM pg_tablespace;

More Related Contents:

  1. Why the “Group BY” by month didn’t work? [closed]
  2. What to do with null values when modeling and normalizing?
  3. Postgres: INSERT if does not exist already
  4. Truncating all tables in a Postgres database
  5. How can I drop all the tables in a PostgreSQL database?
  6. postgres default timezone
  7. quick random row selection in Postgres
  8. Copy a table from one database to another in Postgres
  9. Can I automatically create a table in PostgreSQL from a csv file with headers?
  10. User defined variables in PostgreSQL
  11. How to add an auto-incrementing primary key to an existing table, in PostgreSQL?
  12. Postgres query optimization (forcing an index scan)
  13. psql: FATAL: database “” does not exist
  14. Postgres FOR LOOP
  15. Omitting the double quote to do query on PostgreSQL
  16. Storing Images in PostgreSQL
  17. Strange behaviour in Postgresql
  18. Postgres: Distinct but only for one column
  19. In PostgreSQL, how to insert data with COPY command?
  20. Cursor based records in PostgreSQL
  21. How to add column if not exists on PostgreSQL?
  22. Maximum characters in labels (table names, columns etc)
  23. Docker – Postgres and pgAdmin 4 : Connection refused
  24. Configuration parameter work_mem in PostgreSQL on Linux
  25. How to work with PGpoint for Geolocation using PostgreSQL?
  26. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  27. input file appears to be a text format dump. Please use psql
  28. Hashing a String to a Numeric Value in PostgreSQL
  29. Spring Docker container cannot access Postgres Docker container
  30. PostgreSQL composite primary key

Leave a Comment