When I tried to connect to the database running in the docker container usingpsql, I always got an error sayingpsql: FATAL: password authentication failed for user "postgres". The issue was that the postgres docker container was using the default port5432on localhost and the PostgreSQL server ...
[tony@sqlhost ~]> psql "host=192.168.56.104 user=tony password=tony port=5432 dbname=hrdb" psql (12.4) Type "help" for help. hrdb=> \q [tony@sqlhost ~]> psql postgresql://192.168.56.104:5432/hrdb?user=tony Password for user tony: psql (12.4) Type "help" for help. hrdb=> 查看...
\set v_id value 设置参数 id =:v_id psql 传参变量到sql脚本 -v psql -h localhost -p 5432 mydb pguser -v v_id = 1 -f /var/lib/pgsql/13/test1.sql [root@s101 /home/centos]#psql-h localhost-p5432mydb pguser-c "select*frommyschema.o_ls_test;" Passwordforuserpguser: rid|na...
\set v_id value 设置参数 id =:v_id psql 传参变量到sql脚本 -v psql -h localhost -p 5432 mydb pguser -v v_id = 1 -f /var/lib/pgsql/13/test1.sql 1. [root@s101 /home/centos]#psql-h localhost-p5432mydb pguser-c "select*frommyschema.o_ls_test;" Passwordforuserpguser: ri...
helm install my-release --set postgresqlUsername=testuser,postgresqlPassword=secretpassword,postgresqlDatabase=my-database bitnami/postgresql export POSTGRES_PASSWORD export POSTGRES_PASSWORD=$(kubectl get secret --namespace default my-release-postgresql -o jsonpath="{.data.postgresql-password}" | base64...
jdoe$ psql--username=user01 --dbname=mydbPasswordforuseruser01: psql (13.2) Type "help"forhelp. mydb=>\c Youarenow connectedtodatabase "mydb"asuser"user01". mydb=>\dt Listofrelations Schema|Name|Type|Owner---+---+---+---public|some_table|table|postgres (1rows) mydb=>select*...
Solved by setting a password for the user first. In terminal sudo -u <username> psql ALTER USER <username> PASSWORD 'SetPassword'; # ALTER ROLE \q In pgAdmin **Connection** Host name/address: 127.0.0.1 Port: 5432 Maintenance database: postgres username: postgres password: XXXXXX Share...
psql -h localhost -p 5432 mydb pguser -v v_id = 1 -f /var/lib/pgsql/13/test1.sql [root@s101 /home/centos]#psql -h localhost -p 5432 mydb pguser -c "select*from myschema.o_ls_test;"Password for user pguser:rid | name | timeflag ---+---+--- 1| aa |2021...
psql(11.2)Type"help"forhelp.postgres=#1.2tcp ip登录[postgres@pg11-1~]$ psql-h192.162.152.11-p5432-Upostgres-dpostgresPasswordforuser postgres:psql(11.2)Type"help"forhelp.postgres=# 2.psql调用命令 2.1直接调用命令[postgres@pg11-1~]$ psql-c"select 'hello word';"?column?---hello word(1ro...
You can set the environment variable PGHOST=localhost: $ psql -U db_user db_name psql: FATAL: Peer authentication failed for user "db_user" $ export PGHOST=localhost $ psql -U db_user db_name Password for user mfonline: K Kenny Evitt Hmmm ... If you can connect with the use...