Where is pgdata in postgres

Within the version-specific subdirectory, there is a subdirectory for each database that has elements in the tablespace, named after the database's OID. Tables and indexes are stored within that directory, using the filenode naming scheme. It is often useful as a substitute for remembering many of the above rules.

Development Versions: devel. Unsupported versions: 9. This documentation is for an unsupported version of PostgreSQL. You may want to view the same page for the current version, or one of the other supported versions listed above instead. I know I can just take the default and create a new database in the bigger file system, but should I? Improve this question. Plakhoy 1, 1 1 gold badge 17 17 silver badges 29 29 bronze badges.

Add a comment. Active Oldest Votes. Improve this answer. Ihor Romanchenko Ihor Romanchenko Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. This line is commented out in my PostgreSQL.

On OS X Jason S Jason S 3 3 bronze badges. Jacques Jacques 2 2 bronze badges. When I wrote this, I thought that at least it gives something close, assuming the datadir is not in a special location. Navid Navid Directory--Absolute Path 1. Scroll up your mouse to the left top of Mac Screen 2. Click the menu "Go" 3. Select the "Go to Folder Choose the button "Go" to the directory of Postgres.

You will eventually find out Postgres. Find the directory step by step 1. Scroll up your mouse to the left top of Mac Screen. Click the menu "Go". Select the button "Library" 4.

Double click the file holder "Application Support". Find out "Postgres" according to the alphabetic order. Cheers, Mike. The parameters described in this section allow the configuration files to be placed elsewhere. Doing so can ease administration. In particular it is often easier to ensure that the configuration files are properly backed-up when they are kept separate. Specifies the main server configuration file customarily called postgresql. This parameter can only be set on the postgres command line.