Bulk Data Transfer

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

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.

Downloading

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.

Quotas

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.