[HACKERS] Streaming Replication: sql error on standby
in [PgSql]
|
Prev: pgsql: Fix log_temp_files docs and comments tosay bytes not kilobytes.
Next: Streaming Replication: sql error on standby
From: ingo.sander on 23 Jun 2010 04:48 Hi, Sql query "select pg_last_xlog_receive_location(); " does not work during startup of standby database. TestScenario; We have a active-standby system with PostgreSQL Streaming Replication beta2. If the active database is up the database is in use (read/write queries will be performed). Then the standby PostgreSQL SR will be started (the complete database from the active side is copied to the standby side; nec. Files for starting streaming replication are created). Directly after the possibility to connect to the standby system, the above given sql query will be executed. To this timepoint the sql query delivers an error. To a later timepoint (all wal segments are completly incooperated) the query delivers a valid result. Question: What is the reason for the error? Exists a command to find out if the standby database is really active to accept/can work with sql commands? BR Ingo Best Regards/mfG Ingo Sander ========================================================= Nokia Siemens Networks GmbH &Co. KG NWS EP CP SVSS Platform Tech Support DE St.-Martin-Str. 76 D-81541 München *Tel.: +49-89-515938390 *ingo.sander(a)nsn.com Nokia Siemens Networks GmbH & Co. KG Sitz der Gesellschaft: München / Registered office: Munich Registergericht: München / Commercial registry: Munich, HRA 88537 WEEE-Reg.-Nr.: DE 52984304 Persönlich haftende Gesellschafterin / General Partner: Nokia Siemens Networks Management GmbH Geschäftsleitung / Board of Directors: Lydia Sommer, Olaf Horsthemke Vorsitzender des Aufsichtsrats / Chairman of supervisory board: Herbert Merz Sitz der Gesellschaft: München / Registered office: Munich Registergericht: München / Commercial registry: Munich, HRB 163416 |