From: Jerry Sievers <gsievers19@comcast.net>
To: Tomas Ramanauskas <Tomas.Ramanauskas@springer.com>
Cc: pgsql-admin\@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Cloning PostgreSQL 8.3.7
Date: Wed, 16 Jul 2014 16:07:02 -0500
Message-ID: <86wqbdrp1l.fsf@jerry.enova.com> (raw)
In-Reply-To: <942E714F114739429A83333F735F7A85195CDA36@senldogo0752.springer-sbm.com>
References: <942E714F114739429A83333F735F7A85195CDA36@senldogo0752.springer-sbm.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Tomas Ramanauskas <Tomas.Ramanauskas@springer.com> writes:
> Hi, guys,
>
> Im new to PostgreSQL and Im currently involved in cloning PostgreSQL 8.3.7 to a different server (as a first step of migration to 9.3 version project).
>
> Im able to clone the db server and everything is working, but Im not entirely sure how manual application of WAL files works / is triggered.
>
> After DB is cloned, I want to apply all the changes since the database was cloned.
>
> I want to do it as a one-off operation, I dont want to create warm standby. I also want to verify and make sure that all WAL files got applied.
You are describing a hot-backup and point in time recovery which is
well documented in the standard Pg doc set.
You will replay all available WALs and your clone will come online at
that point.
<>
> Im not sure if PG applies all the WAL files it finds in pg_xlog or I need to run a specific command to do that?
>
> I just copied all the WAL files to pg_xlog and started PG, but there is nothing in the log files indicating that WAL files actually got applied.
>
> I also posted same question also here:
>
> https://stackoverflow.com/questions/24784042/cloning-postgresql-8-3-7
>
> Kind regards,
>
> Tomas
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, Tomas.Ramanauskas@springer.com
Subject: Re: Cloning PostgreSQL 8.3.7
In-Reply-To: <86wqbdrp1l.fsf@jerry.enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox