Re: [GENERAL] restore_command %r option

2008-03-17 Thread Steven Flatt
much appreciated. Steve On Mon, Mar 10, 2008 at 12:23 PM, Steven Flatt <[EMAIL PROTECTED]> wrote: > Well, after some testing, it appears as though the %r option is not > supported on 8.2.4. > > It also looks as though pg_controldata may have the answer I want, but > what is th

Re: [GENERAL] restore_command %r option

2008-03-10 Thread Steven Flatt
:32 AM, Steven Flatt <[EMAIL PROTECTED]> wrote: > Is the %r option of the restore_command available in PG 8.2.4? If not, is > there any other way to know how many archive files need to be kept on the > standby server when in recovery mode? > > Thanks, > Steve >

[GENERAL] restore_command %r option

2008-03-10 Thread Steven Flatt
Is the %r option of the restore_command available in PG 8.2.4? If not, is there any other way to know how many archive files need to be kept on the standby server when in recovery mode? Thanks, Steve

[GENERAL] Upgrading a 32-bit build to a 64-bit build

2007-04-20 Thread Steven Flatt
I can't seem to find an answer to this. If I upgrade a 32-bit Postgres build to a 64-bit Postgres build (same version), will the data files be compatible or do I have to do a dump and restore of the database? Is the answer the same for 8.1 and 8.2? Steve