How does one install PgAdmin?

aaP_constrootoffice

Hi. We installed aaPanel and are a huge fan of it. It has great support for mysql, but for our use case, mysql is not feasible anymore. We need to have Postgres Database, and while this is supported, having a tool like PgAdmin is crucial for us. I am sure there are a lot of other people that would like this too. This post mentions that we should refer to its docs for installation, but that is not as simple with aaPanel. Is there a tutorial that we are missing when it comes to installing apps that are not in the App Store of the aaPanel?

https://www.aapanel.com/forum/d/22700-how-to-install-pgadmin-on-aapanel/3

Thank you & I would really appreciate some guidance.

Edit:

I figured I would give docker a try, i managed to install and run pgAdmin, I able to access it on my IP😛ort, but when I add a connection in it, it gives me an error:

This is PostgreSQL Manager:

aaP_constrootoffice

I have resolved this issue, although, I am not happy.

Step 1. Go to "Databases" and install PgSQL from there. It will install PostreSQL Manager. (Side note, this, for some reason, is different than the Application that it installs through the app store. Use that instead - go to App Store, search "pg" it will come up, then enable it to show on dashboard).

Step 2. Go to "Docker" and install it.
Step 3. Go to "All" and search for pgAdmin" - then install it.
Step 4. Make sure you go to your VPS/Firewall and open the port mentioned. Use http not https to access it http://ip:port
Step 5. Go to terminal:
nano /www/server/data/pgsql/pg_hba.conf
At the end of the line add this:

# Allow connections from Docker network (pgAdmin container)
host    all             all             172.18.0.0/16            md5

# Allow connections from your public IP (replace with actual IP)
host    all             all             {YOUR ACTUAL VPS IP}/32         md5

Your actual VPS IP goes where it says it should go.

Step 6. Go to PostgreSQL Manager and restart it.
Step 7. Access your pgAdmin through

http://IP:24380

and then add your postgre server. (FYI, you do not need to have a database in place).
Step 8. Profit.

I do not know if this is good for production server. I personally don't like this approach.

I hope someone from aaPanel team can comment.

aaPanel_Kern

Hello, if you can correctly manage the pgsql installed in aaPanel, you can use it

aaP_constrootoffice

aaPanel_Kern I can, and we will. I just have one question. When we go to PostgreSQL Manager and make the database permission for "everyone" - what does this mean exactly? can anyone outside the local network see this too?

aaPanel_Kern

Hello, this database allows the specified IP to access login, all IPs in everyone

aaP_constrootoffice