Streaming Replication: sql error on standby

Поиск
Список
Период
Сортировка
От Sander, Ingo (NSN - DE/Munich)
Тема Streaming Replication: sql error on standby
Дата
Msg-id 9EB22E4572ECF74AAFEAE743C74D26B203430A95@DEMUEXC005.nsn-intra.net
обсуждение исходный текст
Ответы Re: Streaming Replication: sql error on standby  (Robert Haas <robertmhaas@gmail.com>)
Re: Streaming Replication: sql error on standby  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
<p><font face="Arial" size="2">Hi, </font><p><font face="Arial" size="2">Sql query "select
pg_last_xlog_receive_location();" does not work during startup of standby database. </font><br /><font face="Arial"
size="2">TestScenario;</font><br/><font face="Arial" size="2">We have a active-standby system with PostgreSQL Streaming
Replicationbeta2. If the active database is up the database is in use (read/write queries will be performed). Then the
standbyPostgreSQL SR will be started (the complete database from the active side is copied to the standby side; nec.
Filesfor starting streaming replication are created). Directly after the possibility to connect to the standby system,
theabove given sql query will be executed. To this timepoint the sql query delivers an error. To a later timepoint (all
walsegments are completly incooperated) the query delivers a valid result. </font><p><font face="Arial"
size="2">Question:</font><br /><font face="Arial" size="2">What is the reason for the error?</font><br /><font
face="Arial"size="2">Exists a command to find out if the standby database is really active to accept/can work with sql
commands?</font><p><font face="Arial" size="2">BR</font><br /><font face="Arial" size="2">Ingo</font><p><i><font
color="#000000"face="Brush Script MT" size="4">Best Regards/mfG</font></i><br /><i><b><font color="#FF0000" face="Brush
ScriptMT" size="6">Ingo Sander</font></b></i><br /><font face="Times New Roman"
size="2">=========================================================</font><br/><font face="Arial Black" size="2">Nokia
SiemensNetworks GmbH &Co. KG</font><br /><span lang="en-us"><font face="Courier New" size="2">NWS EP CP SVSS
PlatformTech Support DE</font></span><br /><span lang="en-us"><font face="Courier New" size="2">St.-Martin-Str.
76</font></span><br/><span lang="en-us"><font face="Courier New" size="2">D-81541 München</font></span><br /><span
lang="de"><fontcolor="#008080" face="Wingdings" size="5">(</font><font face="Tahoma" size="2">Tel.: 
+49-89-515938390</font></span><br/><span lang="de"><font color="#008080" face="Wingdings"
size="5">+</font><u></u><u></u><u><fontcolor="#0000FF" face="Tahoma"
size="2">ingo.sander@nsn.com</font></u></span><p><spanlang="de"><b><font color="#808080" face="Times New Roman"
size="1">Nokia</font></b><fontcolor="#808080" face="Times New Roman" size="1"></font><b> <font color="#808080"
face="TimesNew Roman" size="1">Siemens Networks GmbH & Co. KG</font><br /><font color="#808080" face="Arial"
size="1">Sitzder Gesellschaft: München / Registered office: Munich</font></b></span><br /><span lang="de"><b><font
color="#808080"face="Arial" size="1">Registergericht: München / Commercial registry: Munich, HRA
88537</font></b></span><br/><span lang="de"><b><font color="#808080" face="Arial" size="1">WEEE-Reg.-Nr.: DE
52984304</font></b></span><p><spanlang="de"><b><font color="#808080" face="Arial" size="1">Persönlich haftende
Gesellschafterin/ General Partner: Nokia Siemens Networks Management GmbH</font></b></span><br /><span
lang="de"><b><fontcolor="#808080" face="Arial" size="1">Geschäftsleitung / Board of Directors: Lydia Sommer, Olaf
Horsthemke</font></b></span><br/><span lang="de"><b><font color="#808080" face="Arial" size="1">Vorsitzender des
Aufsichtsrats/ Chairman of supervisory board: Herbert Merz</font></b></span><br /><span lang="de"><b><font
color="#808080"face="Arial" size="1">Sitz der Gesellschaft: München / Registered office: Munich</font></b></span><br
/><spanlang="de"><b><font color="#808080" face="Arial" size="1">Registergericht: München / Commercial registry: Munich,
HRB163416</font></b></span><br /> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: New PGXN Extension site
Следующее
От: Pavel Baros
Дата:
Сообщение: GSoC - code of implementation of materialized views