[GENERAL] pg_basebackup from new master's slave then recovery from new master.

All on 9.3beta2. Current setup: server1 (MASTER) -> server2 (SLAVE) -> server3 (SLAVE) server2 is hot_standby and gets WALs from server1 server3 is hot_standby and gets WALs from server2 In every recovery.conf I have: recovery_target_timeline='latest' Now i do switchover by touching recovery.c

Re: [GENERAL] pg_basebackup from new master's slave then recovery from new master.

2013/8/17 Piotr Gasidło : > All on 9.3beta2. Current setup: > (...) Ehh, typo. > 2. I edit recovery.conf on server2 to NOT point to server2 (NEW > MASTER) but server3 (OLD MASTER) and restart server3 Should be: 2. I edit recovery.conf on server3 to NOT point to server2 (NEW > MASTER) but server

Re: [GENERAL] Commit problem in read-commited isolation level

On 08/16/2013 10:38 PM, S H wrote: > 1) What is your exact Postgres version i.e 8.1.5.? V - 8.1.18 > 3) You also say it works fine in two environments, but not one. > > What are the environments? > OS and version, memory, Postgres versions, etc. It is working on most of the production syst

[GENERAL] postmaster.pid still exists after pacemaker stopped postgresql - how to remove

Hi all. I'm running 2 node pacemaker/pgsql cluster in one technical center TC1 and the second 2 node pacemaker/pgsql cluster in the TC2. After the streaming replication has been established between TC1 (master) and TC2 (slave) I've tried to migrate resources within TC1 from node 1 to node 2. Pac

[GENERAL] Postgres cron job

Is there a way to do a Postgres internal cron job? That is, do something every X minutes? Yes: Of course I can do this using cron. But I'd like to be able to manage this from within Postgres. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

[GENERAL] Denormalized field

I have a slow_function. My table has field f, and since slow_function is slow, I need to denormalize and store slow_function(f) as a field. What's the best way to do this automatically? Can this be done with triggers? (On UPDATE or INSERT, SET slow_function_f = slow_function(new_f) ) How? Will c

Re: [GENERAL] Postgres cron job

On 8/17/2013 8:55 PM, Robert James wrote: Is there a way to do a Postgres internal cron job? That is, do something every X minutes? Yes: Of course I can do this using cron. But I'd like to be able to manage this from within Postgres. http://www.pgadmin.org/docs/1.4/pgagent.html -- john r pi