Hello,
You can have a look at the parameter : listen_addresses in the file
postgresql.conf.
By default the value is localhost.
Regards
Romain MAZIÈRE
romain.mazi...@sigmaz-consilium.fr
+33.535.545.085
+33.781.46.36.96
https://sigmaz-consilium.fr
Le 27/06/2023 à 16:04, Ashok Patil a écrit
Hi,
As I can see in the error message :
"localhost" (::1), port 5432 failed: FATAL: password authentication failed for
user "postgres"."
Pgadmin4 try to connect via the loopback in IPv6 (::1) and fail for postgres
user.
Have a look to pg_hba.conf, the file which describes access to postgres
ot;, "b"]'::jsonb - 1| → |["a"]|
|jsonb| |#-| |text[]| → |jsonb|
Deletes the field or array element at the specified path, where path
elements can be either field keys or array indexes.
|'["a", {"b":1}]'::jsonb #- '{1,b}'| → |["a", {}]|
Regards
