Postgres Transfer Data Between Databases. Again the two tables on the two different database instances must have the same structure. 22 november 2006 151400.
There are several ways to copy a database between postgresql database servers. Our dbconvertdbsync applications are simple to use solutions that will transfer and sync your data between any postgresql and mysql database servers. Copy can either copy the content of a table to or from a table.
I have a postgresql operational db with data partitioned per day and a postgresql data warehouse db.
In order to copy the data quickly from the operational db to the dwh i would like to copy the tables as fast and with least of resources used. Psql h remotehost d yourprimarydb u postgres c copy users id email firstname lastname from tmpuserscsv with delimiter as copy data using stdin to a remote database. If your source and target databases resides on different servers you can use following steps. If the size of the source database is big and the connection between the database servers is slow you can dump the source database to a file copy the file to the remote server and restore it.