©2008-2017 David V Keeney All rights reserved.
If you are moving an existing database to RdbHost, the Bulk Transfer facility can be much quicker and easier than transfering data via inserts. If you later wish to move your data away from RdbHost, the Bulk Transfer tool will provide you a data dump that you can import elsewhere.
Uploading will accept data in any of three forms, plain text (SQL), tar archives (uncompressed), or PostgreSQL's own compressed 'custom' format.
Just choose the appropriate file field in the form, select the file, and click the [upload] button.
The bulk transfer upload buttons stream the data into the database as it uploads, without buffering it complete anywhere. If you interrupt the upload, you will have an incomplete set of tables in the database. If you retry the upload, be sure to remove all affected tables first, to avoid conflict.
The uploads use pg_restore in the background, and, except for plain text, use the --no-data-for-failed-tables option to avoid inadvertent double imports. The plain text format dumps downloaded here will include drop statements to remove tables before restoring.
Data can be exported in the same three formats as above. Just click the appropriately named link, and choose a filename. To download the plain text format, you might need to right-click and select the 'save link' option.
The plain text format is generated with drop statements to clear tables upon restoring. The other formats do not, so for those you will need to clean the destination database before uploading.
Data can be exported to your Amazon AWS S3 account, in plain-text SQL. The complete dump is exported to one Object (sometimes referred to as a 'key'), using error-checking to ensure the transfer is loss-free.
You do need to set up an account with Amazon and create a named bucket using their web console or another tool. Enter this bucket name in our S3 configuration page, with your access-key and secret.
Data can be imported from an S3 bucket to restore your database. The data from S3 is expected to be a valid PostgreSQL plain-text SQL dump.
Data transfer through the bulk transfer is limited and charged according to the normal quotas and rates, but each transfer will run to completion, even if a quota limit is hit during the transfer.