Re: Hot standby server does not start

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Michal Glowacki <mg(dot)scandic(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Hot standby server does not start
Date: 2010-09-29 08:06:53
Message-ID: AANLkTim8eZ3nMPN3_1Au1pb32Rfv6v2NtifmCu0OCf6u@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Sep 29, 2010 at 4:52 PM, Michal Glowacki <mg(dot)scandic(at)gmail(dot)com>wrote:

>
> I try to do it on two machines, my computer and local server. My system is
> Windows 7 64bit, standby is XP professional sp2 64bit. Both machines run
> postgres 9.0.0. I tried dump, dump_all, pgadmin III's backup and restore -
> nothing works.
>

Instead of pg_dump, you need to take a base backup by using pg_start_backup
and pg_stop_backup, and load it in the standby.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michal Glowacki 2010-09-29 08:16:45 Re: Hot standby server does not start
Previous Message Michal Glowacki 2010-09-29 07:52:05 Hot standby server does not start