Обсуждение: scheduled switchover
Hi,
I use potgresSQL 8.5 with replication. The primary host and slave host are not in the same place. The bandwidth between master/host is to 10MB. We need to schedule a switchover and I found a solution to use the minimun of bandwith to rebuild the database slave
I want to know if somebody use similar procedure?
Step 1:
Stop host01 (master)
Stop host01 (master)
Step 2:
Stop host02 (slave) and start it with master configuration.
Step 3:
build replication on host01 (old_master)
Step 4:
Allow connexion on host02 (INSERT, DELETE, SELECT...)
Step 5:
Stop host02 (master)
Step 6:
Stop host01 (slave) and start it with master configuration.
Stop host02 (slave) and start it with master configuration.
Step 3:
build replication on host01 (old_master)
Step 4:
Allow connexion on host02 (INSERT, DELETE, SELECT...)
Step 5:
Stop host02 (master)
Step 6:
Stop host01 (slave) and start it with master configuration.
Step 7:
Build slave on host02 (old_master)
Build slave on host02 (old_master)
Step 8:
Allow connexion on host01 (master)
END.
Allow connexion on host01 (master)
END.
I my case when i build slave host (step 3 and step 4), I use this following command:
rsync -av --rsh=ssh --compress --verbose --progress --exclude base --exclude pg_xlog --exclude pg_log --exclude postgresql.conf --exclude pg_hba.conf --exclude postmaster.pid * IP:/home/PGDDATA
I have add "--excluse base" on rsync.
If it's work it's only for the switchover, not when the master host crash.
Regards,
François
Greetings!
I am putting together a formal installation package for a customer who is not happy if he doesn’t have one, even though he’s got primary and backup servers both running as expected.
I am writing instructions on how to install PGAgent. The download package for PGAgent includes two SQL files, pgagent.sql and pgagent_upgrade.sql. But the only instructions I found online on how to install PGAgent only mention the first. Is pgagent_upgrade.sql required? If so, when do I run it? I presume that it should be run after pgagent.sql, but without instructions, I’m not positive.
Thank you.
RobR