Re: [ADMIN] Upgrade in same major version

2008-10-16 Thread Tim Bruce - Postgres
On Thu, October 16, 2008 06:47, Carol Walter wrote: > Let me see if I understand this correctly. > Always do a backup before doing any destructive sys admin functions. =) > First, I run configure, taking care to make sure all the options point > to the right places. > Second, I run gmake > Third,

Re: [ADMIN] Upgrade in same major version

2008-10-16 Thread Carol Walter
Let me see if I understand this correctly. Always do a backup before doing any destructive sys admin functions. =) First, I run configure, taking care to make sure all the options point to the right places. Second, I run gmake Third, I run gmake install. Thanks, Carol On Oct 14, 2008, at 1:2

[ADMIN] pg_standby and continuous recovery

2008-10-16 Thread Ibrahim Harrani
Hello, I am using pg_standby with PostgreSQL 8.2.4. I configured master and standby server according to the articles at http://michsan.blogspot.com/2008/08/using-pgstandby-for-high-availability.html and http://www.postgresql.org/docs/8.3/static/pgstandby.html. my recovery.conf file is like follow

Re: [ADMIN] replication with table add/removes..

2008-10-16 Thread Martin Badie
How can I make them constantly create restore points? Once I create recover.conf it creates recover.done but what about those new queries that comes after that? Do I have to re-create recover.conf? Or how do I achive constant logging to slaves? This issue is not clear in the documentation htt