您好！
我想下载我们 discourse 平台的所有数据，并将其以 PDF 或类似格式呈现，以便将来可能用于审计。
有人向我展示了如何下载备份 SQL 文件，但我一直无法将其转换为任何可呈现的格式。
有人做过这件事吗？能给我一些建议吗？
任何 Discourse 实例的所有数据对于 PDF 文件来说都太多了。
如果您想审计 Discourse 实例的全部数据，这些就是正确的文件。虽然它们在某种程度上是人类可读的：
--
-- Name: posts; Type: TABLE DATA; Schema: public; Owner: 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
\.
审计将涉及将这些文件加载到另一个 PostgreSQL 实例中，然后使用它来执行分析。
6 个赞
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.