Exporting data from version 0.9.4 installed through bitnami

alphydan · 2015 年9 月 28 日 15:25

I installed Discourse 0.9.4 a while ago using Bitnami. After some troubleshooting, it worked for a few months without problem. However, when I tried to upgrade, I ran into all sorts of problems but I didn’t have the time to debug back then. A few months later, I could not access the website online anymore (I would just see a blank page).

I now have a bit of time again, and was hoping to backup the contents (maybe a json, csv or some format that I can parse and upload somewhere else). I can log into the EC2 instance and see the apps, htdocs, stack directories.

Is there an easy way to export? Is there a tutorial to do so?

Any help appreciated.

johnmuhl · 2015 年9 月 28 日 19:07

If you can directly access the database you should be able to use pg_dump to export the data.

johnmuhl · 2015 年9 月 28 日 19:09

Here is what Discourse does.

github.com/discourse/discourse

lib/backup_restore/backuper.rb

a726f5efe


      
          def pg_dump_command
            db_conf = BackupRestore.database_configuration
          
            password_argument = "PGPASSWORD='#{db_conf.password}'" if db_conf.password.present?
            host_argument     = "--host=#{db_conf.host}"         if db_conf.host.present?
            port_argument     = "--port=#{db_conf.port}"         if db_conf.port.present?
            username_argument = "--username=#{db_conf.username}" if db_conf.username.present?
          
            [ password_argument,            # pass the password to pg_dump (if any)
              "pg_dump",                    # the pg_dump command
              "--schema=public",            # only public schema
              "--file='#{@dump_filename}'", # output to the dump.sql file
              "--no-owner",                 # do not output commands to set ownership of objects
              "--no-privileges",            # prevent dumping of access privileges
              "--verbose",                  # specifies verbose mode
              host_argument,                # the hostname to connect to (if any)
              port_argument,                # the port to connect to (if any)
              username_argument,            # the username to connect as (if any)
              db_conf.database              # the name of the database to dump
            ].join(" ")
          end

alphydan · 2015 年9 月 28 日 20:23

Thank you for the tips. Here’s what I tried so far, following the Bitnami wiki.

trying to edit any file would result in: No space left on device.
So I decided to backup the images first:

scp -r -i ~/.bitnami/bitnami-hosting.pem bitnami@myserver.bitnamiapp.com:/opt/bitnami/apps/discourse/htdocs/public/uploads/default/* .

I tried,

pg_dump -U postgres bitnami_discourse > backup.sql

but got an error:

/opt/bitnami/postgresql/bin/pg_dump.bin: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

I tried to find the offending library with sudo find /opt/bitnami/postgresql/ -name libpq.so.5 and indeed it’s at /opt/bitnami/postgresql/lib/libpq.so.5

I tried sudo ldconfig -v as per this SO answer and this one but without success.

I’m afraid when I opened /opt/bitnami/postgresql/bin/setenv.sh to try to change the psql password, because of lack of space nothing was saved. So setenv.sh is now empty. Are the contents of sentenv.sh standard? Or should I ask at Bitnami?

Thank you.

alphydan · 2016 年4 月 6 日 08:52

I didn’t manage to solve this issue. I’m happy to pay $45 to anybody who can help me solve it. Thank you.

话题		回复	浏览量
Export all data of all posts Product Support	3	4037	2021 年9 月 20 日
Discourse restore with pg_dump Self-hosting	2	1080	2018 年10 月 22 日
Manually create and restore Discourse backups Sysadmins how-to	13	16579	2022 年6 月 16 日
Create, download, and restore a backup of your Discourse database Self-Hosting backups , how-to	25	25573	2026 年5 月 29 日
Being Cautious: Database backup + restore process when testing things Product Support unsupported-install	8	790	2020 年11 月 17 日

Exporting data from version 0.9.4 installed through bitnami

AI 生成的摘要

相关话题