Обсуждение: scheduled switchover

Поиск
Список
Период
Сортировка

scheduled switchover

От
francois pascual
Дата:
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)
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.
Step 7:
  Build slave on host02 (old_master)
Step 8:
   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
 
 
 
 
 

Do I need to run pgagent_upgrade.sql? If so, when?

От
"Rob Richardson"
Дата:

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