<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>