Re: Online base backup from the hot-standby

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Online base backup from the hot-standby
Дата
Msg-id 4EA5832C.9070607@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Online base backup from the hot-standby  (Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>)
Ответы Re: Online base backup from the hot-standby
Список pgsql-hackers
On 24.10.2011 15:29, Fujii Masao wrote:
> +    <listitem>
> +     <para>
> +      Copy the pg_control file from the cluster directory to the global
> +      sub-directory of the backup. For example:
> + <programlisting>
> + cp $PGDATA/global/pg_control /mnt/server/backupdir/global
> + </programlisting>
> +     </para>
> +    </listitem>

Why is this step required? The control file is overwritten by 
information from the backup_label anyway, no?

> +    <listitem>
> +     <para>
> +      Again connect to the database as a superuser, and execute
> +      <function>pg_stop_backup</>. This terminates the backup mode, but does not
> +      perform a switch to the next WAL segment, create a backup history file and
> +      wait for all required WAL segments to be archived,
> +      unlike that during normal processing.
> +     </para>
> +    </listitem>

How do you ensure that all the required WAL segments have been archived, 
then?

> +   </orderedlist>
> +    </para>
> +
> +    <para>
> +     You cannot use the <application>pg_basebackup</> tool to take the backup
> +     from the standby.
> +    </para>

Why not? We have cascading replication now.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [PATCH] Use new oom_score_adj without a new compile-time constant
Следующее
От: Robert Haas
Дата:
Сообщение: Re: termination of backend waiting for sync rep generates a junk log message