Re: [ADMIN] Reg - Statistics - Postgres 8.3

2012-11-30 Thread Albe Laurenz
Hariraman Jayaraj wrote: We are using Postgres 8.3 version, in Suse Linux Enterprise Edition SP1. Our DB total size is around 530 GB. we have enabled the setting related to default_statistics_target. Kindly suggest what will be ideal value for default_statistics_target. We have more than

Re: [ADMIN] Backup

2012-11-30 Thread Lonni J Friedman
I can generate a backup using pg_dump on a slave with 9.2.1. No clue if it works with 9.1.x (or older) versions though. On Thu, Nov 29, 2012 at 5:17 PM, Sabry Sadiq ssa...@whispir.com wrote: Pg_dump Sabry Sadiq Systems Administrator Whispir Level 30 360 Collins Street Melbourne /

Re: [ADMIN] base backup requirements for PITR

2012-11-30 Thread Gabriele Bartolini
Hi Andrew, Il 29/11/12 02:52, Andrew W. Gibbs ha scritto: That said, I'm wondering whether I created the base backup with reliably correct procedures or merely was lucky. PostgreSQL documentation on how continuous archiving works is clear, but you need to follow exactly what it says and have a