Did I need to backup postgres data before launch cleanup command?


(Hidetaka Ko) #1

The Problem

Our platform’s discourse is initialized. How can I get the backup

Process

I accidentally clean up and push all yes.


(Jay Pfaffman) #2

Your forum is still running isn’t it?

Those messages are scary, but you should be fine.


(Hidetaka Ko) #3

Our forum is still running but is initialized like below.


(Watercolor Games) #4

Did you lose all your categories, posts, topics, users etc? If not, head to your admin panel, Backups, and you should be able to create one and download it from there in case you accidentally mess up and lose everything.


(Hidetaka Ko) #5

@Watercolor_Games Yes, I lost all our categories, posts, topics, users etc. And, I don’t have our backups.


(Sam Saffron) #6

Can I see a copy of your app.yml (passwords removed)


(Hidetaka Ko) #7

@sam Sure.


## this is the all-in-one, standalone Discourse Docker container template
##
## After making changes to this file, you MUST rebuild
## /var/discourse/launcher rebuild app
##
## BE *VERY* CAREFUL WHEN EDITING!
## YAML FILES ARE SUPER SUPER SENSITIVE TO MISTAKES IN WHITESPACE OR ALIGNMENT!
## visit http://www.yamllint.com/ to validate this file as needed

templates:
  - "templates/postgres.template.yml"
  - "templates/redis.template.yml"
  - "templates/web.template.yml"
  - "templates/web.ratelimited.template.yml"
## Uncomment these two lines if you wish to add Lets Encrypt (https)
  - "templates/web.ssl.template.yml"
  - "templates/web.letsencrypt.ssl.template.yml"

## which TCP/IP ports should this container expose?
## If you want Discourse to share a port with another webserver like Apache or nginx,
## see https://meta.discourse.org/t/17247 for details
expose:
  - "80:80"   # http
  - "443:443" # https

params:
  db_default_text_search_config: "pg_catalog.english"

  ## Set db_shared_buffers to a max of 25% of the total memory.
  ## will be set automatically by bootstrap based on detected RAM, or you can override

  # DISCOURSE_DEFAULT_LOCALE: en

  ## How many concurrent web requests are supported? Depends on memory and CPU cores.
  ## will be set automatically by bootstrap based on detected CPUs, or you can override
  #UNICORN_WORKERS: 3

  ## TODO: The domain name this Discourse instance will respond to
  DISCOURSE_HOSTNAME: lounge.diverseas.com

  ## Uncomment if you want the container to be started with the same
  ## hostname (-h option) as specified above (default "$hostname-$config")
  #DOCKER_USE_HOSTNAME: true

  ## TODO: List of comma delimited emails that will be made admin and developer
  ## on initial signup example 'user1@example.com,user2@example.com'
  DISCOURSE_DEVELOPER_EMAILS: 'hidetaka.48691001@icloud.com'

  ## TODO: The SMTP mail server used to validate new accounts and send notifications
  DISCOURSE_SMTP_ADDRESS: smtp.mailgun.org
  DISCOURSE_SMTP_PORT: 587
  DISCOURSE_SMTP_USER_NAME: postmaster@mail.xxxxxxx.com
  DISCOURSE_SMTP_PASSWORD: "xxxxxxxxxxxx"
  #DISCOURSE_SMTP_ENABLE_START_TLS: true           # (optional, default true)

  ## If you added the Lets Encrypt template, uncomment below to get a free SSL certificate
  LETSENCRYPT_ACCOUNT_EMAIL: hidetaka.48691001@icloud.com

  ## The CDN address for this Discourse instance (configured to pull)
  ## see https://meta.discourse.org/t/14857 for details



## The Docker container is stateless; all data is stored in /shared
volumes:
  - volume:
      host: /var/discourse/shared/standalone
      guest: /shared
  - volume:
      host: /var/discourse/shared/standalone/log/var-log
      guest: /var/log

## Plugins go here
## see https://meta.discourse.org/t/19157 for details
#hooks:
#  after_code:
#    - exec:
#        cd: $home/plugins
#        cmd:
#          - mkdir -p plugins
#          - git clone https://github.com/discourse/docker_manager.git
#          - git clone https://github.com/zh99998/discourse-username-localization.git
#          - bash discourse-username-localization/install.sh

## Any custom commands to run after building
run:
  - exec: echo "Beginning of custom commands"
  ## If you want to set the 'From' email address for your first registration, uncomment and change:
  ## After getting the first signup email, re-comment the line. It only needs to run once.
  #- exec: rails r "SiteSetting.notification_email='info@unconfigured.discourse.org'"
  - exec: echo "End of custom commands"

(Jay Pfaffman) #9

You don’t need to drop the database all you need to do is restore it.

If you want to anyway you can

rake db:drop db:init  db:migrate

(Hidetaka Ko) #10

@pfaffman
I didn’t do that like above. I already accidentally cleanup the data and our forum is initialized like above.
How can I recover it? Is it impossible?