I have other pods which is using same authentication as mqtt pod but those pods are able to connect to postgresdb but this mqtt pod getting below error
i tried to change pg_hba.conf for allowing all host but that i have configured in patroni section which is also not applied
How can i get the default user(postgres user) credentails
[2023-07-12 17:13:05.694 INF] File API URL: https://my-registry-test.ip.nip.io/file-api/filvol/
[2023-07-12 17:13:06.786 ERR] 28000: ****no pg_hba.conf entry for host “10.42.0.44”, user “abcduser”, database “abcddb”, no encryption at Npgsql.NpgsqlConnector.<>c__DisplayClass160_0.<g__ReadMessageLong|0>d.MoveNext()
— End of stack trace from previous location —
at Npgsql.NpgsqlConnector.<>c__DisplayClass160_0.<g__ReadMessageLong|0>d.MoveNext()
— End of stack trace from previous location —
at Npgsql.NpgsqlConnector.Authenticate(String username, NpgsqlTimeout timeout, Boolean async)
at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.ConnectorPool.AllocateLong(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlConnection.<>c__DisplayClass32_0.<g__OpenLong|0>d.MoveNext()
— End of stack trace from previous location —
at Npgsql.NpgsqlConnection.Open()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Slb.abc.Dal.Utils.DeviceTagScaleUtility.LoadDeviceTagScale(ApplicationContext dbContext) in /src/Slb.abc.Dal/Utils/DeviceTagScaleUtility.cs:line 17
at Slb.abc.Dal.DalWorker.Initialize() in /src/Slb.abc.Dal/DalWorker.cs:line 34
at Slb.abc.Mqtt.Connector.MqttConnector.Start() in /src/Slb.abc.Mqtt.Connector/MqttConnector.cs:line 46