Re: Hot standby server does not start

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):
>>
>> ************************
>>
>> 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 pg_start_backup('label');
>>
>> where label is any string you want to use to uniquely identify
>> this backup operation. (One good practice is to use the full path
>> where you intend to put the backup dump file.) |pg_start_backup|
>> creates a /backup label/ file, called backup_label, in the cluster
>> directory with information about your backup.
>>
>> It does not matter which database within the cluster you connect
>> to to issue this command. You can ignore the result returned by
>> the function; but if it reports an error, deal with that before
>> proceeding.
>>
>> 3.
>>
>> Perform the backup, using any convenient file-system-backup tool
>> such as tar or cpio. It is neither necessary nor desirable to stop
>> normal operation of the database while you do this.
>>
>> 4.
>>
>> Again connect to the database as a superuser, and issue the command
>>
>> SELECT pg_stop_backup();
>>
>> This should return successfully.
>>
>> 5.
>>
>> Once the WAL segment files used during the backup are archived as
>> part of normal database activity, you are done.
>>
>>
>> **********************************
>>
>> BUT I have some questions:
>>
>> 1. I connect to database using psql and issue command SELECT
>> pg_start_backup('my_backup'); The result (in less than second) is:
>>
>> pg_start_backup
>> -----------------
>> 4/DA000020
>> (1 row)
>>
>> Is it correct it goes that fast?
>>
> Yes.
>
>> 2. Now I proceed to step 3 - perform the backup using file system
>> backup. Could you assist me on this one? I should archive what?The
>> '/data' folder (please note I use Windows)? Should I just compress it
>> into rar file and transfer to standby server and overwrite it's '/data'
>> folder?
>>
> 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 your rar archive.
>
> BTW, pgAdmin backup and restore facilities use pg_dump/pg_restore. So
> it's not really surprising that you get the same results :)
>
>