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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved How to PostgreSQL Database Direct Connection?

    Baserow
    2
    8
    421
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • E
      ebecker1 last edited by

      Installed the Baserow app, how do I connect directly to the PostgreSQL database? Thank you.

      1 Reply Last reply Reply Quote 0
      • Locked by  nebulon nebulon 
      • Unlocked by  nebulon nebulon 
      • Moved from Support by  nebulon nebulon 
      • nebulon
        nebulon Staff last edited by

        Are you trying to connect to some external Postgres database or the internal one for the app?
        For the internal one you can open a webterminal into the app from your Cloudron dashboard and you will find a postgres button on the top right.

        1 Reply Last reply Reply Quote 0
        • E
          ebecker1 last edited by

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • E
            ebecker1 last edited by

            This post is deleted!
            1 Reply Last reply Reply Quote 0
            • E
              ebecker1 last edited by

              Thanks, I found the postgre terminal from the cloudron dashboard.

              However, I'd like to import large amounts of data into my Baserow database, how can I upload a CSV file and get it loaded into a table? Maybe I need to load the file somewhere and then reference it in a command to copy it to table?

              nebulon 1 Reply Last reply Reply Quote 0
              • nebulon
                nebulon Staff @ebecker1 last edited by

                @ebecker1 hm this may probably more of an baserow application question. Have you looked into their documentation how to import large data sets and what the best option for this is?

                E 1 Reply Last reply Reply Quote 0
                • E
                  ebecker1 @nebulon last edited by ebecker1

                  @nebulon
                  Seems I need a direct connection to the database, but I don't know how to reference the load file via the cloudron webterminal.

                  To load data into a PostgreSQL database I can run this from the command line:
                  \COPY "[table]"([field1],[field2],[field3]) FROM '[file location]' DELIMITER ',' CSV HEADER;

                  How and where, do I load and specify [file location], on cloudron?
                  Can I connect from my PC to the database directly and then be able to reference a file on my machine? Maybe via Cloudron CLI?

                  nebulon 1 Reply Last reply Reply Quote 0
                  • nebulon
                    nebulon Staff @ebecker1 last edited by

                    @ebecker1 there is no easy way to connect to the database from outside. However I am not sure at all if your approach here is correct. I would assume the app has better ways to import data besides tinkering with the underlying database as that seems quite the risky operation and might break the app itself.

                    1 Reply Last reply Reply Quote 0
                    • First post
                      Last post
                    Powered by NodeBB