025-01-09T06:00:32.027 app[328790ec969028] iad [info] PostgresError: relation "profile" does not exist
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] at ErrorResponse (file:///app/node_modules/postgres/src/connection.js:788:26)
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] at handle (file:///app/node_modules/postgres/src/connection.js:474:6)
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] at TLSSocket.data (file:///app/node_modules/postgres/src/connection.js:315:9)
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] at TLSSocket.emit (node:events:518:28)
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] at addChunk (node:internal/streams/readable:561:12)
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] at Readable.push (node:internal/streams/readable:392:5)
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] at TLSWrap.onStreamRead (node:internal/stream_base_commons:191:23) {
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] severity_local: 'ERROR',
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] severity: 'ERROR',
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] code: '42P01',
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] position: '47',
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] file: 'parse_relation.c',
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] line: '1449',
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] routine: 'parserOpenTable'
2025-01-09T06:00:32.027 app[328790ec969028] iad [info] }
I recently started using fly.io postgres with my application. It works perfectly fine when I run it on my local using fly proxy for the database but when I moved to deploying the svelte app onto fly it is throwing the error above. The connection string I am using is following the convention shown in the docs:
postgres://{username}:{password}@{hostname}:{port}/{database}?options
All I did to change it from how the string looked in local is to change hostname from localhost to the hostname of the db. It seems to be connecting fine for all of the other tables just not the profiles table I have. I’m looking for any assistance anyone can provide. Thanks in advance.