Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2015
    Posts
    1

    Unanswered: Transferring Data to another Databases via Internet betwee between two Locations

    Hi guys,

    Greetings!

    I would like to ask help for connecting and sending data to PostgreSQL Server via Internet.

    I am working in a project right now and I would like to ask a help on how to send data to POSTGRESQL Server in from different locations.
    I have to send the data via Internet.

    The set up is this, I have to send data from the extension branch (which also has a postgreSQL in local area) to main office where the main server PostgreSQL is located.

    How do I send the data to main server via internet?

    For additional information, I am using C# in this development and PostgreSQL is my backend database.
    The main server OS is windows server 2012 and the extension branch OS is windows XP.

    The router has already configure for portforwarding because of camera system.

    I highly appreciate in great help.

    THANK YOU IN ADVANCE..
    Last edited by danecaracena; 12-26-15 at 10:40.

  2. #2
    Join Date
    Nov 2015
    Posts
    6
    You may wish to look at foreign data wrappers.

    In your Postgres server at your extension branch you would define the connection settings for the database server in your main office as described here:
    http://www.postgresql.org/docs/curre...ateserver.html

    Now the database server in your extension branch can 'connect' to the database server in your main office you can proceed to define a 'foreign table' in the extension branch which matches the table you wish to connect to in your main office:
    http://www.postgresql.org/docs/curre...eigntable.html

    Now, at the your extension branch, you can INSERT into this foreign table in the regular way but the data will be sent over the internet to the Postgres server in the main office.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •