Re: [ADMIN] Hot standby server does not start

2010-10-01 Thread Michal Glowacki
hi, it's fine now - the problem was WinRAR which reported that he can't access some files and I ignored that - big mistake :) Thanks for help - working fine now. Michal Le 29/09/2010 10:16, Michal Glowacki a écrit : Fujii, I believe I should follow this (from documentation): ***

Re: [ADMIN] Hot standby server does not start

2010-09-29 Thread Michal Glowacki
W dniu 2010-09-29 10:56, Guillaume Lelarge pisze: Using rar on the data folder should work if you don't have tablespaces. If you have some, add them to your data rar archive. And instead of overwriting the data folder on the slave, wipe out your old data folder and recreate it by restoring you

Re: [ADMIN] Hot standby server does not start

2010-09-29 Thread Guillaume Lelarge
Le 29/09/2010 10:16, Michal Glowacki a écrit : > Fujii, I believe I should follow this (from documentation): > > > > The procedure for making a base backup is relatively simple: > > 1. > > Ensure that WAL archiving is enabled and working. > > 2. > > Con

Re: [ADMIN] Hot standby server does not start

2010-09-29 Thread Michal Glowacki
Fujii, I believe I should follow this (from documentation): The procedure for making a base backup is relatively simple: 1. Ensure that WAL archiving is enabled and working. 2. Connect to the database as a superuser, and issue the command SELECT

Re: [ADMIN] Hot standby server does not start

2010-09-29 Thread Fujii Masao
On Wed, Sep 29, 2010 at 4:52 PM, Michal Glowacki 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 w

[ADMIN] Hot standby server does not start

2010-09-29 Thread Michal Glowacki
hi, I wanted to take new feature of postgres 9 into action - hot standby. However for some days I am still struggling with starting hot standby server. I have set up everything as mentioned in Postgres Tutorial, on master and standby. All the time I get: 2010-09-27 15:56:22 CEST LOG: data