Re: [ADMIN] comparing with oracle

2003-12-16 Thread Patrick Spinler
Your pardon, but I submit that the responder did answer your question. Unfortunately, your question may be meaningless in the context asked. Specifically, you are asking for an Oracle specific feature, which may not have any direct comparison in another system. Instead, it is better to ask how

Re: [ADMIN] Postgresql on software RAID

2003-12-16 Thread Patrick Spinler
Adam Witney wrote: Hi all, I am experimenting with a few OS's for my new hardware. I plan to have a software RAID5 device for my pgsql data directory. I have been experimenting with FreeBSD and with Linux, does anyone have any thoughts on whether vinum RAID devices are better than Linux software R

Re: [ADMIN] Running Postgres Daemons with same data files

2003-12-15 Thread Patrick Spinler
Just to add a tidbit on top of this, there are commercial RDBMS's that do, or at least say they do, clustered database servers. (cough cough oracle, cough cough ingres) The products are expensives as all get out, a bastard to set up, and require truely kickass SAN storage and clustered hardwar

[ADMIN] Insuring consistant backups

2002-12-09 Thread spinler
Hi: A question regarding backups. Commercial databases I've administered have had some facility to freeze or redirect transactions when a backup is being taken from a database which is online, in order to insure that the backup snapshots a consistant database. Does postgresql have a similar fa