Transferring Data Between PostgreSQL Docker Containers

Transferring Data Between PostgreSQL Docker Containers

Docker containers provide an efficient way to package, distribute, and run applications, including databases like PostgreSQL. Often, you may need to transfer data from one PostgreSQL container to another, either for backup, migration, or testing purposes. In this guide, we'll walk through the process of transferring data between PostgreSQL Docker containers.

Prerequisites

  • Basic understanding of Docker and PostgreSQL.
  • PostgreSQL Docker containers already running.

Step 1: Export Data from the Source Container

First, we need to export the data from the source PostgreSQL Docker container. We'll use the pg_dump tool for this purpose.

docker exec -it <source_container_name> bash
pg_dump -U <username> -d <database_name> > /path/to/export/dump.sql
exit

Replace <source_container_name>, <username>, <database_name>, and /path/to/export/dump.sql with appropriate values. This command exports the database to a SQL dump file.

Step 2: Copy the Dump File to the Destination Container

Next, copy the SQL dump file from your local machine to the destination PostgreSQL Docker container using docker cp.

docker cp /local/path/dump.sql <destination_container_name>:/path/to/dump.sql

Replace /local/path/dump.sql with the path to the SQL dump file on your local machine and <destination_container_name> with the name of the destination PostgreSQL Docker container.

Step 3: Restore Data in the Destination Container

Access the destination Docker container and restore the database from the dump file using psql.

docker exec -it <destination_container_name> bash
psql -U <username> -d <database_name> -f /path/to/dump.sql
exit

Replace <username>, <database_name>, and /path/to/dump.sql with appropriate values. This command restores the database using the SQL dump file.

Step 4: Verify and Test

After the restoration process completes, verify that the data has been successfully transferred by querying the database in the destination container. You can also test the functionality of your application to ensure everything works as expected.

Conclusion

Transferring data between PostgreSQL Docker containers is a straightforward process using tools like pg_dump and psql. Whether you're migrating data, setting up a testing environment, or creating backups, Docker makes it easy to manage your PostgreSQL databases efficiently.

By following the steps outlined in this guide, you can seamlessly transfer data between PostgreSQL Docker containers with confidence.

Location: Auckland, New Zealand

Comments

Post a Comment

Popular posts from this blog

Unsupervised Learning

Image
In unsupervised learning, we are provided with a dataset and nothing else. There is no outputs, parameters or anything to distinguish the given data. Our aim is to let the machine to learn or create a grouping/classification on its own. Unsupervised learning is comparatively difficult with respect to supervised learning. Consider social networking sites, based on our actions they are filling our feed with posts/media that we would prefer, suggests people we want to follow and a lot of things. These kinds of solutions are done using unsupervised learning. In the figure, social media users are grouped by machine based on some factors which are unknown to the programmer. This could be a simple example of unsupervised learning.
Read more

Automate Blog Post creation using Blogger APIs and Python

Image
This article will discuss the following topics, Blogger's REST APIs. Google's OAuth 2.0 playground. Accessing spreadsheet in Python. Creating blogger posts via Python. An experiment to automate blog post creation when you have structured data. I was searching for IFSC codes for some bank transactions and came across Reserve Bank's website, which has a list of Excel files containing Bank Codes, Contact Info and related details of each bank's branch. This time I will be looking towards Bharat co-operative bank of Mumbai. Here is how the corresponding data looks like. In the above picture, each row represents lots of details about each branch of the Bank. Let's think of creating a list of blog posts where each post gives IFSC codes of a particular branch along with address and contact details. As the first step, I have created a blog in blogger. In the Blogger dashboard, please also note the parameter called blog ID which is a kind of unique identifier
Read more

Setting up Python Flask server on internet via Port forwarding

Image
In this post we will cover topics; Starting a server using Python Flask. Accessing server in Local Network. Adding a Port Forwarding rule in NAT settings. Accessing server in Internet via public IP. Difference between static IP and dynamic IP. Step 1 :- As the first step, we need to setup a server on our system.A server exposes your code to a particular port.Some examples are Apache Tomcat, Spring boot (inbuilt), Python Django (inbuilt), Nginx. Here we have a simple server in Python Flask. For a GET request in root path the server returns a "Hello World!".That's it. Going to start the server on my local IP address(192.168.1.105) at default flask port(5000) using below commands, $export FLASK_APP=flaskTest.py $flask run  --host=192.168.1.105 Step 2 :- For security purpose all ports for external communication is closed by router's firewall by default. So no communication can be done to outside world. For same reason our server won't be
Read more

The beginning of Data Quest

***** Work In Progress ******* Ever since I entered to IT industry, I was hearing about data science machine learning and the miracles happened because of these. On curiosity, I too have started learning some the concepts on these areas. As the first step, I have enrolled in Andrew N G's Machine Learning course. I will be sharing things I have learned in this blog and consider this post as an Index for my learning. Good Luck!!! Definition of Machine Learning  Supervised Learning Linear Regression Cost Function Gradient Descent Unsupervised Learning
Read more

Setting up Jupyter Lab integrated with Python, Julia, R on Windows Subsystem for Linux (Ubuntu)

Image
Every guy gotta favourite OS. But, due to some constraints, all can't use that all the time. Being a Linux user, I had to shift to Windows 10 because of the barrier by MS Office and Dual booting often doesn't work. A few weeks before I learned about Windows Subsystem for Linux and my experience was great. If you are Linux pro stuck in Windows, this could be a relief. Basically, you can run a well-designed minimal version of Ubuntu inside Windows 10. In this article, we will get familiar with, Activation of Windows Subsystem for Linux. Installation of Ubuntu (no GUI) using Microsoft App Store. Configuring Python3, Pip3 and Jupyter Lab. Installation of R in Ubuntu and integration of R with Jupyter Lab. Installation of Julia in Ubuntu along with Jupyter Lab integration. Accessing Windows files with Ubuntu. Installation of Windows Subsystem for Linux Windows don't ship with WSL by default, we need to install it via PowerShell.  Reference -  https://docs.microsoft.co
Read more