Re: [GENERAL] Postgresql data integrity during RAID10 drive rebuild

2006-11-29 Thread Steve Poe
ay backplane. Scott, Joshua, and Vivek...thanks for your feedback. Steve Poe Adobe Animal Hospital

[GENERAL] Postgresql data integrity during RAID10 drive rebuild

2006-11-29 Thread Steve Poe
e had to rebuild one of their disc in an array of their database? Thanks for your help. Steve Poe

Re: [GENERAL] Fast backup/restore

2006-10-17 Thread Steve Poe
Vivek,What methods of backup do you recommend for medium to large databases? In our example, we have a 20GB database and it takes 2 hrs to load from a pg_dump file.Thanks.Steve Poe On 10/17/06, Vivek Khera <[EMAIL PROTECTED]> wrote: On Oct 17, 2006, at 10:43 AM, [EMAIL PROTECTED] wrote: We just ta

Re: [GENERAL] Deathly slow performance on SMP red-hat system

2006-08-29 Thread Steve Poe
Patrick,Have you modified your postgresql.conf file or is this default out-of-the-box too? Are the database and database logs (pg_xlog) on shared disc space?SteveOn 8/28/06, Patrick TJ McPhee <[EMAIL PROTECTED]> wrote: I have a Red Hat ELsmp system running on a dual opteron hp server with16 gigs o

Re: [GENERAL] Restoring database from old DATA folder

2006-08-08 Thread Steve Poe
I tried to modify the parameters of the .CONF file when the pgsql-8.1service was running. The next time I started, it displayed error: "The service did not listen to local host". (something like this).If you were to do a"su - postgresĀ  -c "pg_ctl -D start" what error information does it show? Stev