Speakers
talks and workshop sessions
Dockerize your PostgreSQL: A Step-by-Step Guide for Easy Deployment and Management
Jashanpreet Singh Abstract:
While most of you have worked with postgres, you might or might not have also come across docker.
While postgres is a powerful open-source relational database management system, Docker is a containerization tool that allows developers to package applications and dependencies into a single, portable unit.
Docker can be super helpful when spinning up a quick dev environment or more complex use cases like standard postgres installation among all your server, developer systems and more.
And you'll realize it's super easy to work with too, in this talk we'll cover:
- Basics of docker and postgres (just for refresh)
- Spinning up a postgres docker instance
- Using docker exec and psql to access the database
- Loading a large chunk of data in the database
- Building your own postgres docker image with your own extensions. modifications and more
- Creating a docker-compose file to add pgAdmin4 instance with postgres for easy dev setup
After this talk, you'll have a full understanding of how to use docker to quickly spin up new postgres instances or manage postgres in servers.
About Speaker:
Jashanpreet is a highly skilled Full Stack Developer with over 5 years of experience in developing robust applications. He has worked on a variety of projects, spanning different industries and domains. Throughout his career, Jashanpreet has consistently chosen Postgres as his primary database due to its open-source nature, outstanding performance, ease of use, and versatility in handling various use cases such as geospatial and financial data.