Hi, I am using Blues Stack which works great on my local. I am able to successfully deploy to the staging environment as well but I need to have some data to be able to test it properly.
I am trying to run Prisma seed using local proxy but failing to do so. I tried to use local proxy using the command flyctl proxy 5432 -a guerdon-v2-staging-db which runs successfully but it seems that its not working. When I try to test it via psql postgres://postgres:postgres@localhost:5432 it works but I see the data on my local machine and when I connect it via psql postgres://postgres:<password>@localhost:5432 it fails with the following command.
psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"
Thanks for pointing that out, since Blues Stack needs to run a Docker, I stopped the docker and now I am able to connect to the Db using psql but I am not able to run any prisma specific command. For example I want to see the data but its hangs without any output.
npx prisma db push
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database <name >, schema "public" at "localhost:5432"
I am currently using staging environment and .env contains the credentials for the same. I am not what can be better alternative to populate the DB with seed values.
No, it just loaded schema from local schema definition. I am still stuck and cannot make any progress so far. So, I see the same issue with pgadmin as well, while trying to add a new server the pgadmin hangs trying to connect. I am not sure what is going on as I am able to connect via psql from command line.