Testing Postgres create locally first?

Phoenix
,
1

Hi all,

I’ve just done my first deployment which failed with:

==> Release command
Command: /app/bin/migrate
	 Starting instance
	 Configuring virtual machine
	 Pulling container image
	 Unpacking image
	 Preparing kernel init
	 Configuring firecracker
	 Starting virtual machine
	 Starting init (commit: a4d425b)...
	 Setting up swapspace version 1, size = 512 MiB (536866816 bytes)
	 no label, UUID=01d81045-edac-4e9a-8900-a7e5ef0f3efb
	 Preparing to run: `/app/bin/migrate` as nobody
	 2022/07/09 14:19:43 listening on [fdaa:0:760a:a7b:bada:c74a:4a66:2]:22 (DNS: [fdaa::3]:53)
	 warning: redefining module Pento.Repo.Migrations.CreateUsersAuthTables (current version defined in memory)
	   /app/lib/pento-0.1.0/priv/repo/migrations/20220530173100_add_username_users_table.exs:1
	 14:19:46.659 [info] execute "CREATE EXTENSION IF NOT EXISTS citext"
	 14:19:46.690 [info] alter table users
	 ** (Postgrex.Error) ERROR 42P01 (undefined_table) relation "users" does not exist
	 Starting clean up.
Error Release command failed, deployment aborted

My demo app is at GitHub - ghenry/pento: Phoenix LiveView book projects

Can I reproduce this failure with a $ mix ecto.create ?

The db is up and running as this works fine:

flyctl postgres connect -a pento-ghenry-db

Thanks.