Quentin Hartman <qhartman@xxxxxxxxxxxxxxxxxxx> writes: > Yesterday morning, one of my streaming replication slaves running 9.2.3 > crashed with the following in the log file: What process did you use for setting up the slave? There's a fix awaiting release in 9.2.4 that might explain data corruption on a slave, depending on how it was set up: * Ensure we do crash recovery before entering archive recovery, if the database was not stopped cleanly and a recovery.conf file is present (Heikki Linnakangas, Kyotaro Horiguchi, Mitsumasa Kondo) This is needed to ensure that the database is consistent in certain scenarios, such as initializing a standby server with a filesystem snapshot from a running server. This theory would be more probable if it's a relatively new slave, since any corruption would have been there in the slave's initial state, just waiting for the replay to run into it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
