Re: [GENERAL] broke postgres, how to fix??

2013-03-01 Thread Michael Best
On 03/01/2013 02:31 AM, Albe Laurenz wrote: > JD Wong wrote: Hi Adrian, yes I completely copied the config-file and data directories over. > >>> That's guaranteed to break everything badly. > >> Even if I "read only style" copied the files? Do you mind elaborating on why >> this ha

[GENERAL] 9.0 Streaming Replication Problem to two slaves

2011-07-25 Thread Michael Best
I have a master server and two slave servers, one in the same rack and one in another data center that has a normal latency of about 15ms. Both master and slaves are running CentOS 5.6 x86_64 with: postgresql90-server-9.0.4-1PGDG.rhel5.x86_64 from http://yum.pgrpms.org The master server is usin

Re: [GENERAL] 9.0 Streaming Replication Problem to two slaves

2011-08-02 Thread Michael Best
On 07/25/2011 11:38 AM, Michael Best wrote: I have the servers configured, and get the replication up and running, and then it will run for the better part of a day, and then the slaves appear to stop receiving or requesting updates, there doesn't appear to be anything in the logs other

[GENERAL] Database Corruption - last chance recovery options?

2007-01-04 Thread Michael Best
Had some database corruption problems today. Since they came on the heels of making some minor database changes yesterday, they may or may not be related to that. Centos 4.x, Postgresql 8.1.4 I modified the following settings and then issued a reload.I hadn't turned up the kernel.shmmax

Re: [GENERAL] Database Corruption - last chance recovery options?

2007-01-05 Thread Michael Best
Thomas F. O'Connell wrote: On Jan 4, 2007, at 11:24 PM, Michael Best wrote: When I finally got the error report in the morning the database was in this state: $ psql dbname dbname=# \dt ERROR: cache lookup failed for relation 20884 Do you have your error logs, and were ther