Skip site navigation (1) Skip section navigation (2)

Re: pg_standby doesnt't work

From: Andreas Schmidt <a(dot)schmidt(at)mdtec(dot)de>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_standby doesnt't work
Date: 2009-10-27 07:53:00
Message-ID: 158182AF0720CA4FBB0E7DC47600D5A81F397CA1@winxbede14.exchange.xchg (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Hi, thank you for your response.
But does this mean, that only WinXP is no supported or doesn't it work at all? I would need it on a Windows2003Server???

Best regards,

murphy


-----Ursprüngliche Nachricht-----
Von: Fujii Masao [mailto:masao(dot)fujii(at)gmail(dot)com] 
Gesendet: Montag, 26. Oktober 2009 03:36
An: Andreas Schmidt
Cc: pgsql-admin(at)postgresql(dot)org; PostgreSQL-development
Betreff: Re: [ADMIN] pg_standby doesnt't work

Hi,

On Mon, Oct 26, 2009 at 12:34 AM, Andreas Schmidt <a(dot)schmidt(at)mdtec(dot)de> wrote:
> I'm testing serveral days a replication-system with PostgreSQL, but I get
> allways the same error.
>
> 2009-10-25 15:44:45 CET FATAL:  XX000: could not restore file
> "00000001.history" from archive: return code -1073741811
>
> The restore_command is:
>
> restore_command = 'pg_standby.exe -d -s 5 -t C:\pgsql.trigger.5442
> w:\wal-archive %f %p %r 2>>pg_log\pg_standby.log'
>
> The system is runnig on WinXP (during this test), the database-version is
> 8.3.8. I've tried out the pg_standby-version from PG8.4, but there is no
> difference in the result.
>
> So I can't understand what this return-code means, (and) I've never seen a
> file named 00000001.history. It definitely doesn't exist on my master and so
> my archive_command can't replicate to the slave.

This is the same problem that was reported before.
http://archives.postgresql.org/pgsql-bugs/2009-08/msg00003.php

The cause is the signals support for pg_standby on win32.
We should get rid of that.

Regards,

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

In response to

Responses

pgsql-hackers by date

Next:From: Dimitri FontaineDate: 2009-10-27 09:11:48
Subject: Re: Parsing config files in a directory
Previous:From: Peter EisentrautDate: 2009-10-27 07:21:13
Subject: Re: Parsing config files in a directory

pgsql-admin by date

Next:From: TiTo®Date: 2009-10-27 10:50:54
Subject: Re: Permissions to schema
Previous:From: Anj AduDate: 2009-10-26 23:35:35
Subject: Re: pg_attribute size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group