17 days ago
i create n8n service and postgres, and in n8n service i create workflow with postgrest node, it need host url,db name,user name,password,port. at first i can connect with default user name "postgres", but when i create user name example call "newuser" and password "123456" and i can't connect to postgres service. and error show "authentication fail". when i remote login via shell, i see the user name "newuser" and db,table...
10 Replies
17 days ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
17 days ago
Is this a new user in n8n or a new user within the postgres instance?
0x5b62656e5d
Is this a new user in n8n or a new user within the postgres instance?
16 days ago
its a new user in postgres instance, and the postgrest instance setting -> database -> credentials : there is only postgres user name and password
Railway
Hey there! We've found the following might help you get unblocked faster: - [🧵 Authentication is suddenly failing for Postgres user](https://station.railway.com/questions/authentication-is-suddenly-failing-for-p-ea8590e9) - [🧵 Locked Out of Postgres After Password Change – Need Urgent Access to Data](https://station.railway.com/questions/locked-out-of-postgres-after-password-ch-a273e045) - [🧵 password authentication failed for user "postgres"](https://station.railway.com/questions/password-authentication-failed-for-user-2c51edb9) If you find the answer from one of these, please let us know by solving the thread!
16 days ago
these threads doesn't solve
16 days ago
If you wish to change the username/password or create a new pg user, you must do so via SQL queries within the database. The user/pass env vars are only used to create the user when the database is first created.
16 days ago
and after i create "new_user" from remote_cli from postgres railway instance, i can't see the new_user appearing at railway's postgres instance in dashboard, or railway its only strick to "postgres" user , its not allow for other user ?
0x5b62656e5d
If you wish to change the username/password or create a new pg user, you must do so via SQL queries within the database. The user/pass env vars are only used to create the user when the database is first created.
16 days ago
example, i create "new_user" and database "bookdb" for "new_user", but i can't login as this user via DATABASE_PUBLIC_URL (postgresql://new_user:new_user_pw@switchback.proxy.rlwy.net:22384/bookdb), n8n's postgres node ( i only can login with this "new_user" via remote cli from postgres railway instance, and in n8n can only use "postgres" crendentials)
16 days ago
could you confirm the new_user was created using the encryption method SCRAM-SHA-256
15 days ago
Per above suggestion, try checking the deploy logs for your Postgres instance and see if there are messages that say User "new_user" does not have a valid SCRAM secret.
If that's the case, you can resolve by signing in as postgres user and:ALTER SYSTEM SET password_encryption = 'scram-sha-256'; -- this changes encryption to SCRAM-SHA-256
SELECT pg_reload_conf(); -- this reloads pg with new config
alter role new_user with password '123456'; -- this sets password for user with SCRAM-SHA-256
samiam
Per above suggestion, try checking the deploy logs for your Postgres instance and see if there are messages that say User "new_user" does not have a valid SCRAM secret.If that's the case, you can resolve by signing in as postgres user and:ALTER SYSTEM SET password_encryption = 'scram-sha-256'; -- this changes encryption to SCRAM-SHA-256SELECT pg_reload_conf(); -- this reloads pg with new configalter role new_user with password '123456'; -- this sets password for user with SCRAM-SHA-256
15 days ago
appreciate for you've provide extra details bro.
Status changed to Open brody • 15 days ago