Copying PostgreSQL to cloud server

  1. 2 months ago

    William O

    Feb 16 Pre-Release Testers, Xojo Pro Texas & Minnesota

    While doing a little experimentation and learning on PostgreSQL design I realized that if this was my development MO at some point I would need to get my DB onto my Xojo Cloud server. Is this a breeze, hard but doable, mind numbingly stupid thing to try, or impossible? Should I be doing the designing on the server remotely?
    Just planning ahead......I think. Thanks!

  2. Greg O

    Feb 16 Xojo Inc Somewhere near Raleigh, NC
    Edited 2 months ago by Greg O

    What tool are you using to design your schema?

  3. William O

    Feb 16 Pre-Release Testers, Xojo Pro Texas & Minnesota

    RazorSQL mainly but have PGadmin4

  4. Greg O

    Feb 17 Xojo Inc Somewhere near Raleigh, NC

    Being that razorsql has import and export tools, why not use that?

  5. William O

    Feb 17 Pre-Release Testers, Xojo Pro Texas & Minnesota

    bare with me Greg.....I want to move just my schema to Xojo Cloud, not data....my understanding of it's export functions is that THAT is for data.

  6. William O

    Feb 17 Pre-Release Testers, Xojo Pro Texas & Minnesota

    OK, think I see it.... PostgreSQL can do an IMPORT FOREIGN TABLE so I can bring tables in from the server. Thanks, still learning.

  7. Greg O

    Feb 18 Xojo Inc Somewhere near Raleigh, NC

    Yeah. I'm using Navicat Premium and they have data and structure synchronization tools for doing just this.

  8. William O

    Feb 18 Pre-Release Testers, Xojo Pro Texas & Minnesota

    Thanks Greg. Just figured out how to get back on my Cloud (thanks Jason). Couldn't you also SFTP a copy/backup/etc of your schema or tables and then restore?

or Sign Up to reply!