Friday, August 19, 2011

where is my postgresql-data cluster ?

where is my postgresql-data cluster

  • If ever in doubt about where the your postgresql configuration files are, you can stick to these queries:


http://www.postgresonline.com/journal/archives/114-Where-is-my-data-and-other-stuff.html

And this one is of particular relevance:
SELECT name, setting FROM pg_settings WHERE category = 'File Locations'

The thing here is that you can have any number of pg clusters and work alternatively with each one of them. For example, you can have several versions of a cluster for testing purposes , and in that case this is one way of making sure you're working with the right cluster.

No comments:

Post a Comment