[ADMIN] missing history file

2007-06-29 Thread George Wilk
My warm standby server is looking for a history file when booting up. It is looking for 0001.history file to be exact. Since my *live* server doesn't produce such file, I create an empty 0001.history file in the archive directory and that seems to satisfy this requirement allowing the

Re: [ADMIN] missing history file

2007-06-29 Thread Simon Riggs
On Fri, 2007-06-29 at 07:55 -0400, George Wilk wrote: My warm standby server is looking for a history file when booting up. It is looking for 0001.history file to be exact. Just ignore 0001. Recovery will work fine even if absent. Don't ignore all history files though, just that one.

[ADMIN] Linking libraries problem after Postgres-8.2.0 install

2007-06-29 Thread Radhika Sambamurti
Hi, I was running postgres-7.4.2 and upgraded to 8.2.0 Postgres-8.2.0 built successfully. But when I do an ldd on postgres I see that it is linking to the wrong openssl and crypto libraries. engpc17 bin]# ldd postgres libssl.so.4 = /lib/libssl.so.4 (0x0091e000) libcrypto.so.4 =

Re: [ADMIN] missing history file

2007-06-29 Thread Simon Riggs
On Fri, 2007-06-29 at 09:57 -0400, George Wilk wrote: Thanks, Simon. I will ignore the request for the history file in my recovery_command from now on. Is the timeline history file needed when trying to put the standby server back into the recovery mode, after it assumed the primary role?

Re: [ADMIN] missing history file

2007-06-29 Thread George Wilk
Thanks, Simon. I will ignore the request for the history file in my recovery_command from now on. Is the timeline history file needed when trying to put the standby server back into the recovery mode, after it assumed the primary role? (i.e. standby server goes *live*, and is subsequently

Re: [ADMIN] missing history file

2007-06-29 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: Just ignore 0001. Recovery will work fine even if absent. Don't ignore all history files though, just that one. Hmmm, come to think of it, why is it requesting it at all? We should just skip that request. No, because then people would misdesign their

Re: [ADMIN] missing history file

2007-06-29 Thread George Wilk
Tom, When and by what process is the history file being created? My standby server seems to be looking for it when put back in the recovery mode, after functioning as primary for a while. How should I handle missing history file in my script? Cheers, ~george -Original Message- From:

Re: [ADMIN] missing history file

2007-06-29 Thread Tom Lane
George Wilk [EMAIL PROTECTED] writes: When and by what process is the history file being created? My standby server seems to be looking for it when put back in the recovery mode, after functioning as primary for a while. How should I handle missing history file in my script? History files

Re: [ADMIN] i need a rad/ide open source for work with postgresql

2007-06-29 Thread Adam Rad?owski
Look at: http://zeoslib.sourceforge.net/ Adam P.S. And remember, that You can use libpq.DLL too - the fastest way to work with PostgreSQL. Mario Jose Canto Barea pisze: why are you can make a good database relational server as postgresql 8.1, and dont make a rad/ide open source for