On Thu, 2008-10-30 at 16:17 -0400, Chander Ganesan wrote:
> Why? If you haven't saved a backup that you made previously (using
> pg_start_backup()), having archived wal files is useless. I don't see
> why you just don't arbitrarily remove them immediately.
>
> WAL files are useful when you ha
Jaume Sabater wrote:
Chander Ganesan wrote:
If you are running warm-standby, its presumable that your standby
server is "consuming" these files as they are being generated. In
such a case, you can set "log_restartpoints" in your recovery.conf
file, and use pg_standby with the '%r' (restartw
Chander Ganesan wrote:
> If you are running warm-standby, its presumable that your standby
> server is "consuming" these files as they are being generated. In
> such a case, you can set "log_restartpoints" in your recovery.conf
> file, and use pg_standby with the '%r' (restartwalfile) parameter s
Hi.
I have a problem with a standby server running on Windows 2003 R2,
Enterprise x64 edition. I use Postgres 8.3 (installed to C:\Program Files
(x86)\ )
Everything was working fine (base backup, archiving, recovery), until I
wanted to test failover.
To do that I create a trigger file, the recove
Jaume Sabater wrote:
Hello everyone!
I am trying to setup a warm standby cluster with pgpool-II and PostgreSQL 8.3
on Debian Etch (with backported packages), with replication and load balancing.
I have enabled WAL archiving in both PostgreSQL instances as required by
pgpool-II and configured
On Wed, Oct 29, 2008 at 10:53 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Peter Koczan" <[EMAIL PROTECTED]> writes:
>> On Wed, Oct 29, 2008 at 9:11 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>>> Right. So in the meantime, what Peter should do is try the problem case
>>> after
>>> export PGSSLMODE=requ
damien clochard wrote:
> Here's a poster of PostgreSQL 8.3 internal catalogs
> http://dalibo.org/_media/articles/catalog.png?cache=cache
>
> SVG version is available here :
> http://svn.postgresql.fr/repos/materials/advocacy/trunk/posters/catalogs83.svg
Thanks -- I've added this to the Developer
Hello everyone!
I am trying to setup a warm standby cluster with pgpool-II and PostgreSQL 8.3
on Debian Etch (with backported packages), with replication and load balancing.
I have enabled WAL archiving in both PostgreSQL instances as required by
pgpool-II and configured the online recovery wit
Isabella Ghiurea a écrit :
> Hello,
> How can I see all system catalog tables and views , I'm in potsgres db
> ( using PG 8.3).
> Is there a way to have /get a full list and description of system
> tables and views in kind of hard copy format, same as Oracle or
> RDBMS posters for system catalo
On Fri, 2008-10-17 at 15:09 -0500, Kevin Grittner wrote:
> In both cases it seemed to take longer to apply the WAL files during
> the recovery process than we're used to from 8.2 I don't have hard
> numbers, but before I spent time investigating I thought I would ask
> here if that is already a
10 matches
Mail list logo
