Aggregate data loss on Digital Ocean Droplet

Support
7

@yanokwa sorry for being so hurried in my reply. I will try to take you through the steps I took.

  1. I signed up to Digital Ocean account using the option "Sign up with Google" and my Google password is not the best example of a strong unique password.
  2. I am afraid my machine password is not a strong unique password either: no upper case, no symbols!
  3. Yes I changed some of the PostgreSQL settings to allow remote access. On the machine, I added the line host all all 0.0.0.0/0 trust on /etc/postgresql/10/main/pg_hba.conf and changed /etc/postgresql/10/main/postgresql.conf by setting listen_addresses='*' to make postgres be listened from remotely. I guess that using 0.0.0.0/0 instead of my local machine IP address is not exactly what people would call a brilliant idea!

Please let me know if you need more details as well as providing any other recommendation to avoid obvious mistakes.
Thank you very much

1 Like