Re: Basic Question on Point In Time Recovery

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Basic Question on Point In Time Recovery
Date: 2015-03-12 12:31:41
Message-ID: mds0ve$nso$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Robert Inder schrieb am 12.03.2015 um 12:52:
> Postgres on the standby machine is continually reading those files.
> But that is all it will do. "pg_dump" just says "The database is starting up".
>
> Could/should I have something configured differently?
>
> Or Is this something that has changed with Postgres 9?
> We're currently running Postgres 8.4.
> Is this my specific reason to embark on an upgrade?

8.4 cannot run queries on the standby, you need to upgrade to a supported/maintained version for this
(this feature was introduced in 9.0)

In 9.x you can start the slave as a "hot standby" to allow read only queries which is what pg_dump needs.

You should really upgrade to a current version 9.4 or 9.3

Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2015-03-12 13:15:48 Re: Benchmarking partitioning triggers and rules
Previous Message Robert Inder 2015-03-12 11:52:16 Re: Basic Question on Point In Time Recovery