By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,512 Members | 768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,512 IT Pros & Developers. It's quick & easy.

Linux partitions and Postgres

P: n/a
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?
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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?


Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.