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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

How to PostgreSQL Database Direct Connection?

Scheduled Pinned Locked Moved Solved Baserow
8 Posts 2 Posters 486 Views
    • 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 Offline
    E Offline
    ebecker1
    wrote on last edited by
    #1

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

    1 Reply Last reply
    0
  • nebulonN nebulon locked this topic on
  • nebulonN nebulon unlocked this topic on
  • nebulonN nebulon moved this topic from Support on
  • nebulonN Offline
    nebulonN Offline
    nebulon Staff
    wrote on last edited by
    #2

    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
    0
  • E Offline
    E Offline
    ebecker1
    wrote on last edited by
    #3
    This post is deleted!
    1 Reply Last reply
    0
  • E Offline
    E Offline
    ebecker1
    wrote on last edited by
    #4
    This post is deleted!
    1 Reply Last reply
    0
  • E Offline
    E Offline
    ebecker1
    wrote on last edited by
    #5

    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?

    nebulonN 1 Reply Last reply
    0
  • nebulonN Offline
    nebulonN Offline
    nebulon Staff
    replied to ebecker1 on last edited by
    #6

    @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
    0
  • E Offline
    E Offline
    ebecker1
    replied to nebulon on last edited by ebecker1
    #7

    @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?

    nebulonN 1 Reply Last reply
    0
  • nebulonN Offline
    nebulonN Offline
    nebulon Staff
    replied to ebecker1 on last edited by
    #8

    @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
    0

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.