lt;[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 8:14 AM
Subject: [ADMIN] Redundant databases/real-time backup
> Several people have expressed an interest in having the capability to have
real
> time redundancy. I am releasing my kludge solution to the mailing list in
hope
>
an insert,
update, or delete.
- Original Message -
From: "Lockhurst" <[EMAIL PROTECTED]>
To: "rhampton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "kevin harvey" <[EMAIL PROTECTED]>
Sent: Monday, January 01, 2001 9:57 AM
Subject: Re: Fw: [A
sert statements.
>
> Early thanks for any help
>
> Wish you all a vey happy new 2001.
>
> Lockhurst
>
> ----- Original Message -
> From: "root" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 16, 2000 8:14 AM
> Subject
Sent: Thursday, November 23, 2000 8:28 AM
> Subject: Re: [ADMIN] Redundant databases/real-time backup
>
> > On Thu, Nov 16, 2000 at 11:14:15AM -0500, root wrote:
> > > It is necessary to create/alter the postgresql startup script. I have
> included
> > > a copy of mine.
: "root" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 23, 2000 8:28 AM
Subject: Re: [ADMIN] Redundant databases/real-time backup
> On Thu, Nov 16, 2000 at 11:14:15AM -0500, root wrote:
> > It is necessary to create/alter the postgresql startup sc
On Thu, Nov 30, 2000 at 12:08:20AM -0800, hamptone wrote:
> > [ about processing the postgresql log ]
>
> Thanks for the tips Ragnar...although I wish you would explain more about
> FIFO. The only thing that rings a bell on this is First In First Out from
> the inventory chaper of my accounting t
On Thu, Nov 16, 2000 at 11:14:15AM -0500, root wrote:
> It is necessary to create/alter the postgresql startup script. I have included
> a copy of mine. The database to be mirrored must start up with logging
> enabled:
>
> su -l postgres -c '/usr/bin/postmaster -i -D/home/postgres/data
>>/home
Several people have expressed an interest in having the capability to have real
time redundancy. I am releasing my kludge solution to the mailing list in hope
that others might expand upon it.
First, you should dump your database, drop it, and recreate it on the computer
to be mirrored. You sho
