Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Enable SSL from Postgres

    Solved Support
    6
    1 Votes
    6 Posts
    70 Views
    J

    @bennyv53 I recommend using ssh then (SSL support for internal postgres will break Cloudron's setup). Is the concern security related?

  • Postgres not upgrading with 8.0.3

    Solved Support
    6
    0 Votes
    6 Posts
    98 Views
    nebulonN

    Turns out that Cloudron hit the same issue as https://forum.cloudron.io/topic/11276/cloudron-update-to-7-7-0-postgresql-does-not-start?_=1723244919333 and the fixed worked there also.

  • Customize PostgreSQL settings/limits

    Solved Support
    6
    1 Votes
    6 Posts
    393 Views
    M

    @girish perfect, thanks - appreciate it! I'm almost certain there could be ways to improve those queries, but it's always better to have a failsafe in place 😉

  • How to debug Postgresql used by custom app

    Solved Support
    4
    1 Votes
    4 Posts
    290 Views
    nebulonN

    The current addon uses 14.9 so I guess you could run the corresponding image from https://hub.docker.com/_/postgres

  • 0 Votes
    4 Posts
    170 Views
    S

    @girish thank you, I tried it several times and it didn't worked. I tried it a last time and it worked.
    I don't know why but thank you 🙂

  • Redash restore failure

    Moved Solved Support
    6
    0 Votes
    6 Posts
    546 Views
    girishG

    This was a bug in 7.4.0 and is now fixed in 7.4.1.

    We updated node to v18 (from v16). There was a subtle but impact change hidden... In node 16, the requestTimeout was 0. This meant unlimited time. In node 18, the requestTImeout is now 5 mins. This meant that large restores were failing if the upload didn't finish within 5 mins.

  • 1 Votes
    3 Posts
    381 Views
    girishG

    @roofboard said in Chat woot cannot uninstall after breaking the backup system.:

    Mar 30 20:19:30 box:services Backing up postgresql
    Mar 30 20:29:30 box:services pipeRequestToFile: timeout - connect or post-connect idle timeout

    It seems somehow postgresql was not having a happy time. Maybe give it a bit more memory (Services -> PostgreSQL -> increase memory limit). The reboot probably just freed up some memory.

  • Can I access a postgres database of an app from outside?

    Solved Support
    19
    0 Votes
    19 Posts
    3k Views
    girishG

    I have given these stable IPs now - https://git.cloudron.io/cloudron/box/-/commit/582994b9d646989b42e27dde1ae0c27bbb964834

  • What does this error mean?

    Solved Support
    3
    0 Votes
    3 Posts
    339 Views
    S

    @girish It's up now, and all the errors have disappeared.

  • Stuck on "restoring addons"

    Solved Support
    8
    0 Votes
    8 Posts
    511 Views
    W

    Thanks, it works.

  • Docker and Postgres refuse to start

    Solved Support
    15
    0 Votes
    15 Posts
    1k Views
    timconsidineT

    @girish many thanks !

  • Postgress Restart loop after upgrade

    Solved Support
    2
    1 Votes
    2 Posts
    282 Views
    nebulonN

    Not sure why that slipped through. Is this sorted by now? We had a case where slow I/O caused the issue resulting in a timeout. Could this have been the case? https://forum.cloudron.io/topic/4780/postgresql-database-won-t-start/8

  • postgresql configuration / slow log

    Moved Solved Support
    8
    1 Votes
    8 Posts
    813 Views
    marcusquinnM

    Sounds good. Yes, we're happy to help with query optimisation in apps and send feedback upstream. This is the quickest way we can do that. With some luck, we'll all end up with faster apps from this R&D too.

  • 0 Votes
    7 Posts
    640 Views
    B

    @girish I saw no red indicators on the nav bar. I guess that would have helped me towards the source of the problem. But I will keep an eye if a service gets into trouble again.

  • Disk usage issues

    Solved Support
    6
    0 Votes
    6 Posts
    562 Views
    infogulchI

    Ok, finally sorted after stopping queries that were locking old txnids and then doing a full vacuum. I suppose restarting the postgres container could have done that.

    This was useful to find blocking queries, in addition to pg_terminate_backend:

    SELECT pid, datname, usename, state, backend_xmin, query FROM pg_stat_activity WHERE backend_xmin IS NOT NULL ORDER BY age(backend_xmin) DESC;

    Went from 88% full to 38% full in about 10 minutes.

  • 0 Votes
    9 Posts
    858 Views
    A

    @nebulon I didn't get any notifications in the dashboard for OOM which is why debugging was fairly unintuitive.

    @girish If I encounter it again, I'll check dmesg and let you know.

  • Mastadon installation on Linode from Cloudron

    Support
    2
    0 Votes
    2 Posts
    318 Views
    BrutalBirdieB

    @debossnow

    Do I have to install a particular ADMIN PosgreSQL tool in my Cloudron application to see & administer this Mastadon database?

    You can use the Weberminal to get shell like access.
    On the top there will be button for Database access.

    And to see all my files & their paths in a UI do I need to install a separate directory or file browser in my Cloudron application?

    Like the Web Terminal you can use the File Manager to see your files.
    The path in the File Manager is always /app/data/.

  • Nextcloud not responding and will not update

    Solved Support
    5
    0 Votes
    5 Posts
    589 Views
    P

    @privsec That worked, thanks!

  • Postgres root login info?

    Solved Support
    7
    0 Votes
    7 Posts
    1k Views
    C

    @girish I use DBeaver with an SSH tunnel. I just found an option that I forgot to toggle on -- "Show all databases".

    Now it shows all the databases!

    On a side note, I did first try to configure an SSH tunnel and a post-command to execute "/usr/local/bin/docker exec -ti postgresql bash" and that worked as well.

    But, only one tunnel is needed to the cloudron server to login as root that allows access to all databases.

    I'm good to go. Thanks for the help!

  • Nextcloud not responding

    Solved Nextcloud
    3
    0 Votes
    3 Posts
    494 Views
    timconsidineT

    @murgero Thank you
    Before seeing this, I decided to be a 'windows user' and reboot the cloudron server.
    I guess same effect, but will definitely do your more limited kick next time.
    And yes it is working again.
    Many thanks