-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/15/06 15:51, Martijn van Oosterhout wrote:
> On Wed, Nov 15, 2006 at 03:25:38PM -0600, Ron Johnson wrote:
>> However, what if the WAL is not on the SAN? You'd have to shut down
>> pg anyway, in order to copy the WAL to a new directory, no?
>
>
On Wed, Nov 15, 2006 at 03:25:38PM -0600, Ron Johnson wrote:
> However, what if the WAL is not on the SAN? You'd have to shut down
> pg anyway, in order to copy the WAL to a new directory, no?
You have to copy the *entire* cluster, you cannot split out one
database, for example. Two postmaster in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/15/06 14:46, Martijn van Oosterhout wrote:
>> How does it know what a crashed PostgreSQL database look like?
>>
>> Besides, active transactions need to be *rolled back*, not written
>> ahead, since half the data hasn't been sent from the computer
> How does it know what a crashed PostgreSQL database look like?
>
> Besides, active transactions need to be *rolled back*, not written
> ahead, since half the data hasn't been sent from the computer yet.
There's a section of the docs dealing with this:
http://www.postgresql.org/docs/8.1/static/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/15/06 14:28, Martijn van Oosterhout wrote:
> On Wed, Nov 15, 2006 at 01:41:47PM -0600, Ron Johnson wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 11/15/06 09:47, Jim Nasby wrote:
>>> On Nov 14, 2006, at 3:44 PM, Paul Silveira
On Wed, Nov 15, 2006 at 01:41:47PM -0600, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 11/15/06 09:47, Jim Nasby wrote:
> > On Nov 14, 2006, at 3:44 PM, Paul Silveira wrote:
> [snip]
> > Rule 2 is needed to ensure that the data files in the database are all
> > consi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/15/06 09:47, Jim Nasby wrote:
> On Nov 14, 2006, at 3:44 PM, Paul Silveira wrote:
[snip]
> Rule 2 is needed to ensure that the data files in the database are all
> consistent to each other. If you have a SAN/filesystem with snapshot
> capability
On Nov 14, 2006, at 3:44 PM, Paul Silveira wrote:
Does anyone know if it is possible to use SAN Splitting (the
function of
splitting a mirror of disks so that there are two idential copies of a
Postgres Instance)?
There are essentially 2 rules for doing a filesystem-level copy of
the databa
