Re: [ADMIN] replication using WAL archives

2005-06-04 Thread Bruce Momjian
This thread has been added as a link on the TODO list under TODO.detail. --- Gaetano Mendola wrote: > Robert Treat wrote: > > On Thu, 2004-10-21 at 02:44, Iain wrote: > > > >>Hi, > >> > >>I thought I read something about t

Re: [ADMIN] replication using WAL archives

2004-10-22 Thread Gaetano Mendola
Simon Riggs wrote: > Situation I thought I saw was: > > - copy away current partial filled xlog N > - xlog N fills, N+1 starts > - xlog N+1 fills, N+2 starts > - copy away current partial filled xlog: N+2 (+10 secs later) > > i.e. if time to fill xlog (is ever) < time to copy away current xlog, > t

Re: [ADMIN] replication using WAL archives

2004-10-22 Thread Simon Riggs
On Fri, 2004-10-22 at 17:44, Gaetano Mendola wrote: > | Gaetano - skim-reading your script, how do you handle the situation when a > | new xlog file has been written within 10 seconds? That way the current file > | number will have jumped by 2, so when your script looks for the "Last wal" > | using

Re: [ADMIN] replication using WAL archives

2004-10-22 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Riggs wrote: |>Gaetano Mendola wrote |>Postgres can help this process, as suggested by Tom creating a | | pg_current_wal() | |>or even better having two new GUC parameters: archive_current_wal_command | | and | |>archive_current_wal_delay. | | | O

Re: [ADMIN] replication using WAL archives

2004-10-22 Thread Simon Riggs
> Gaetano Mendola wrote > Postgres can help this process, as suggested by Tom creating a pg_current_wal() > or even better having two new GUC parameters: archive_current_wal_command and > archive_current_wal_delay. OK, we can modify the archiver to do this as well as the archive-when-full function

Re: [ADMIN] replication using WAL archives

2004-10-21 Thread Iain
ptions and keep an eye on it's progress. regards Iain - Original Message - From: "Gaetano Mendola" <[EMAIL PROTECTED]> To: "Robert Treat" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, October 22, 2004

Re: [ADMIN] replication using WAL archives

2004-10-21 Thread Gaetano Mendola
Robert Treat wrote: On Thu, 2004-10-21 at 02:44, Iain wrote: Hi, I thought I read something about this in relation to v8, but I can't find any reference to it now... is it (or will it be) possible to do master-slave style database replication by transmitting log files to the standby server and havi

Re: [ADMIN] replication using WAL archives

2004-10-21 Thread Robert Treat
On Thu, 2004-10-21 at 02:44, Iain wrote: > Hi, > > I thought I read something about this in relation to v8, but I can't > find any reference to it now... is it (or will it be) possible to do > master-slave style database replication by transmitting log files to the > standby server and having it

[ADMIN] replication using WAL archives

2004-10-20 Thread Iain
(B (B (BHi, (B  (BI thought I read something about this in (Brelation to v8, but I can't find any reference to it now... is it (or will it (Bbe) possible to do master-slave style database replication by transmitting log (Bfiles to the standby server and having it process them? (B  (BA