[ADMIN] Re: corrupted indexes when using base backups generated from hot standby

2013-01-29 Thread Heikki Linnakangas
On 29.01.2013 18:36, Lonni J Friedman wrote: On Tue, Jan 29, 2013 at 8:32 AM, Heikki Linnakangas wrote: Thanks. I'm afraid I didn't get any wiser from the log output. Since this is a test system, could you reduce the test case into something smaller and self-contained? Sorry, I don't underst

[ADMIN] Re: corrupted indexes when using base backups generated from hot standby

2013-01-29 Thread Heikki Linnakangas
On 26.01.2013 01:28, Lonni J Friedman wrote: On Tue, Jan 15, 2013 at 2:57 AM, Heikki Linnakangas wrote: That process sounds correct. Since you're using pg_basebackup -x option, you don't even need to copy the WAL logs, although it shouldn't do any harm either . The tar file should contain ever

[ADMIN] Re: corrupted indexes when using base backups generated from hot standby

2013-01-15 Thread Heikki Linnakangas
On 09.01.2013 20:28, Lonni J Friedman wrote: Greetings, I'm running postgres-9.2.2 in a Linux-x86_64 cluster with 1 master and several hot standby servers. Since upgrading to 9.2.2 from 9.1.x a few months ago, I switched from generating a base backup on the master, to generating it on a dedicate