I have a ruby on rails app deployed on fly.io with postgres using the free tier.
Using the sitemap_generatorgem I am trying to ssh into my rails app on fly.io and generate the sitemap for my app.
The command from the gem is rake sitemap:refresh which creates a sitemap.xml.gz file in the public folder.
I face two errors, most of the times the above command fails and the log states that it cannot connect to my postgres db to generate the sitemap urls from my models.
The 2 times it managed to run it showed that the sitemap was successfully created with 8 links created but it seams like the file (public/sitemap.xml.gz) is either not persisting in my app or is not created at all.
Anyone has faced this issue? I guess my question is if it is possible to create a file with ssh connection to my fly.io app.