search

frankcollins3 / Next-Water-App

Happy, Healthy Water Cycling App that tracks user/human fluid intake.
https://next-water-app.vercel.app
1 stars 0 forks source link

create tables in heroku psql [3:19pm] #114

Open frankcollins3 opened 1 year ago

frankcollins3 commented 1 year ago

attempting to do: UTILIZATION 0 of 20 CONNECTIONS 0 of 10,000 ROWS IN COMPLIANCE 7.6 MB DATA SIZE 👍 0 TABLES

0 TABLES ++

error: missing required flag when trying to connect to the database with the CLI ➜ Next-Water-App git:(main) ✗ heroku login › Warning: Our terms of service have changed: https://dashboard.heroku.com/terms-of-service heroku: Press any key to open up the browser to login or q to exit: Opening browser to https://cli-auth.heroku.com/auth/cli/browser/9c57651d-d697-46c7-ba03-275e4294bebf?requestor=SFMyNTY.g2gDbQAAAA05OC4xMDkuMTY2LjI2bgYA4OBMrYkBYgABUYA.prD8FAvbc1bL2ErYXZzC_4ODLubdMyUBLG9zdCMdcZs Logging in... done Logged in as fwc3rd@gmail.com ➜ Next-Water-App git:(main) ✗ heroku pg:psql postgres://njzcwvgxtvtjst:8651bba8240b1234243244ecf43f75082cc577f9723e3dc08b9eff9831ebb6e9368@ec2-44-212-250-48.compute-1.amazonaws.com:5432/d64ccvb7croo4e

› Error: Missing required flag: › -a, --app APP app to run command against › See more help with --help ➜ Next-Water-App git:(main) ✗

proposed approach: heroku CLI. (changed DATABASE_URL around a bit for safety)

frankcollins3 commented 1 year ago

➜ Next-Water-App git:(main) ✗ heroku pg:psql -a luv-water-app postgres://njzcwvgxtvtjst:8651bba8240b12f5974ecf43f75082cc577f9723e3dc08b9eff9831ebb6e9368@ec2-44-212-250-48.compute-1.amazonaws.com:5432/d64ccvb7croo4e

▸ Unknown database: postgres://njzcwvgxtvtjst:8651bba8240b12f5974ecf43f75082cc577f9723e3dc08b9eff9831ebb6e9368@ec2-44-212-250-48.compute-1.amazonaws.com:5432/d64ccvb7croo4e. Valid options are: DATABASE_URL ➜ Next-Water-App git:(main) ✗ heroku pg:psql -a luv-water-app DATABASE_URL --> Connecting to postgresql-perpendicular-76955 ▸ The local psql command could not be located. For help installing psql, see https://devcenter.heroku.com/articles/heroku-postgresql#local-setup ➜ Next-Water-App git:(main) ✗

DATABASE_URL not the actual URL. and was missing the flag that told the command in which app to perform the command to [3:24pm]

frankcollins3 commented 1 year ago

heroku pg: commands are working showing some stuff Next-Water-App git:(main) ✗ heroku pg:info -a luv-water-app === DATABASE_URL Plan: Mini Status: Available Connections: 0/20 PG Version: 15.3 Created: 2023-07-04 16:18 UTC Data Size: 7.6 MB/1.00 GB (In compliance) Tables: 0 Rows: 0/10000 (In compliance) Fork/Follow: Unsupported Rollback: Unsupported Continuous Protection: Off Add-on: postgresql-perpendicular-76955

➜ Next-Water-App git:(main) ✗

[3:27pm]