Wasp•14mo ago•

15 replies

Manipulating production database with fly.io and wasp db studio

@kapa.ai
I used the Wasp CLI to deployed my db (

skyblaze-db

skyblaze-db

). I followed the tutorial by:

Run

 fly proxy 5432 -a skyblaze-db

 fly proxy 5432 -a skyblaze-db

and got

Proxying local port 5432 to remote [skyblaze-db.internal]:5432

Proxying local port 5432 to remote [skyblaze-db.internal]:5432

Put

DATABASE_URL

DATABASE_URL

in my

.env.server

.env.server

DATABASE_URL=postgres://postgres:<password>@localhost:5432/skyblaze-db

DATABASE_URL=postgres://postgres:<password>@localhost:5432/skyblaze-db

However I got

❌ --- [Error] Can not connect to database: ---------------------------------------

The database needs to be running in order to execute this command. You can easily start a managed dev database with `wasp start db`.

❌ --- [Error] Can not connect to database: ---------------------------------------

The database needs to be running in order to execute this command. You can easily start a managed dev database with `wasp start db`.

When I run

wasp db studio

wasp db studio

.

My question is:

1. is the database password something I got when first deployed to fly.io, with 15 characters? I got the message

Postgres cluster skyblaze-db is now attached to skyblaze-server
The following secret was added to skyblaze-server:
  DATABASE_URL=postgres://skyblaze_server:<credential>@skyblaze-db.flycast:5432/skyblaze_server?sslmode=disable
Please take note of your database credentials above, as they will not be available in plaintext again. Press any key to continue.

Postgres cluster skyblaze-db is now attached to skyblaze-server
The following secret was added to skyblaze-server:
  DATABASE_URL=postgres://skyblaze_server:<credential>@skyblaze-db.flycast:5432/skyblaze_server?sslmode=disable
Please take note of your database credentials above, as they will not be available in plaintext again. Press any key to continue.

2. If so, which sould be correct?

DATABASE_URL=postgres://postgres:<credential>@localhost:5432/skyblaze-db

DATABASE_URL=postgres://postgres:<credential>@localhost:5432/skyblaze-db

DATABASE_URL=postgres://skyblaze_server:<credential>@skyblaze-db.flycast:5432/skyblaze_server?sslmode=disable

DATABASE_URL=postgres://skyblaze_server:<credential>@skyblaze-db.flycast:5432/skyblaze_server?sslmode=disable

3. How should I fix the

❌ --- [Error] Can not connect to database: ---------------------------------------

The database needs to be running in order to execute this command. You can easily start a managed dev database with `wasp start db`.

❌ --- [Error] Can not connect to database: ---------------------------------------

The database needs to be running in order to execute this command. You can easily start a managed dev database with `wasp start db`.

?

Thanks!

Wasp•14mo ago•

15 replies

William Jin

Manipulating production database with fly.io and wasp db studio

@kapa.ai
I used the Wasp CLI to deployed my db (

skyblaze-db

skyblaze-db

). I followed the tutorial by:

Run

 fly proxy 5432 -a skyblaze-db

 fly proxy 5432 -a skyblaze-db

and got

Proxying local port 5432 to remote [skyblaze-db.internal]:5432

Proxying local port 5432 to remote [skyblaze-db.internal]:5432

Put

DATABASE_URL

DATABASE_URL

in my

.env.server

.env.server

DATABASE_URL=postgres://postgres:<password>@localhost:5432/skyblaze-db

DATABASE_URL=postgres://postgres:<password>@localhost:5432/skyblaze-db

However I got

❌ --- [Error] Can not connect to database: ---------------------------------------

The database needs to be running in order to execute this command. You can easily start a managed dev database with `wasp start db`.

❌ --- [Error] Can not connect to database: ---------------------------------------

The database needs to be running in order to execute this command. You can easily start a managed dev database with `wasp start db`.

When I run

wasp db studio

wasp db studio

.

My question is:

1. is the database password something I got when first deployed to fly.io, with 15 characters? I got the message

Postgres cluster skyblaze-db is now attached to skyblaze-server
The following secret was added to skyblaze-server:
  DATABASE_URL=postgres://skyblaze_server:<credential>@skyblaze-db.flycast:5432/skyblaze_server?sslmode=disable
Please take note of your database credentials above, as they will not be available in plaintext again. Press any key to continue.

Postgres cluster skyblaze-db is now attached to skyblaze-server
The following secret was added to skyblaze-server:
  DATABASE_URL=postgres://skyblaze_server:<credential>@skyblaze-db.flycast:5432/skyblaze_server?sslmode=disable
Please take note of your database credentials above, as they will not be available in plaintext again. Press any key to continue.

2. If so, which sould be correct?

DATABASE_URL=postgres://postgres:<credential>@localhost:5432/skyblaze-db

DATABASE_URL=postgres://postgres:<credential>@localhost:5432/skyblaze-db

DATABASE_URL=postgres://skyblaze_server:<credential>@skyblaze-db.flycast:5432/skyblaze_server?sslmode=disable

DATABASE_URL=postgres://skyblaze_server:<credential>@skyblaze-db.flycast:5432/skyblaze_server?sslmode=disable

3. How should I fix the

❌ --- [Error] Can not connect to database: ---------------------------------------

The database needs to be running in order to execute this command. You can easily start a managed dev database with `wasp start db`.

❌ --- [Error] Can not connect to database: ---------------------------------------

The database needs to be running in order to execute this command. You can easily start a managed dev database with `wasp start db`.

?

Thanks!

Manipulating production database with fly.io and wasp db studio

Similar Threads

Manipulating production database with fly.io and wasp db studio

Similar Threads

Similar Threads

Similar Threads