Re: [HACKERS] PostgreSQL HA questions

2006-09-27 Thread Chris Browne
[EMAIL PROTECTED] (Andrew Sullivan) writes: > It isn't clear to me why you think you need to do this: vacuum > doesn't block your queries anyway. If the idea is that you have a > table that you'd rather TRUNCATE and not have to vacuum, however, > that makes sense. There are several strategies for

Re: [HACKERS] PostgreSQL HA questions

2006-09-27 Thread Andrew Sullivan
First, I'm moving this to -general, because this is way off topic for -hackers as near as I can tell. On Tue, Sep 26, 2006 at 10:39:18PM +0200, Dragan Zubac wrote: > 1. Is it possible for multiply PostgreSQL instances (engines,cores) to use > same DATA space? No. In fact, this is a very good w

[HACKERS] PostgreSQL HA questions

2006-09-27 Thread Dragan Zubac
Hello We're looking for HA PostgreSQL solution,so have a couple of questions: 1. Is it possible for multiply PostgreSQL instances (engines,cores) to use same DATA space? For example,to have two PostgreSQL processes which will use same data directory,same files,and same data ? So,if You update som