Windows Installation Failing | PostgreSQL Initialization Error

[n4ze3m]

Windows Installation Failing | PostgreSQL Initialization Error

[jmanhype]

Environment variables loaded from .env
Prisma schema loaded from schema.prisma
Datasource "db": PostgreSQL database "dialoqbase", schema "public" at "postgres:5432"

Error: P1001: Can't reach database server at postgres:5432

Please make sure your database server is running at postgres:5432.
PS C:\Users\strau\dialoqbase\server\prisma>

[jmanhype]

thank you for being up and working ive been tryin to get to work all night nothing is working right now I even tried to run my own postgres server but it wont allow me to run it in the docker file keeps saying is this server running.
when I user your settings I get this Invalid prisma.user.findFirst() invocation: The table public.User does not exist in the current database.

when I did on my own I Tried to The Prisma schema you've shared seems correct and the User model is defined. There could be a few reasons why you're still seeing the error message that the User table does not exist.

Here's a few possible reasons and their solutions:

1. Database migration hasn't been run yet: Prisma doesn't automatically create tables in your database when you define models in the schema. It requires you to run a migration. If you haven't done that yet, here's how:

   npx prisma migrate dev --name init

   This command will create a new migration, and apply it to your database. The --name init is optional and gives the migration a name ("init" in this case).

2. Database URL might be incorrect: Please ensure that the DATABASE_URL environment variable is pointing to the correct database. Check the .env file or wherever you're storing your environment variables.

3. Wrong schema or database: If you're using Postgres and have multiple schemas or databases, ensure that you're using the right one. The default schema for Postgres is public.

If you've already run a migration and the table still isn't appearing, there might be an issue with the database connection or the migration itself. Check the output of the migration command for any error messages or warnings. Also, ensure you're looking at the right database and schema if you're inspecting the database manually.

[n4ze3m]

I have created a custom PostgreSQL image with an "init.sh" script that resolves the Windows installation bash error. I recommend pulling the latest repository and giving it another try. I apologize for not testing Docker on Windows myself.

[jmanhype]

thank you very much its working 👯