pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark kirkwood <markir@slingshot.co.nz>
To: clayton cottingham <drfrog@telus.net>
To: Josh Berkus <josh@agliodbs.com>
Cc: p-sql <pgsql-sql@postgresql.org>
Subject: Re: comparision chart
Date: 23 Feb 2002 12:47:39 +1300
Message-ID: <1014421661.1538.23.camel@spikey.slithery.org> (raw)


Previously...
>
> Regarding your rating of Postgres, what do you mean by "partial"
>  support of constraints?  And what is "hotBack"?
> 

The confusing terms probably my fault - (Someone probably saw an old
posting of mine) - apologies in the time travelled sense...

I think partial constraint meant that there was "create" but no
"alter/drop/disable/enable" for them (This was circa Pg 7.0.0).

And I seem to recall thinking about a hotbackup in the sense of :
i) able to back up the db while it is running (and)
ii) able to use use the transaction logs to "catch up" after a media
failure (assuming the logs are backed up somehow too)

Clearly most of the crowd can do i), but fewer do ii) - mainly the
commercial ones.

I am less sure these days the ii) is so important. Many folks seem to
manage by means of using i) combined with replication or fault tolerance
at the os or hardware level (but I am ranging off the topic here...)

best wishes for the chart

regards

Mark

  




view thread (11+ messages)

Message-ID: <1014421661.1538.23.camel@spikey.slithery.org>
Permalink:  ../1014421661.1538.23.camel@spikey.slithery.org/
Also on:    postgresql.org/message-id/1014421661.1538.23.camel@spikey.slithery.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: markir@slingshot.co.nz, drfrog@telus.net, josh@agliodbs.com
  Subject: Re: comparision chart
  In-Reply-To: <1014421661.1538.23.camel@spikey.slithery.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox