Posgresql connection

almagribi

Hai, I'am new to postgresql,
I built an app using node js with postgresql database, and I dont know how to connect it in aaPanel, everything run smoothly in localhost

I created db in aaPanel

and there is not information the connection is success or not

I tried to access api, and the result shows, there is no connection to db

can you help me?

aaPanel_Kern

almagribi
Hello, is the problem solved? Please check whether the database information configured in the website program is correct?

almagribi

config is ok,
there are still error when creating table, the error permission denied for public schema

octocat

almagribi Use postgres username or add username db to superuser

almagribi

I've done it, still there is no connection to database,

but when I connected from local it works

aaPanel_Kern

Hello, I suggest you check if the configuration is correct?
Postgresql uses port 5432 by default and can only connect locally. Do you want to modify it?
From your previous screenshot, you can see if the database name and username and password are consistent. Please check

almagribi

octocat

My suggestion is to run the app on a server via ssh, you can watch what problems occur.

almagribi

I've edited
here is the new one

the problem remain the same, with external ip it connected

when upload it to aaPanel, there is no connection to database

you can check the api here https://app1.jadidalmagribi.com

and cannot requesting the data https://app1.jadidalmagribi.com/student/get

here is local external connection

aaPanel_Kern

almagribi
Please use the command to check if the database exists?
Log in:
su - postgres

enter the database
psql

Check out the database:
\l

View all database information
SELECT * FROM pg_database ORDER BY datname;

quit
\q

almagribi

are there any other steps?

aaPanel_Kern

Import database? Is it okay to connect using 127.0.0.1?

almagribi

I havent tried it, but it can restore database using remote database. I have ALTER USER nibs TO SUPERUSER;, Still it cannot connect to database from local,