Changes between Version 3 and Version 4 of sysadminPostgreSQLConfiguration
- Timestamp:
- Jun 23, 2009, 3:39:55 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
sysadminPostgreSQLConfiguration
v3 v4 51 51 Postgres uses the term "database cluster" to describe the directory it uses to store data. During the apt install, a default directory is created, usually at: /var/lib/postgresql/8.3/main. 52 52 53 '''NOTE: ''' our servers have been partitioned to best serve the needs of Evergreen. The default cluster location is not usually on a partition that has been sized appropriately for the db. Generally, you will ''' not ''' be using the default install directory.53 '''NOTE: ''' our servers have been partitioned to best serve the needs of Evergreen. The default location is not usually on a partition that has been sized appropriately for the Evergreen db. Generally, you will ''' not ''' be using the default install directory for your database cluster. 54 54 55 You will need to find the appropriate partition and install the appropriate files there. The patition is usually/data. To be sure, you can use the disk free command to see:55 You will need to determine the appropriate partition to install the cluster on. Usually, this is /data. To be sure, you can use the disk free command to see: 56 56 {{{ 57 57 df -h … … 72 72 }}} 73 73 74 Looking at the above, clearly the /data patition is the largest (84G) compared to the others. 74 Looking at the above, clearly the /data patition is the largest (84G) compared to the others. 75 ''' NOTE: ''' 75 76 76 Having located the largest partition, you will need to create directory for the data cluster, and give the postgres user full access to it. In the spirit of keeping things standardi sed, we have been using the /postgresql/<version>/main format.77 Having located the largest partition, you will need to create directory for the data cluster, and give the postgres user full access to it. In the spirit of keeping things standardized, we have been using the /postgresql/<version>/main format. 77 78 {{{ 78 79 sudo mkdir /data/postgresql/8.3/main … … 80 81 }}} 81 82 82 Now you need to initialize the 83 Now you need to initialize the data cluster. ''' Remember to include the -D switch to point it at the new directory you created above and not the default one! '''