Salut !
Je souhaite télécharger toutes les données de notre plateforme Discourse et les présenter dans un format PDF ou similaire pour d’éventuels audits futurs.
On m’a montré comment télécharger les fichiers SQL de sauvegarde, mais je n’ai pas réussi à les convertir en quelque chose de présentable.
Quelqu’un a-t-il déjà fait cela et peut me donner quelques conseils ?
Toutes les données d’une instance Discourse représentent beaucoup trop de données pour un fichier PDF.
Ce sont les bons fichiers si vous souhaitez auditer l’intégralité des données d’une instance Discourse. Bien qu’ils soient quelque peu lisibles par l’homme
--
-- Données pour la table : posts; Type : TABLE DATA; Schéma : public; Propriétaire : falco
--
COPY public.posts (id, user_id, topic_id, post_number, raw, cooked, created_at, updated_at, reply_to_post_number, reply_count, quote_count, deleted_at, off_topic_count, like_count, incoming_link_count, bookmark_count, score, reads, post_type, sort_order, last_editor_id, hidden, hidden_reason_id, notify_moderators_count, spam_count, illegal_count, inappropriate_count, last_version_at, user_deleted, reply_to_user_id, percent_rank, notify_user_count, like_score, deleted_by_id, edit_reason, word_count, version, cook_method, wiki, baked_at, baked_version, hidden_at, self_edits, reply_quoted, via_email, raw_email, public_version, action_code, locked_by_id, image_upload_id) FROM stdin;
15426 -2 2405 1 Thanks for joining Discourse, and welcome!\n\n- I’m only a robot, but [our friendly staff](/about) are also here to help if you need to reach a person.\n\n- For safety reasons, we temporarily limit what new users can do. You’ll gain [new abilities](https://blog.discourse.org/2018/06/understanding-discourse-trust-levels/) (and [badges](/badges)) as we get to know you.\n\n- We believe in [civilized community behavior](/guidelines) at all times.\n\nIf you’d like to learn more, select <img> src="/plugins/discourse-narrative-bot/images/font-awesome-ellipsis.png" width="16" height="16"> below and <img> src="/plugins/discourse-narrative-bot/images/font-awesome-bookmark.png" width="16" height="16"> **bookmark this personal message**. If you do, there may be a :gift: in your future! <p>Thanks for joining Discourse, and welcome!</p>\n<ul>\n<li>\n<p>I’m only a robot, but <a href="/about">our friendly staff</a> are also here to help if you need to reach a person.</p>\n</li>\n<li>\n<p>For safety reasons, we temporarily limit what new users can do. You’ll gain <a href="https://blog.discourse.org/2018/06/understanding-discourse-trust-levels/">new abilities</a> (and <a href="/badges">badges</a>) as we get to know you.</p>\n</li>\n<li>\n<p>We believe in <a href="/guidelines">civilized community behavior</a> at all times.</p>\n</li>\n</ul>\n<p>If you’d like to learn more, select <img src="//127.0.0.1:4200/plugins/discourse-narrative-bot/images/font-awesome-ellipsis.png" width="16" height="16"> below and <img src="//127.0.0.1:4200/plugins/discourse-narrative-bot/images/font-awesome-bookmark.png" width="16" height="16"> <strong>bookmark this personal message</strong>. If you do, there may be a <img src="//127.0.0.1:4200/images/emoji/twitter/gift.png?v=12" title=":gift:" class="emoji" alt=":gift:" loading="lazy" width="20" height="20"> in your future!</p> 2022-06-23 20:35:49.119227 2022-06-23 20:35:49.119227 \N 0 0 \N 0 0 0 0 0.2 1 1 1 -2 f \N 0 0 0 0 2022-06-23 20:35:49.136783 f \N 0 0 0 \N \N 128 1 1 f 2022-06-23 20:35:49.119201 2 \N 0 f f \N 1 \N \N \N
18333 -2 5312 1 Thanks for joining Discourse, and welcome!\n\n- I’m only a robot, but [our friendly staff](/about) are also here to help if you need to reach a person.\n\n- For safety reasons, we temporarily limit what new users can do. You’ll gain [new abilities](https://blog.discourse.org/2018/06/understanding-discourse-trust-levels/) (and [badges](/badges)) as we get to know you.\n\n- We believe in [civilized community behavior](/guidelines) at all times.\n\nIf you’d like to learn more, select <img> src="/plugins/discourse-narrative-bot/images/font-awesome-ellipsis.png" width="16" height="16"> below and <img> src="/plugins/discourse-narrative-bot/images/font-awesome-bookmark.png" width="16" height="16"> **bookmark this personal message**. If you do, there may be a :gift: in your future! <p>Thanks for joining Discourse, and welcome!</p>\n<ul>\n<li>\n<p>I’m only a robot, but <a href="/about">our friendly staff</a> are also here to help if you need to reach a person.</p>\n</li>\n<li>\n<p>For safety reasons, we temporarily limit what new users can do. You’ll gain <a href="https://blog.discourse.org/2018/06/understanding-discourse-trust-levels/">new abilities</a> (and <a href="/badges">badges</a>) as we get to know you.</p>\n</li>\n<li>\n<p>We believe in <a href="/guidelines">civilized community behavior</a> at all times.</p>\n</li>\n</ul>\n<p>If you’d like to learn more, select <img src="//127.0.0.1:4200/plugins/discourse-narrative-bot/images/font-awesome-ellipsis.png" width="16" height="16"> below and <img src="//127.0.0.1:4200/plugins/discourse-narrative-bot/images/font-awesome-bookmark.png" width="16" height="16"> <strong>bookmark this personal message</strong>. If you do, there may be a <img src="//127.0.0.1:4200/images/emoji/twitter/gift.png?v=12" title=":gift:" class="emoji" alt=":gift:" loading="lazy" width="20" height="20"> in your future!</p> 2022-06-23 20:43:07.420056 2022-06-23 20:43:07.420056 \N 0 0 \N 0 0 0 0 0.2 1 1 1 -2 f \N 0 0 0 0 2022-06-23 20:43:07.460739 f \N 0 0 0 \N \N 128 1 1 f 2022-06-23 20:43:07.420023 2 \N 0 f f \N 1 \N \N \N
\.
Un audit impliquerait de charger ces fichiers dans une autre instance PostgreSQL, puis d’effectuer l’analyse en l’utilisant.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.