Thread: Re: [ADMIN] pg_standby doesnt't work
Hi, On Mon, Oct 26, 2009 at 12:34 AM, Andreas Schmidt <a.schmidt@mdtec.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
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.fujii@gmail.com] Gesendet: Montag, 26. Oktober 2009 03:36 An: Andreas Schmidt Cc: pgsql-admin@postgresql.org; PostgreSQL-development Betreff: Re: [ADMIN] pg_standby doesnt't work Hi, On Mon, Oct 26, 2009 at 12:34 AM, Andreas Schmidt <a.schmidt@mdtec.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
Hi, On Tue, Oct 27, 2009 at 4:53 PM, Andreas Schmidt <a.schmidt@mdtec.de> wrote: > 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??? According to the previous post, pg_standby in v8.3.7 would work file. How about using that? http://archives.postgresql.org/pgsql-bugs/2009-08/msg00094.php Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
Hi, On Tue, Oct 27, 2009 at 4:53 PM, Andreas Schmidt <a.schmidt@mdtec.de> wrote: > 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??? This problem will disappear in the next release (v8.3.9, v8.4.2). http://archives.postgresql.org/pgsql-committers/2009-11/msg00019.php Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center