Cloudron Forum

Hello,

I'm on n8n 1.15.2 on Cloudron,

I would like to access to my n8n postgres database throgh n8n node.
What are the default Host, Database, User and Password for a fresh installation on Cloudron ?

Thanks in advance for your support

Hello,

I am using n8n with Cloudron for 1 year, along with a pro plan of n8n.io,

While I kove the cloudron verison, The update process is still very time-consuming.

on n8n.cloud pro plan, you have an interface where you can choose directly to which version you want to upgrade. in the example below I'm on v 1.91 and can upgrade straight to v1.98

But on Cloudron for now I have to go through each intermediate update. On the example below, to go from package [3.75.0] to [3.87.0] I need to go through 20 intermediate packages. And we are here with less than 3 months of updates

How can i manage to request Cloudron to make 1 single backup then automatically update to a specific package ? [3.87.0] in this case, without manually manage all intermediate updates ?

Thanks,

Ian

(EDIT): note that I'm aware of the option of automatic updates, I still want to manually decide at which time to update and to which package I want to update, to avoid service interruption at any time during the day, and control the target update package

Hi @girish ,

Thank you for taking the time to respond. I tested the proposed approach this morning and encountered a few issues, which I am sharing as potentiel feedback to improving the product:

Cloudron had to be updated before the applications (I was three versions behind), I have about ten apps, and each of my apps had to be backed up and restored between each upgrade (it took about three hours for the three upgrades), which is not insignificant downtime in terms of quality of service. Apparently, I couldn't prioritize app updates only vs cloudron updates.

Then I couldn't easily control the update by app (I have a test app and a production app, and I want to do all the updates for the test app and confirm that everything works before the production app).

I finally used the API to orchestrate my updates and everything worked very fine, apart from a weired point that I struggeled to fully understand:

I used the POST https://{cloudron_domain}/api/v1/apps/{appId}/update endpoint

{
"manifest": { }, // I left it empty
"appStoreId": "io.n8n.cloudronapp",
"skipBackup": true,
"force": true
}

With this method, the upgrade has been done directly to the latest package (I was about 20 versions behind)
Thankfully, all works well and this was the good surprise to be straight on the latest package.
Is it because I left the manifest empty ? or is it linked to the "force" parameter ?

Once again thank you for your support and this great product

Ian