473,383 Members | 1,870 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Linux partitions and Postgres

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
1 4402
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: RunLevelZero | last post by:
I need a way to detect hard drives and their partitions... labels would be nice too... I did some googling but did not find anything all too useful. This will strictly be on Linux / Unix so any...
6
by: cantabile | last post by:
Hi, I'd like to get drives and partitions (and their size too) with python under Linux. So far, I thought of reading /proc/partitions but maybe i could use fdsik also ? How would I do that in...
1
by: news | last post by:
OP wrote: }in order to justify learning another language I'd first need to be }convinced that python could easily do the following:- } }ReadSectors2Bufr(hdx, StartSectr, SectrCnt, Bufr); <-- like...
1
by: phil campaigne | last post by:
Tom Lane wrote: > phil campaigne <pcampaigne@charter.net> writes: > > >> when I login to linux and check the env's I see: >>...
10
by: Adam Witney | last post by:
Hi, Do people think linux 2.6.5 is stable enough yet for a production PostgreSQL server? Thanks Adam
0
by: Varun Gupta | last post by:
Hi all, Can any body guide me how to get access of the linux partitions through windows. As we used to access windows partitions in linux in terms of hda1, hda5....so on. where the hda1, hda5...
6
AmberJain
by: AmberJain | last post by:
I have installed Red Hat linux a few days ago and then I accessed ext3/ext2 partitions (on which linux is installed) from windows using some third party software. Now I wanna access FAT32...
1
Nepomuk
by: Nepomuk | last post by:
In most modern distributions of Linux and Unix (at least ones with graphical environments like KDE, Gnome or XFCE), you get to mount your partitions easily from the desktop. In some cases however, it...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.