Wal Segment files Backup Strategy for archiving

Wal Segment files Backup Strategy for archiving

am 15.04.2010 23:33:12 von Frederiko Costa

--001636c933da0ed01004844d3ff8
Content-Type: text/plain; charset=UTF-8

Hello folks,

I wanted to use the archiving feature, with log shipping / warm-standby
server. No problem on setting up so far. However, reading the documentation
brought me one question that I'd like to share with the list.

In the documentation, as far as I understood, it's said you need to make a
base backup and copy the data cluster area to the destination you choose.
Use pg_start_backup(), copy the data/ directory (or the cluster area), and
pg_stop_backup(). It created the first checkpoint (correct?) and copied the
wal segments to the area you specified. You can even delete the files under
pg_xlog, because you will rely on the ones shipped out. The question is:
once the base backup has been made and I change any setting on this primary
server, on postgresql.conf for example, would I have to redo the procedure
and set Pgsql to backup mode if I want to apply these changes I made updated
on standby server or it's just a matter of transferring the file to the
standby server?

Thanks,
Frederiko Costa

--001636c933da0ed01004844d3ff8
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello folks,

I wanted to use the archiving feature, with log shippin=
g / warm-standby server. No problem on setting up so far. However, reading =
the documentation brought me one question that I'd like to share with t=
he list.



In the documentation, as far as I understood, it's said you need to=
make a base backup and copy the data cluster area to the destination you c=
hoose. Use pg_start_backup(), copy the data/ directory (or the cluster area=
), and pg_stop_backup(). It created the first checkpoint (correct?) and cop=
ied the wal segments to the area you specified. You can even delete the fil=
es under pg_xlog, because you will rely on the ones shipped out. The questi=
on is: once the base backup has been made and I change any setting on this =
primary server, on postgresql.conf for example, would I have to redo the pr=
ocedure and set Pgsql to backup mode if I want to apply these changes I mad=
e updated on standby server or it's just a matter of transferring the f=
ile to the standby server?



Thanks,
Frederiko Costa



--001636c933da0ed01004844d3ff8--

Re: Wal Segment files Backup Strategy for archiving

am 16.04.2010 00:41:07 von Kevin Grittner

Frederiko Costa wrote:

> Use pg_start_backup(), copy the data/ directory (or the cluster
> area), and pg_stop_backup(). It created the first checkpoint
> (correct?)

Yes.

> once the base backup has been made and I change any setting on
> this primary server, on postgresql.conf for example, would I have
> to redo the procedure and set Pgsql to backup mode if I want to
> apply these changes I made updated on standby server or it's just
> a matter of transferring the file to the standby server?

You can transfer the .conf files, but be careful about the archive
settings; you may not want those to be identical on the standby.
Also pay attention to memory settings, etc., if the hardware isn't
identical. Of course, this is the same with setting it up after
you copy a base backup.

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin