Issues with Postgres DB

I don't really understand why I am not seeing any tables in my DB.
Seeding works, but the database stays empty. Any idea what could fix this?
you are probably still just seeding your sqlite database
how would i know which db i am seeding
check your local sqlite database
that looks the same
delete it, then run the commands again, if it comes back, you are seeding your sqlite database
also, i know the cli tells you to do railway up but dont
I deleted the migrations folder and the db instance folder.
Deleted all pycache files from backend

railway run flask db init
  Creating directory /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations ...  done
  Creating directory /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/versions ...  done
  Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/script.py.mako ...  done
  Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/env.py ...  done
  Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/README ...  done
  Generating /Users/hannarosenfeld/Desktop/Code/vault-manager/backend/migrations/alembic.ini ...  done
  Please edit configuration/connection/logging settings in '/Users/hannarosenfeld/Desktop/Code/vault-
  manager/backend/migrations/alembic.ini' before proceeding.
Looking good? Run `railway up` to deploy your changes!

-- migrations folder is being created, but not database instance
railway run flask db migrate
INFO  [sqlalchemy.engine.Engine] select pg_catalog.version()
INFO  [sqlalchemy.engine.Engine] [raw sql] {}
INFO  [sqlalchemy.engine.Engine] select current_schema()
INFO  [sqlalchemy.engine.Engine] [raw sql] {}
INFO  [sqlalchemy.engine.Engine] show standard_conforming_strings
INFO  [sqlalchemy.engine.Engine] [raw sql] {}
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [sqlalchemy.engine.Engine] BEGIN (implicit)
INFO  [sqlalchemy.engine.Engine] select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname=%(name)s
INFO  [sqlalchemy.engine.Engine] [generated in 0.00032s] {'name': 'alembic_version'}
INFO  [sqlalchemy.engine.Engine] SELECT alembic_version.version_num
FROM alembic_version
INFO  [sqlalchemy.engine.Engine] [generated in 0.00033s] {}
INFO  [sqlalchemy.engine.Engine] select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where pg_catalog.pg_table_is_visible(c.oid) and relname=%(name)s
INFO  [sqlalchemy.engine.Engine] [cached since 0.3868s ago] {'name': 'alembic_version'}
INFO  [sqlalchemy.engine.Engine] SELECT c.relname FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = %(schema)s AND c.relkind in ('r', 'p')
INFO  [sqlalchemy.engine.Engine] [generated in 0.00055s] {'schema': 'public'}
INFO  [alembic.autogenerate.compare] Detected added table 'vault_manager.users'
INFO  [sqlalchemy.engine.Engine] COMMIT
  Generating /Users/hannarosenfeld/Desktop/Code/vault-
  manager/backend/migrations/versions/e90d18d95171_.py ...  done
Looking good? Run `railway up` to deploy your changes!
railway run flask db upgrade gives an error:
Postgres DB looks like this now:
(psycopg2.errors.DuplicateTable) relation "users" already exists
please fix this error before proceeding
this is where i am stuck
this error is recurring
i'm gonna drop my schema and rerun all commands in hope that fixes it
i think you should fix the problem, then your error will go away, running the same commands all day long isnt going to get you very far
i guess i don't know how to tackle this
me neither

Looking for more? Join the community!

Recommended Posts
version 'GLIBC 2.29' not foundweird error that seems to be because of my code, but it works on my computer <:bing_shrug:5837915814Use rust nightlyidk how docker works but i cant use the nightly rust dockerfile image for some reasonFix Missing libuuid LibraryHey, I am currently runnig into problems deploying my FastAPI backend after adding a new dependency I can no longer connect to my MySQL database, even after restarting the databaseI'm not sure what my project id is. My link is this: https://railway.app/project/31b9ee92-06cc-44c1-RPC showing forbidden access 403Hi. I've got some crypto related script which pings an RPC server - it works fine locally but on raiHow would I connect my project with the SQL database ?I have a model for users and I would like to populate my production DB with them. How can I do that?Hipaa/socI wanted to confirm if the information on https://railway.app/help is current as the email listed boMemory consumption differenceSame app deployed in docker local and Hw(M1 16gb) consumes 52 mb with no load railway took 74mb can Nextjs 13 Environmental variableHello! I recently installed Nextjs to try out the "new" app directory, because I heard server actioRailway CLI postgresql not installed?I installed the CLI and postgresql on my computer to use pgloader to migrate a mysql db to postgres How do I hook up my frontend correctly./I am able to deploy my backend but my frontend is not working yet. Error: ``` #8 [4/5] RUN npm ruStyling bug on project service usage pageIs there a way I can have Railway restart manually every 2 hours?Pretty self explanatory, I’m running some js codePostgres, Aspnet Core API and Angular WebguiHi guys. I'm new here and getting to know railway! I find it fantastic for us. I am lost. I would lCannot change default provider for environment thats created during GitHub Pull RequestI posted about this a while back (https://discord.com/channels/713503345364697088/112689969354953113expressidkI'm not sure on how to transfer my wiki.js database data to railway.86f37e49-db7c-4b6f-9c3e-71f5447b116a I am either getting a broken wiki.js database that results in Build and deployment is accountable in service consumptionconsider in a context of docker image number of images downloaded and each operation performed in doQuestion about billHello i have a railway acount and i work with my accounting team but they need an tax number identifEnvironment Variable Not foundI am using nodejs as a backend and the config plugin with it to get the access to the Railway envoir