Wait, what? I actually removed new_pgsql before I ran that last time.<div><br></div><div>...</div><div><br></div><div>Okay, that was weird. Sorry about that - I guess I pulled the wrong command from history. After fixing my configure options, slony was successfully configured. Running make now.</div>
<div><br></div><div>The new_pgsql directory was another directory where I tried to install postgres to, to see if a blank install (with threadsafe enabled) would fix the issue. It didn't.</div><div><br></div><div>The Fix:</div>
<div><br></div><div>Note that this seems really strange, so I'm taking my own words with a grain of salt (and so should everyone who reads this).</div><div><br></div><div>I still had the original postgres source directory, where I had first extracted to, so I just re-ran ./configure with the new options, then ran make, assuming everything would get overwritten with the new options. Apparently not.</div>
<div><br></div><div>Removing the directory, extracting the tarball anew, and then doing a new configure, make, and make install did work. So I guess I'll just need to remember to start from scratch next time.</div><div>
<span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse;color:rgb(136, 136, 136)">--- <br>===========================<br>Samuel Nelson<br>Consistent State<br><a href="http://www.consistentstate.com" style="color:rgb(42, 93, 176)" target="_blank">www.consistentstate.com</a><br>
303-955-0509<br>===========================</span><br>
<br><br><div class="gmail_quote">On Tue, Jul 12, 2011 at 11:15 AM, Steve Singer <span dir="ltr"><<a href="mailto:ssinger@ca.afilias.info">ssinger@ca.afilias.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On 11-07-12 12:52 PM, Sam Nelson wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Sure. Here it is.<br>
---<br>
===========================<br>
Samuel Nelson<br>
Consistent State<br>
</div><div class="im"><a href="http://www.consistentstate.com" target="_blank">www.consistentstate.com</a> <<a href="http://www.consistentstate.com" target="_blank">http://www.consistentstate.<u></u>com</a>><br>
<a href="tel:303-955-0509" value="+13039550509" target="_blank">303-955-0509</a><br>
===========================<br>
</div></blockquote>
<br>
configure is linking the version in /usr/local/new_pgsql/lib<br>
Based on the output in your config.log I don't think that version of libpq has thread safety enabled.<br>
<br>
It also seems strange that you are using some things from /usr/local/new_pgsql and some things from /usr/local/pgsql<br>
<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
<br>
<br>
On Tue, Jul 12, 2011 at 9:53 AM, Steve Singer <<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.info</a><br></div><div class="im">
<mailto:<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.<u></u>info</a>>> wrote:<br>
<br>
On 11-07-12 11:51 AM, Sam Nelson wrote:<br>
<br>
Well, I checked the output of that command and it didn't look<br>
right, so<br>
I removed all postgres directories (everything except the postgres<br>
cluster) in /usr/local/pgsql and deleted the old postgresql install<br>
directory, extracted the tarball again, re-configured postgres, and<br>
tried again. This time, I got what I was expecting from pg_config:<br>
<br>
$ /usr/local/pgsql/bin/pg_config --configure<br>
'--with-python' '--with-perl' '--enable-thread-safety'<br>
'--prefix=/usr/local/pgsql'<br>
<br>
<br>
Can I see the config.log file that configure generates?<br>
<br>
<br>
<br>
However, even after doing the above and<br>
adding --with-pgconfigdir=/usr/local/<u></u>__pgsql/bin, Slony refuses to<br>
configure. It still comes back saying configure: error:<br>
PQisthreadsafe<br>
test failed - PostgreSQL needs to be compiled with<br>
--enable-thread-safety<br>
---<br>
===========================<br>
Samuel Nelson<br>
Consistent State<br>
<a href="http://www.consistentstate.com" target="_blank">www.consistentstate.com</a> <<a href="http://www.consistentstate.com" target="_blank">http://www.consistentstate.<u></u>com</a>><br></div>
<<a href="http://www.consistentstate." target="_blank">http://www.consistentstate.</a>__<u></u>com <<a href="http://www.consistentstate.com" target="_blank">http://www.consistentstate.<u></u>com</a>>><br>
<br>
<a href="tel:303-955-0509" value="+13039550509" target="_blank">303-955-0509</a> <tel:<a href="tel:303-955-0509" value="+13039550509" target="_blank">303-955-0509</a>><div class="im"><br>
===========================<br>
<br>
<br>
On Tue, Jul 12, 2011 at 2:48 AM, Jan Wieck <<a href="mailto:JanWieck@yahoo.com" target="_blank">JanWieck@yahoo.com</a><br>
<mailto:<a href="mailto:JanWieck@yahoo.com" target="_blank">JanWieck@yahoo.com</a>><br></div><div><div></div><div class="h5">
<mailto:<a href="mailto:JanWieck@yahoo.com" target="_blank">JanWieck@yahoo.com</a> <mailto:<a href="mailto:JanWieck@yahoo.com" target="_blank">JanWieck@yahoo.com</a>>>> wrote:<br>
<br>
On 7/11/2011 6:13 PM, Sam Nelson wrote:<br>
<br>
Hrm. Didn't seem to help.<br>
<br>
I did have a few different libpq's on the testing VMs we<br>
have<br>
set up, so<br>
I removed them all. Now, find / -name '*libpq*' (as<br>
root) only<br>
finds<br>
the instance that has been installed with thread safety.<br>
<br>
I even tried using --enable-thread-safety-force (and<br>
then, as per<br>
postres's configure instructions, testing for thread<br>
safety with the<br>
binary in src/test/thread/, which came back saying the<br>
system<br>
was thread<br>
safe). Still no luck.<br>
<br>
I'm using the following flags for slony's ./configure<br>
script:<br>
--prefix=/usr/local/pgsql/<br>
--with-pgbindir=/usr/local/___<u></u>_pgsql/bin/<br>
--with-pglibdir=/usr/local/___<u></u>_pgsql/lib/<br>
<br>
Do I need anything more than that?<br>
<br>
<br>
What is the output of<br>
<br>
/usr/local/pgsql/bin/pg_config --configure<br>
<br>
and did you try<br>
<br>
./configure --with-pgconfigdir=/usr/local/<u></u>____pgsql/bin<br>
<br>
<br>
Jan<br>
<br>
--<br>
Anyone who trades liberty for security deserves neither<br>
liberty nor security. -- Benjamin Franklin<br>
<br>
<br>
<br>
<br>
</div></div></blockquote>
<br>
</blockquote></div><br></div>