Skip to content

Local development documentation for Step 2 does not work #7886

@stevepiercy

Description

@stevepiercy

Description

After successfully walking through the Quickstart for Prisma Postgres at https://www.prisma.io/docs/prisma-orm/quickstart/prisma-postgres, I then tried Local development at https://www.prisma.io/docs/postgres/database/local-development. I was able to complete Step 1, and submitted a PR to update the docs to reflect the current situation in #7874. Note that I used pnpm, not npx.

However, I'm not able to complete Step 2. I'm using the same project as that from the Quickstart, with the exception of changing the .env DATABASE_URL to that from Step 1.

Here's the console output from Step 2:

$ pnpm dlx prisma migrate dev            
Loaded Prisma config from prisma.config.ts.

Prisma schema loaded from prisma/schema.prisma.
Datasource "db": PostgreSQL database "template1", schema "public" at "localhost:51214"

Error: P1017
Server has closed the connection.

And I checked whether the server was in fact running.

$ pnpm dlx prisma dev ls                         
Loaded Prisma config from prisma.config.ts.

Fetching latest updates for this subcommand...
npm notice
npm notice New minor version of npm available! 11.6.0 -> 11.14.0
npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.14.0
npm notice To update run: npm install -g npm@11.14.0
npm notice
 name     status   urls                                                                                                                                                                        
 default  running  DATABASE_URL:                                                
                   prisma+postgres://localhost:51213/?api_key=eyJk...AifQ 
                   STREAM: http://127.0.0.1:51216/v1/stream/prisma- 
                   wal                                                    
                   TCP:                                                         
                   postgres://...@localhost:51214/... 
                   Terminal: ...psql -h       
                   localhost -p 51214 ...                                 

I've also asked for support for Step 2 on Discord at https://discord.com/channels/937751382725886062/1501160844875268226/1501160844875268226.

Please let me know if you need further clarification, or if I should try something else.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions