Linux partitions and Postgres

[Anthony Ewell]

Hi All,

I am in the unique situation of designing a new Red Hat 9
server to run a Postgres database in a small company. The
database that is being converted is currently 30 MB. There
will be 20 users maximum.

As I am a newbie to Postgres, I do not know where the data is
stored (/usr?). Since I am starting from scratch, I thought I'd
ask the group for suggestions on how they would partition
the hard drive for Postgres. Is there a way to put it on its
own partition?

Many thanks,
--Tony
ae****@gbis.com

p.s. until I get hooked up with a news server for this group,
would you reply to both the eMail address and the newsgroup?

[rstp]

30 MB is quite small, so unless you have a very small hard drive you
shouldn't have to worry. If you install postgres yourself the postgres
home is /usr/local/pgsql and the data is stored in
/usr/local/pgsql/data. If the db might grow considerably I would
increase the size of /usr. I believe that the default RedHat pre-install
location is in another directory, but I don't know where.

If you install it yourself, you can place postgres and/or the data
directory in your directory of choice.

Ron

Anthony Ewell wrote:

Hi All,

I am in the unique situation of designing a new Red Hat 9
server to run a Postgres database in a small company. The
database that is being converted is currently 30 MB. There
will be 20 users maximum.

As I am a newbie to Postgres, I do not know where the data is
stored (/usr?). Since I am starting from scratch, I thought I'd
ask the group for suggestions on how they would partition
the hard drive for Postgres. Is there a way to put it on its
own partition?

Many thanks,
--Tony
ae****@gbis.com

p.s. until I get hooked up with a news server for this group,
would you reply to both the eMail address and the newsgroup?