Re: Wal Segment files Backup Strategy for archiving

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Frederiko Costa" <frederiko(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Wal Segment files Backup Strategy for archiving
Date: 2010-04-15 22:41:07
Message-ID: 4BC74FB30200002500030999@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Frederiko Costa <frederiko(at)gmail(dot)com> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Samuel Stearns 2010-04-16 01:33:11 FW: More than 1 pg_database Entry for Database - Thread #2
Previous Message Frederiko Costa 2010-04-15 21:33:12 Wal Segment files Backup Strategy for archiving