<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="markdown-here-wrapper" data-md-url="Thunderbird"
style="">
<p style="margin: 0px 0px 1.2em ! important;">Hi Badlop,</p>
<p style="margin: 0px 0px 1.2em ! important;">Thank you for the
swift response.</p>
<p style="margin: 0px 0px 1.2em ! important;">On 08/06/17 18:15,
Badlop wrote:</p>
<p style="margin: 0px 0px 1.2em ! important;"></p>
<div class="markdown-here-exclude">
<p></p>
<blockquote type="cite"
cite="mid:CAA6KaLzNe45DdpuFX4KPLaH8DzrEYgj6+Ex+d6LZ2Dh3Yf0yaw@mail.gmail.com">
<pre wrap="">Hi,
That error message indicates you have mod_announce configured to use
mnesia, but asked to get it exported to SQL. Configure mod_announce to
use SQL in the ejabberd configuration file, restart, and then request
the old database export.
</pre>
</blockquote>
<p></p>
</div>
<p style="margin: 0px 0px 1.2em ! important;"></p>
<p style="margin: 0px 0px 1.2em ! important;">Yes, that’s exactly
how I have it configured - everything has thus far been using
mnesia. I want to export that data and import it into PostgreSQL
- for all modules that support this. Is the correct method,
then, to change <code style="font-size: 0.85em; font-family: Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em; padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid rgb(234, 234, 234); background-color: rgb(248, 248, 248); border-radius: 3px; display: inline;">default_db</code>
to <code style="font-size: 0.85em; font-family: Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em; padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid rgb(234, 234, 234); background-color: rgb(248, 248, 248); border-radius: 3px; display: inline;">sql</code>,
configure the database connection, restart ejabberd and issue
the same command? I expected that would attempt to export <strong>from</strong>
PostgreSQL, but there’s no data there yet. Or should I use the <code style="font-size: 0.85em; font-family: Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em; padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid rgb(234, 234, 234); background-color: rgb(248, 248, 248); border-radius: 3px; display: inline;">dump</code>
command, switch the configuration to PostgreSQL and then use the
<code style="font-size: 0.85em; font-family: Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em; padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid rgb(234, 234, 234); background-color: rgb(248, 248, 248); border-radius: 3px; display: inline;">load</code>
command?</p>
<p style="margin: 0px 0px 1.2em ! important;">Many thanks,</p>
<p style="margin: 0px 0px 1.2em ! important;">JT</p>
<div
title="MDH:PGRpdiBjbGFzcz0ibW96LWNpdGUtcHJlZml4Ij5IaSBCYWRsb3AsPGJyPjxicj5UaGFuayB5b3UgZm9yIHRoZSBzd2lmdCByZXNwb25zZS48YnI+PGJyPk9uIDA4LzA2LzE3IDE4OjE1LCBCYWRsb3Ag
d3JvdGU6PGJyPjwvZGl2PjxibG9ja3F1b3RlIHR5cGU9ImNpdGUiIGNpdGU9Im1pZDpDQUE2S2FM
ek5lNDVEZHB1Rlg0S1BMYUg4RHpyRVlnajYrRXgrZDZMWjJEaDNZZjB5YXdAbWFpbC5nbWFpbC5j
b20iPjxwcmUgd3JhcD0iIj5IaSwKClRoYXQgZXJyb3IgbWVzc2FnZSBpbmRpY2F0ZXMgeW91IGhh
dmUgbW9kX2Fubm91bmNlIGNvbmZpZ3VyZWQgdG8gdXNlCm1uZXNpYSwgYnV0IGFza2VkIHRvIGdl
dCBpdCBleHBvcnRlZCB0byBTUUwuIENvbmZpZ3VyZSBtb2RfYW5ub3VuY2UgdG8KdXNlIFNRTCBp
biB0aGUgZWphYmJlcmQgY29uZmlndXJhdGlvbiBmaWxlLCByZXN0YXJ0LCBhbmQgdGhlbiByZXF1
ZXN0CnRoZSBvbGQgZGF0YWJhc2UgZXhwb3J0LgoKPC9wcmU+PC9ibG9ja3F1b3RlPlllcywgdGhh
dCdzIGV4YWN0bHkgaG93IEkgaGF2ZSBpdCBjb25maWd1cmVkIC0gZXZlcnl0aGluZyBoYXMgdGh1
cyBmYXIgYmVlbiB1c2luZyBtbmVzaWEuIEkgd2FudCB0byBleHBvcnQgdGhhdCBkYXRhIGFuZCBp
bXBvcnQgaXQgaW50byBQb3N0Z3JlU1FMIC0gZm9yIGFsbCBtb2R1bGVzIHRoYXQgc3VwcG9ydCB0
aGlzLiBJcyB0aGUgY29ycmVjdCBtZXRob2QsIHRoZW4sIHRvIGNoYW5nZSBgZGVmYXVsdF9kYmAg
dG8gYHNxbGAsIGNvbmZpZ3VyZSB0aGUgZGF0YWJhc2UgY29ubmVjdGlvbiwgcmVzdGFydCBlamFi
YmVyZCBhbmQgaXNzdWUgdGhlIHNhbWUgY29tbWFuZD8gSSBleHBlY3RlZCB0aGF0IHdvdWxkIGF0
dGVtcHQgdG8gZXhwb3J0ICoqZnJvbSoqIFBvc3RncmVTUUwsIGJ1dCB0aGVyZSdzIG5vIGRhdGEg
dGhlcmUgeWV0LiBPciBzaG91bGQgSSB1c2UgdGhlIGBkdW1wYCBjb21tYW5kLCBzd2l0Y2ggdGhl
IGNvbmZpZ3VyYXRpb24gdG8gUG9zdGdyZVNRTCBhbmQgdGhlbiB1c2UgdGhlIGBsb2FkYCBjb21t
YW5kPzxicj48YnI+TWFueSB0aGFua3MsPGJyPjxicj5KVDxicj4="
style="height:0;width:0;max-height:0;max-width:0;overflow:hidden;font-size:0em;padding:0;margin:0;"></div>
</div>
<pre class="moz-signature markdown-here-signature" cols="72">--
---------------------------------------+--------------------------------
James Tait, BSc | <a class="moz-txt-link-freetext" href="xmpp:jayteeuk@wyrddreams.org">xmpp:jayteeuk@wyrddreams.org</a>
Programmer and Free Software advocate | Tel: +44 (0)870 490 2407
---------------------------------------+--------------------------------
</pre>
</body>
</html>