Changes between Version 2 and Version 3 of sysadminPostgreSQLConfiguration


Ignore:
Timestamp:
Jun 23, 2009, 3:04:05 PM (13 years ago)
Author:
risard
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • sysadminPostgreSQLConfiguration

    v2 v3  
    5353  '''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.
    5454
    55 You will need to find the appropriate partition and install the appropriate files there.  This is usually:
     55You 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:
    5656{{{
    57     /data/postgresql/8.3/
     57    df -h
     58}}}
    5859
     60should result in something like:
     61{{{
     62    Filesystem        Size  Used Avail Use% Mounted on
     63
     64    /dev/mapper/LogVol00-VolGroup03
     65                      4.7G  145M  4.4G   4% /usr/local
     66    /dev/mapper/LogVol00-VolGroup07
     67                      1.9G  1.1G  797M  57% /var
     68    /dev/mapper/LogVol00-VolGroup08
     69                      1.9G   53M  1.8G   3% /var/log
     70    /dev/mapper/LogVol00-VolGroup09
     71                       84G   41G   39G  52% /data
     72}}}
     73
     74Looking at the above, clearly the /data patition is the largest (84G) compared to the others.
     75
     76Having 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 standardised, we have been using the /postgresql/<version>/main format.
     77{{{
     78    sudo mkdir /data/postgresql/8.3/main
     79    sudo chown postgres:postgres /data/postgresql/8.3/main
     80}}}
     81
     82Now you need to initialize the