Kevin Grittner wrote:
> Bruce Momjian wrote:
>
> > One odd thing is we have two paramters that mention hot_standby
> > --- on the master we have to do in postgresql.conf:
> >
> > wal_level = hot_standby
> >
> > and on the slave we do in postgresql.conf:
> >
> > hot_standby = on
> >
>
Bruce Momjian wrote:
> One odd thing is we have two paramters that mention hot_standby
> --- on the master we have to do in postgresql.conf:
>
> wal_level = hot_standby
>
> and on the slave we do in postgresql.conf:
>
> hot_standby = on
>
> That is a little confusing.
Why? I r
bruce wrote:
> > and my slave recovery.conf was:
> >
> > restore_command = 'cp /u/pg/archive/%f %p' # e.g. 'cp
> > /mnt/server/archivedir/%f %p'
> > standby_mode = 'on'
> > primary_conninfo = 'host=localhost port=5432' # e.g.
> > 'host=localhost port=5432'
> >
