Thanks for your information Serge Fonville, My answers
are below
1.Use a hight performance storage device (as applies with all
databases)
The
stroages are in cluster
2. everything that uis located in the PostgreSQL datadirectory can be
located on any device you prefer as long as the availability is guaranteed from
the perspective of the PostgreSQL processes.
Availability no issue, Is there any benchmark tool is
there to check the performance of Postgres in Storage
environment.
It would be helpful if you were more specific in what you want to know and
if it were a bit more clear of what your goals and environment is:
What OS are you using
RHEL5
What will be the purpose of the databases
Databases for webapplicaiton, datawarehousing
What environment do you have.
I
would like to keep the database in storage controller, which is
accessible through NFS.
What services should it provide
Web
services for continous read and write in the database
What database engines do you already have experience with
I
have experience with MySQL storage engines, specifically MyISAM,
Innodb.
Why do you want to know this (what is your endgoal)
The
performance of Postgresql in Storage environment. Also we would like to create
the Backup, Restore and DR solution using Storage
What have you already researched (googled)
Installation of Postgres, doing basic functionality
Are you migrating data or is it a new setup.
Now
New setup, But In future we might need to migrat the data from different
database like MySQL, Oracle
What do the servers look like
The
servers are IBM X86[32bit ]
To name a few questions that come to mind
Hope this helps
Regards,
Serge Fonville
On Thu, Feb 26, 2009 at 1:06 PM, Nagalingam, Karthikeyan
<KARTHIKEYAN.Nagalingam@xxxxxxxxxx>
wrote:
Hi,I have some basic query in postgresql with storage, Please help me for the following1. What is the best practice to use postgresql with storage.2. Which are the files and folders we can keep them in storage.RegardsKarthikeyan.N
