Re: [ADMIN] fsync tests

2010-06-10 Thread Scott Marlowe
On Sun, Jun 6, 2010 at 5:07 PM, RBN wrote: > > > I ran test_fsync on a local ext 3 partition and on a raid jfs SSD array > 8x32GB RAID10.  The local disk returned quickly and gave what looks like > acceptable results.  However, the RAID looks pretty bad.  Any one have any > idea why fsync would ta

Re: [ADMIN] fsync tests

2010-06-10 Thread Bruce Momjian
RBN wrote: > I ran test_fsync on a local ext 3 partition and on a raid jfs SSD array > 8x32GB RAID10. The local disk returned quickly and gave what looks like > acceptable results. However, the RAID looks pretty bad. Any one have any > idea why fsync would take so long on an SSD RAID 10. As the

Re: [ADMIN] Fatal Error during PITR Recovery

2010-06-10 Thread Kevin Grittner
Gnanakumar" wrote: > what is the correct method of upgrading/installing to 8.2.17? > > Let me make the question/idea, which I'm thinking in my minding of > upgrading, clear here: > > 1. Rename '/usr/local/pgsql/data' to '/usr/local/pgsql/data.old' > 2. Install v8.2.17 to its default from the s

[ADMIN] BackupExec stops PostgreSQL service

2010-06-10 Thread Rob Richardson
Greetings! In an attempt to satisfy our client's requirements for redundancy, we ended up with an unusual (at least to my inexperienced eyes) system configuration. Our client has two buildings that use our application. Each building has an application server and a storage server. All are runnni

Re: [ADMIN] Fatal Error during PITR Recovery

2010-06-10 Thread Gnanakumar
Hi Kevin, Thank you very much for that valuable suggestion. When the migration section says "A dump/restore is not required ...", what is the correct method of upgrading/installing to 8.2.17? Let me make the question/idea, which I'm thinking in my minding of upgrading, clear here: 1. Rename '/u

Re: [ADMIN] Fatal Error during PITR Recovery

2010-06-10 Thread Gnanakumar
Hi Tom, Thanks for your comment. After posting this question here, I did a quick search in Google, and I'm finding other kind of reasons also, like a hardware problem, here: http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg69085.html But in my case, I don't think that this could be a

Re: [ADMIN] Fatal Error during PITR Recovery

2010-06-10 Thread Kevin Grittner
"Gnanakumar" wrote: > If I would like to upgrade to the latest minor version in 8.2.x > series, that is v8.2.17, how do I upgrade this [from 8.2.3 on > CentOS] without doing dump/restore? Links/documentation on this > are appreciated. >From the PostgreSQL home page there is a link to: http: