PostgreSQL Import 🚀 - Transfer data between PostgreSQL databases easily.

Description

Node script to transfer data between PostgreSQL databases easily. 🛠️

How to use

$3

This is necessary for the --rows-per-insert command from pg_dump to work.

$3

Add the path to your PostgreSQL "bin" folder to the "Path" system environment variable.
Note: in my case, it is located in "C:\Program Files\PostgreSQL\12\bin".

$3

Click here to access the Node.js page and download.

$3

Run the command (only if you haven't started npm in your project yet):

``bash
npm init
`

Run the command below:

`bash
npm install @rafaelcecchin/pg-import
`

$3

Create a file called pg-import.config.js in the root of your project.

Below I present an example:

`javascript
module.exports = {
'db': {
'erp-prod': {
name: process.env.PROD_ERP_NAME,
port: process.env.PROD_ERP_PORT,
host: process.env.PROD_ERP_HOST,
user: process.env.PROD_ERP_USER,
pass: process.env.PROD_ERP_PASS
},
'erp-dev': {
name: process.env.DEV_ERP_NAME,
port: process.env.DEV_ERP_PORT,
host: process.env.DEV_ERP_HOST,
user: process.env.DEV_ERP_USER,
pass: process.env.DEV_ERP_PASS
}
},
'import': {
'import1': {
'source': 'erp-prod',
'destination': 'erp-dev',
'tables': [
'rotas'
],
'create-db': true,
'encode': 'LATIN1',
'rows-per-insert': 5000,
'template': 'template0',
'lc-collate': 'C',
'lc-ctype': 'C'
},
'import2': {
'source': 'erp-prod',
'destination': 'erp-dev',
'tables': [
'clientes'
],
'create-db': false,
'encode': 'LATIN1',
'rows-per-insert': 5000
}
}
}
`

Import args 📋
- source: Source database
- destination: Destination database
- tables: Tables to transfer
- create-db: Create database
- encode: Set the database encoding
- template: Set the database template
- lc-collate: Set the database collate
- lc-ctype: Set the database ctype
- ignore: Inform that they should be ignored during export
- before-schema: Scripts to run before schema import
- after-schema: Scripts to run after schema import
- before-data: Scripts to run before data import
- after-data: Scripts to run after data import
- rows-per-insert: Number of rows per insert
- only-restore: Just restore, without doing DUMP
- only-dump: Only DUMP, without restoring
- rm: Auto remove backup files

$3

Now that everything is configured, you can use bash to make transfers between databases.

`bash
node node_modules/@rafaelcecchin/pg-import/pg-import.js
`

Alternatively, you can streamline the process by adding the following script to your package.json:

`json
"scripts": {
"import": "node node_modules/@rafaelcecchin/pg-import/pg-import.js"
}
`

Then, you can run the transfer command with:

`bash
npm run import
``

$3

Although this script facilitates data transfer between PostgreSQL databases, the process can be improved.
Collaborate with this small project, make a pull request. 🤝