On Fri, 2007-10-12 at 19:59 +0100, Richard Huxton wrote:
> You could use WAL archiving, but you'll want a fairly regular
> full-backup of PG's files otherwise the recovery could take a long time.
> See Ch 23 of the manuals for details.
Restartable recovery avoids the need to re-sync from the pr
On Fri, 2007-10-12 at 14:09 -0500, Erik Jones wrote:
> On Oct 12, 2007, at 1:59 PM, Richard Huxton wrote:
>
> > Joao Miguel Ferrei
> Are you restricted to keep that second server in that special run-
> level? If not, I'd consider using pg_standby with WAL archiving to
> keep your failover serv
Hello,
I have a 'strange' situation:
I need to make a replica copy of my database to a reduntant spare
computer.
The reduntant computer is not running postgres, but postgres is
installed. The redundant computer is running in a special run-level (I'm
talking Linux here) in which Pg is _not_ runni
On Oct 12, 2007, at 1:59 PM, Richard Huxton wrote:
Joao Miguel Ferreira wrote:
Hello,
I have a 'strange' situation:
I need to make a replica copy of my database to a
reduntant
spare
computer.
The reduntant computer is not runnin
Joao Miguel Ferreira wrote:
Hello,
I have a 'strange' situation:
I need to make a replica copy of my database to a reduntant
spare
computer.
The reduntant computer is not running postgres, but postgres is
installed. The
Hello,
I have a 'strange' situation:
I need to make a replica copy of my database to a reduntant
spare
computer.
The reduntant computer is not running postgres, but postgres is
installed. The redundant computer is running in
