Re: [ADMIN] too slow

2005-02-08 Thread Christopher Petrilli
I've found PostgreSQL to be much faster than MySQL when under load, and when mutliple people are involved, especially if there's a writer anywhere. Chrs -- | Christopher Petrilli | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate!

2005-01-12 Thread Christopher Petrilli
se the > postgres user for the database files. The advice seen elsewhere in > this thread to use the postgres user also for the software files is > wrong. As a security professional, why would the root user need to be involved in the ownership of PostgreSQL? I see no reason for this, bu

Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root" Debate!

2005-01-12 Thread Christopher Petrilli
ocal/pgsql/) must already be created and owned (it's the home for my user). The less done as root, the better. Chris -- | Christopher Petrilli | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Replication in main PostgreSQL codebase

2004-07-06 Thread Christopher Petrilli
oblem that is common to most situations, which is the ability to have a "live" backup. Perhaps the 'dbmirror' component in the 'contrib' directory is enough, and it simply needs to be highlighted. It does meet some subset of the needs out there. Sadly, a lot o