Postgres

From Wikitech
(Redirected from PostgreSQL)
Jump to navigation Jump to search

Monitoring

Syncing postures slave after reimage

After a postgres slave server has been re-imaged it will first need to sync all data before it can be placed in production. To do this one needs to run the following command

$ PGPASSWORD=${replication_pass} /usr/bin/pg_basebackup -X stream -D ${data_dir} -h ${master_server} -U replication -w

POSTGRES_HOT_STANDBY_DELAY

This alert indicates that a replica has fallen behind the master database in replication. This is not immediately a cause for panic, as a host can recover assuming it is not left out of replication for long. However, the postgres logs should be examined and connectivity between individual replicas and the master should also be checked.

If many or all hosts in the maps cluster are issuing this alert, it could be the case that the OSM dataset is being refreshed - during this operation it is likely that hosts will fall behind as large numbers of changes happen on the master during import. Check the cluster masters for import processes - generally this is a passing problem and will self-resolve over time. Avoid restarting postgres hosts while the osm-replicate or osmosis processes are running on the master.

Related pages