How can I directly edit Discourse database from a GUI?

Installation
18

How I solved How can I directly edit Discourse database from a GUI? since it is not answered with what I was seeking.

:warning: Do not do this on a production machine.

This uses the PostgreSQL recommended admin tool pgAdmin 4

This was done on my local machine to learn more about Discourse, e.g. install, configure, tune, develop plugins, use API, webhooks, etc.

Note: Discourse was installed on Ubuntu 18.04 on WSL 2 on Windows 10 per Beginners Guide to Install Discourse on Windows 10 for Development

Note: WSL 2 does not come with systemd. Issue 457

Using Install pgAdmin 4 on Ubuntu 20.04/18.04/16.04 as a template

Using BASH

$ echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main $ sudo apt update $ sudo apt install pgadmin4 pgadmin4-apache2 pgAdmin4 user email: postgres@localhost pgAdmin4 password: <password 1> $ sudo /etc/init.d/apache2 restart $ sudo ufw allow http $ sudo ufw allow https $ hostname -I Record <address> $ whoami Record <user name>

This next step may not be needed as I did not know how to get a Postgres DB user’s password as I am not a PostgreSQL expert, or if there was another way to set up the needed DB login for pgadmin4.

$ psql postgres

Using PSQL

postgres=# ALTER ROLE <user name> '<password 2>';

Using Internet browser

http://<address>/pgadmin4 user: postgres@localhost password: <password 1>

Once pgAdmin4 starts

Using pgAdmin4

Create a sever connection

Tab: General Name: Discourse Development Server group: Servers Tab: Connection Host: localhost Port: 5432 Maintenance database: postgres Username: <user name> Password: <password 2>

This is not perfect but it works and is better than nothing. Feedback and suggestions welcome.

Bonus round

PostgreSQL
Software Catalogue - Administration/development tools

2 Likes