Does your company or startup need an expert? If so, write to me to talk about possibilities of professional cooperation.
PROGRAMMING on-line course is approaching! Write to me if you are interested in free early access.

MARCIN.com

Marcin Jamro, PhD, DSc

How to download PostgreSQL database from DigitalOcean?

Infrastructure

Let's perform the following steps:

Step 1. Add your IP address to Trusted Sources in the database configuration on DigitalOcean.
Step 2. Install pgAdmin from https://www.pgadmin.org.
Step 3. Open Command Prompt and run the following two commands: 

cd "c:\Program Files\PostgreSQL\15\bin"
pg_dump.exe -h HOST -p PORT -U USER -W -F p -d DNAME > OUTPUT

You need to replace:

  • HOST with a host name from the database configuration,
  • PORT with a port number from the database configuration,
  • USER with a user name from the database configuration, e.g.: doadmin,
  • DNAME with a database name from the database configuration, e.g.: defaultdb,
  • OUTPUT with a path to the output file, e.g.: C:\db.sql

The content, including any part of code, is presented without warranty, either express or implied. The author cannot be held liable for any damages caused or alleged to have been caused directly or indirectly by any content shown on this website.

Hello, I am Marcin

Reliable entrepreneur with 10+ years of companies operation, such as CEO at a few IT companies. I was an author of a few software & hardware products, still open to new ideas & cooperation.

Helpful expert with 10+ years of experience, together with PhD and DSc in Computer Science. I was an author of books and publications, as well as an expert in international projects.

Experienced developer with 10+ years of development and 100+ completed projects. I worked on various complex international projects, e.g. at Microsoft in USA and as CTO at a few companies. I have MCP, MCTS and MCPD certificates.

You can read more about me in my short bio. I am waiting for contact at [email protected], as well as at my Facebook and LinkedIn profiles.

Books

I am an author of a few books and numerous publications, also in high-quality international scientific journals.

If you want to learn data structures and algorithms in the context of C#, let's take a look at my newest book. It is the second edition of C# Data Structures and Algorithms. You can buy it here.

Projects

Do you like traveling? If so, discover an amazing world with local guides, right here and right now at: https://camaica.com

Travels

I love travels, learning new cultures and regions, meeting outstanding people, as well as taking pictures of beautiful places. Take a look at my travel diary.