R
Railway

✋|help

Issues with Postgres DB

AAda238/24/2023
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?
AAda238/24/2023
3b4c3c14-6b11-4e8a-8f52-bb11ff2f2554
Bbrody1928/25/2023
you are probably still just seeding your sqlite database
AAda238/25/2023
how would i know which db i am seeding
Bbrody1928/25/2023
check your local sqlite database
AAda238/25/2023
that looks the same
Bbrody1928/25/2023
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
AAda238/25/2023
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!
AAda238/25/2023
railway run flask db upgrade gives an error:
AAda238/25/2023
Postgres DB looks like this now:
Bbrody1928/25/2023
(psycopg2.errors.DuplicateTable) relation "users" already exists
please fix this error before proceeding
AAda238/25/2023
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
Bbrody1928/25/2023
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
AAda238/25/2023
i guess i don't know how to tackle this
Bbrody1928/25/2023
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