Re: Master - slave replication?

On Wed, 26 Oct 2016 13:59:02 +0200
Thomas Kellerer <spam_eater@gmx.net> wrote:

> Bjørn T Johansen schrieb am 26.10.2016 um 13:17:
> > I have a database that I would like to replicate in case of hardware failure on this server. So I gather I just
needa streaming replication (warm 
> > standby?) and I found a howto describing how to set it up, that looks like this:
> >
> > 1. Edit postgresql.conf on the master to turn on streaming replication. Change these settings:
> >  listen_addresses = '*'
> >  wal_level = hot_standby
> >  max_wal_senders = 3
> > 2. Edit pg_hba.conf on the master in order to let the standby connect.
> >  host  replication   all   192.168.0.2/32      trust
> > 3. Edit postgresql.conf on the standby to set up hot standby. Change this line:
> >  hot_standby = on
> > 4. Create or edit recovery.conf on the standby to set up replication and standby mode. Save a file in the standby's
datadirectory, called recovery.conf, with the following lines: 
> >  standby_mode = 'on'
> >  primary_conninfo = 'host=192.168.0.1'
> > 5. Shut down both the master and standby, and copy the files. You want to copy most but not all files between the
twoservers, excluding the configuration files and the pg_xlog directory. An example rsync script would be: 
> >  rsync -av --exclude pg_xlog --exclude postgresql.conf data/* 192.168.0.2:/var/lib/postgresql/data/
> > 6. Start the standby first, so that they can't get out of sync. (Messages will be logged about not being able to
connectto the primary server, that's OK.) 
> > 7. Start the master.
> >
> > Is this all that is needed to get a working master - slave replication? (It just looks too easy... :) )
>
> Yes, that's all.
>
> In fact 5. could be done withoug shutting down the master using pg_basebackup
>
> > Do I need to enable archive mode for this to work or?
>
> No.
>
> "wal_level = hot_standby" includes that.
>
>
>


Ok, thx.. :)

BTJ