This postgresql prompts that the command cannot be found.

goophps

For the postgresql in your system, when I execute various commands of psql on the command line, it prompts that the command cannot be found.

aaPanel_Kern

goophps
Hello, I did not make psql a soft link when installing postgresql
You can use absolute paths:
/www/server/pgsql/bin/psql

goophps

aaPanel_Kern What to do with soft links? Can you teach me? I do it manually. I know that the path can be added, but for many different commands, the path must be added all the time, which is very dizzy, and some have no effect after adding the path. I have been unable to fix it for a long time.

goophps

sudo -u postgres /www/server/pgsql/bin/psql
CREATE ROLE liuxiao superuser PASSWORD ‘liuxiao’ login
Then go to connect to the database, prompt: role 'liuxiao' does not exist

aaPanel_Kern

goophps
Hello, software links or environment variables can be referred to here:
https://www.postgresql.org/docs/current/install-post.html#INSTALL-POST-SHLIBS
Database access reference here:
https://www.postgresql.org/docs/current/tutorial-accessdb.html