Simon Riggs wrote:
On Sat, 2008-02-09 at 07:49 -0500, Chander Ganesan wrote:
Signalling components could be added to pg_standby at some point...
What sort of thing are you looking for?
pg_standby accepts a trigger file as well as various types of signal
I didn't see anything about si
On Sat, 2008-02-09 at 07:49 -0500, Chander Ganesan wrote:
> Signalling components could be added to pg_standby at some point...
What sort of thing are you looking for?
pg_standby accepts a trigger file as well as various types of signal.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.c
Hi Roberto,
-a "WAL segment file" is the same that a "log file segment"?
A WAL (Write Ahead Log) file is one of the numbered files in the pg_xlog
directory. Keep in mind that you'll be archiving (in some cases) more
than just WAL files, for example you might see other files appear in
you
On Feb 9, 2008 5:50 AM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Fri, 8 Feb 2008, David Wall wrote:
>
> > Does pg_standby take care of this by checking file sizes or the like? In my
> > testing with scp, we never experienced any problems, but I wonder if we were
> > somehow "just lucky."
>
> pg_
On Fri, 8 Feb 2008, David Wall wrote:
Does pg_standby take care of this by checking file sizes or the like? In my
testing with scp, we never experienced any problems, but I wonder if we were
somehow "just lucky."
pg_standby only processes files of exactly the length they're supposed to
be.
On Sat, 9 Feb 2008, Roberto Scattini wrote:
-a "WAL segment file" is the same that a "log file segment"?
Yes: WAL="write-ahead log".
-how often a new WAL file is generated? this depends on the server load?
These are the WAL segment files that are produced by the database, the
ones you're
That's correct. You have to do it that way or the system in recovery
mode can start to consume the new segment file before it has been
completely copied over yet.
Does pg_standby take care of this by checking file sizes or the like?
In my testing with scp, we never experienced any problems
On Fri, 8 Feb 2008, David Wall wrote:
Is 'scp' by itself considered an "atomic tool" for copying files to the
standby server? Does "atomic" mean that the program should copy a file over
using a temp file name and then renames at the end or does it mean something
else?
That's correct. You h
2) if archive_command is activated and working, the primary
server sends (preferably with rsync or some other "atomic tool") the
NEW WAL files to the standby server. Later, at some point, the primary
server will delete this files when considers that are not necessary
anymore.
Is 'scp'
hi list:
im working in the setup of a warm standby server. im using
postgres-8.2.5 in the slave and 8.2.4 in master right now, in
production it will be only 8.2.5, everything in debian etch.
we decided this solution because we want an easy to
migrate/implement/adminstrate backup sever, and we have
10 matches
Mail list logo
