Re: [ADMIN] Postgresql on software RAID

2003-12-16 Thread Robert Creager
When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600), Patrick Spinler <[EMAIL PROTECTED]> confessed: > > According to the theory they expound, a database with any significant > write activity whatsoever should never be on raid 5, but instead be on > raid 0+1. > Kind of related and a poin

Re: [ADMIN] Postgresql on software RAID

2003-12-17 Thread Robert Creager
When grilled further on (Wed, 17 Dec 2003 08:45:43 -0700 (MST)), "scott.marlowe" <[EMAIL PROTECTED]> confessed: > > Just wondering, was that on hardware or software RAID5, and if hardware > did it have battery backed cache controllers? Makes a huge difference. I > would never use SW RAID5 for

Re: [ADMIN] [SQL] Database diagram

2004-01-26 Thread Robert Creager
When grilled further on (Mon, 26 Jan 2004 18:02:59 +0700), "Chris Travers" <[EMAIL PROTECTED]> confessed: > I have been having trouble with it crashing (segfault) which is surprising > since it is written in Perl (must be a bum CPAN module, but I will have to > wait to figure out which one). Just

Re: [ADMIN] [SQL] Database diagram

2004-01-26 Thread Robert Creager
Hey Chris, I just installed version 1.22 from cpan and it fixed the problem. From a CPAN prompt (if you use it) . Cheers, Rob When grilled further on (Mon, 26 Jan 2004 20:17:57 +0700), "Chris Travers" <[EMAIL PROTECTED]> confessed: > I am using DBD::Pg 1.31. That may be the problem. Any su

[ADMIN] Log query results?

2004-02-10 Thread Robert Creager
Hey All, I'm running 7.4.1 and am having problem when my app starts loading up on the database. I want to verify the data coming back from the queries is correct from the server side (not application side), as then I'll be sure my app is squirrelly (or the db is). I don't see any options in pos

Re: [ADMIN] Log query results?

2004-02-11 Thread Robert Creager
When grilled further on (Wed, 11 Feb 2004 01:03:50 -0500), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > Nothing on the backend side that I can think of. If you're using libpq > then you could use PQtrace, though that&#x

Re: [ADMIN] Duplicating a large database.

2004-10-05 Thread Robert Creager
When grilled further on (Tue, 05 Oct 2004 17:26:16 -0700), Dan Hrabarchuk <[EMAIL PROTECTED]> confessed: > I need to move a large database to new machine. I'd also like to upgrade > my postgres server from 7.3 to 7.4 (at least). > I think Slony (http://www.slony.org) will do exactly what you des