Skip site navigation (1) Skip section navigation (2)

New Installation

From: Keith Worthington <KeithW(at)NarrowPathInc(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: New Installation
Date: 2004-08-19 01:33:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I am about to begin my first installation of PostgreSQL. :-)  At the 
moment I am installing Red Hat Linux ES v3 on a brand new machine for 
use as a database server.    The machine has two RAID arrays.  The first 
is an 18GB RAID 0 array that I intend to use as the system drive (/boot, 
/, swap space, etc.) while the second is a 140GB RAID 5 array that I 
plan to utilize for the database.  I am at the point where I need to 
partition the arrays.  What considerations do I need to keep in mind?  
Where does the PostgreSQL software get installed?  Where are the log 
files kept?  What directory does the database end up in?  Are indexes, 
procedures, tables, etc stored in separate locations?  Should they be 
for performance reasons?  What can I do now while installing the OS and 
eventually PostgreSQL to avoid problems and improve performance in the 
future?  TIA for helping out a newbie.

Kind Regards,


pgsql-novice by date

Next:From: George WeaverDate: 2004-08-19 01:52:08
Subject: Re: pgAdmin Connection
Previous:From: Tom LaneDate: 2004-08-19 01:29:30
Subject: Re: Removing Database Names as Spaces?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group