Karl
DTDrizzle Team
•Created by Karl on 9/4/2024 in #help
Error when attempting to migrate on Windows
Problem was elsewhere - Next.js environment variable handling intricacies. Thanks for help anyways, @Angelelz!
14 replies
DTDrizzle Team
•Created by Karl on 9/4/2024 in #help
Error when attempting to migrate on Windows
When I change the authentication method for the Postgres server, I am also getting an wrror which tells me "Authentication failed for user '<my local system username>". This makes me wonder if something is wrong with my server config. Why does it try to connect using my local account username, when I have specifically provided a connection string which uses 'postgres' as the username? I have no idea and none of the online resources seem to answer this question either. The behaviour is the same on Linux. I have tried a clean install on macOS as well, and there the behaviour is different. Everything works as expected out of the box. I have also tried copying over the server config files (specifically pg_hba.conf and pg_ident.conf), but this does not change anything.
14 replies
DTDrizzle Team
•Created by Karl on 9/4/2024 in #help
Error when attempting to migrate on Windows
I have previously checked all of the fixes suggested in that article, none of them have fixed my issue.
14 replies
DTDrizzle Team
•Created by Karl on 9/4/2024 in #help
Error when attempting to migrate on Windows
That is not the case. I have tested that exact potential solution, but to no avail.
14 replies
DTDrizzle Team
•Created by Karl on 9/4/2024 in #help
Error when attempting to migrate on Windows
No, as can be seen in quite the beginning of my original post, the connection URL stored as an environment variable is formatted as
postgres://postgres:postgres@127.0.0.1:5432/<db_name>, meaning the user and password both are postgres14 replies