I installed aapanel on aws and open all required port but still not able to connect postgres db with my python script working well on digitalocean but not on was

aaP_muskansingh65553 Hi, is DB open access? Is the password correct? Have you tried connecting with the official Postgres tool? Is the aws security group open on port 5432?

aaPanel_Kern Yes !! I select for Everyone

aaP_muskansingh65553 Is the port open? Is the password correct? How to answer a question? ? Check if the port is open https://dnschecker.org/port-scanner.php

aaPanel_Kern already all port opened still !! facing this issue maybe this is a bug 1 database is working and then I created new db that database not working

aaP_muskansingh65553 Hello, go to the PostgreSQL management interface to view these two permissions. At the same time, the username and database name cannot have symbols.

aaPanel_Kern Please check this Already done all things

aaP_muskansingh65553 PORT is Open

[unknown] Try changing the password, it may be that special symbols are not supported, try without symbols

aaP_muskansingh65553 Try using pgadmin https://www.pgadmin.org/

POSTGRES authentication failed for user "ANY"

aaP_muskansingh65553

aaPanel_Kern

New database showing in Client authentication but not in commandline

Already Restarted + Reloaded + server restart

aaPanel_Kern

aaP_muskansingh65553
The command line query shall prevail, which may be related to the password with the symbol. Try adding a new one.

aaP_muskansingh65553

aaPanel_Kern already added password Example@59

aaPanel_Kern

Passwords with symbols such as @ are not supported

aaP_muskansingh65553

aaPanel_Kern Working in other databases
like Gmap and Helo

aaPanel_Kern

aaP_muskansingh65553
Then you use other tools. This should be an issue with the plugin frontend

aaP_muskansingh65553

created new db
dbname - ping
username - pong
pass- pingpong

aaP_sulthanalihsan5

hi, any update for this issue?, i've facing this issue also

aaP_mailkevin

quick one, is there a way to install pgAdmin on aapanel?

aaPanel_Kern

Panels are not provided and you need to install them yourself.

aaP_tranngoctung_vcu

downgrade version postgresql to version 12.
wiil be not error

syntaxsurge

Just use all lowercase for both database name and its user, it works for me, I am using the latest version of postgres which is 16.1

« Previous Page