Changes between Version 3 and Version 4 of sysadminPostgreSQLConfiguration


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

--

Legend:

Unmodified
Added
Removed
Modified

  • sysadminPostgreSQLConfiguration

    v3 v4  
    5151Postgres 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.
    5252
    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.
    5454
    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:
     55You 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:
    5656{{{
    5757    df -h
    … …  
    7272}}}
    7373
    74 Looking at the above, clearly the /data patition is the largest (84G) compared to the others.
     74Looking at the above, clearly the /data patition is the largest (84G) compared to the others. 
     75   ''' NOTE: '''
    7576
    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 standardised, we have been using the /postgresql/<version>/main format.
     77Having 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.
    7778{{{
    7879    sudo mkdir /data/postgresql/8.3/main
    … …  
    8081}}}
    8182
    82 Now you need to initialize the
     83Now 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! '''