I would like to try native replication rather than streaming as it makes fail-over so much simpler. <br>Operating system is Debian 6 with squeeze-backports to provide postgresql-9.1<br><br><code><br>apt-get install postgresql-server-dev-9.1<br>
wget <a href="http://pgfoundry.org/frs/download.php/3164/pgpool-II-3.0.5.tar.gz">http://pgfoundry.org/frs/download.php/3164/pgpool-II-3.0.5.tar.gz</a><br>tar -xvf pgpool-II-3.0.5.tar.gz<br>cd pgpool-II-3.0.5/sql/pgpool-regclass/<br>
make<br><snip><br>pgpool-regclass.c:55: error: static declaration of ‘get_namespace_oid’ follows non-static declaration<br>/usr/include/postgresql/9.1/server/catalog/namespace.h:99: note: previous declaration of ‘get_namespace_oid’ was here<br>
make: *** [pgpool-regclass.o] Error 1<br></code><br><br>I read this thread about it -> <a href="http://lists.pgfoundry.org/pipermail/pgpool-general/2011-July/003841.html">http://lists.pgfoundry.org/pipermail/pgpool-general/2011-July/003841.html</a><br>
But I have some questions, what is the recommended way to implement "replication mode" Should I use pgsql 9.0?<br><br>Thanks.<br><br>-Aric Gardner <br>