In this tutorial you'll learn: ✅ How to take a backup in pgAdmin 4 (Backup dialog walkthrough) ✅ The real difference between Plain, Custom, Tar, and Directory formats ✅ Why a "Custom" backup opens as unreadable binary (PGDMP) text ✅ How to restore a database correctly — and why the Restore format must match your Backup format ✅ A common Windows file-picker issue that hides your .sql file (and the 10-second fix)
This video provides a step-by-step tutorial on how to perform backup and restore operations for a PostgreSQL database using the pgAdmin 4 tool. The instructor demonstrates how to export a database to a shareable file and how to import that file into a new database to recover all tables and data.
Hello, what's up, guys?
Welcome to all of you
Postgres SQL series
Today in this video, we will see
How to take a backup
And restore it
In your
PG Admin 4
Yeah, guys
Because this series of yours
You're almost 70%
It has been completed.
And every video of
You can see it at the bottom.
Here I am sending the link
And even
Describe me too
You receive the link.
If you clicked on it
Inside him
Source code
Notes
You will get everything.
As download
From Google Drive
When you come here
Everything is here.
No way
But still like that
Most people know
Jinko a little bit
Having a problem
Hey, aren't you guys?
Hello there
Solve this problem
For the sake of the sacrifice
Main aaj aapko
Potato hu
Proper way
In what way?
A proper backup
And restore
You can believe it
Look
Meena after a while
We are starting the video
This is my database.
Teké
Basically
What I have is mine.
Actual database
College administration
I have a database.
Inside him
We have a schema
And then their
Public folder
Inside him
We have this.
Tables
Inside the tables
You can see
In total we have
How much
8 tables
Right now
To aapne clearly
Seen that
We have a total of
8 tables
And you his
There is content.
Basically
Here
We have all the data
It has happened.
A to Z
Previously
What was I doing?
Copy
And then paste
Done.
But you all
The problem remains.
The proper way
Look
Backup
First of all
How to take it
Well, us
With someone else
Can share
With Dooston
You can share it
And perhaps
With you all
I will share
Look
First of all
Backup
What is Karna?
You have the complete
You backed it up
Right
To
Here
Clearly
You can see
What is this?
Your
Name of the database
This is it.
That's yours
College administration
Right-click on it
Then we have
This backup option
Aap clearly
You can see
We have this.
Backup over here
So once again
Right click
Not again
Like first
After that, me
Right-clicking
Then backup pe
I want to click.
And this is it
Here
We are very clear
You can see
Hello
Data option is available
Query options available
So we have
Multiple options
Believe me, guys
All these options
I tried it
Seen it.
But the main one later
Hurry up
This is yours
Pre-data
Data and then
Post data
I'll tell you
To pre data
What is MATLAB?
First time
You can your tables
You are creating, aren't you?
You are watching, aren't you
So this is your
Pre-data
That stage you're at
Here is the table.
Existence exists
But his back
File any data
No, it isn't.
Thake
To ab
It's today, guys
Your data
Where are you?
You can see it
Data means
Actual rows
Actual fields
When you
What are you adding?
As
Main insert
Into karke
Added it.
To ab
Our table
I mean, it's a table.
Inside him
We have
There are also records.
Then we have
Post data
Table, we
Done.
Data inside it
Inserted.
After that
Guys
Yes
There is a constraint.
You who are doing this
Foreign key
What are you adding?
All these triggers
Rules
Indexes
To you, sir
Inside whom?
The one you
Files
Basically
Inside that folder
You
My backup
I want to save it
Here you are
Jaiye
I have given you a name
As
Hand of fate
YouTube
College
Management
Thapa
Technical
And then
By default
.SQL
Selected
If not so, then
Selecting
Saved it.
Main
Now
The most important thing is
This is the most important thing.
And that's
This format
This format
It is very, very important.
Because
If you
You will select the one
Then a problem will arise.
Nothing will happen to the problem.
Unlimited
However many times you try and error
You can go ahead and draw a map.
But
That's it
It's a plane.
And then we have
This directory
Go with
Airplane
If you go custom
By default
I'll show it to you, too
You see here
The custom you have
Such kind of data
Will come
You are seeing this
To say
Binary archive bolt
But look here you see
Something like this is happening
It won't work for me.
But what we want
I need a plane urgently.
The Istarike are
Here you can see
The plane data that is visible here
I need plane data like this
For that reason
I'm here, sip ek
The plane that we will select
This is it
I will click the main backup.
You can see it
What's mine, this one
Backup on
It has been created.
Here you can see
And behold
Before this here
Mene
I was trying
So many of these
Various different tariki
And I found out
There's no need to do anything.
Name of the file
And select the plane
Everything
By default, you
Data ho
Your schema
Everything will come.
You can see it yourself
YouTube
By the way
You will find it here.
You see here
YouTube college management
And look here
How well
Here you can see
Hey guys
This file here
Today I will share this here
If you
And just download it.
Thake
Let's just assume this for now
Have you downloaded it?
Inside a file
You kept it saved.
Inside the folder
You've come back here again
Thake
Like this
You see here
This is your database
Databases are visible
Right click
We need to create one database.
And here you write it yourself
Thapa underscore
College underscore
Management
Thake
From this date onwards
And here at this place
Nothing to do
I don't want to do anything.
I created a database.
Save it
This is it
So now
We are done with our
You have a database, right?
Creation basically
I have one ready for you.
So now
So what should I do?
What you are seeing right now
On the database guy
I'll right-click there.
Now we have what
Backup
Sorry, no backup
This one
Restore
What you are seeing restored
Here
You will have to click on it.
So click on main restore
Again, as I was saying to you
I told you earlier
Custom hota to
Custom
But we didn't say we wanted a custom selection
We selected plain
Where did you click on the main page?
File name
Basically the same
Look
Something might also appear to you in this way
You will be amazed.
Where did he go?
What is not there?
Anything at all here
But look at the cow
Are you here?
The option that is appearing right now
You
The backup is visible.
What do I need?
Dot SQL
Just do all the files.
All files kara
To finally
All of that
What you see here
Maine jo
YouTube college management
I clicked it.
Thake
You're on restore mode.
I'll click it
Restoring
Success is coming back, that's what matters
It's a tough situation.
I will click on the main tables.
Nothing will happen.
But tables
And then we have this
Refresh button
And boom, guys
See
Certificate
Courses
Enrollment
Exams
It's gone, everything
So guys, this is the
Simplest method
Where it's comfortable
Your backup
You can create
And then calmly
From this point onward
Look
You can also restore it.
Isn't it become so easy now?
That's it.
This is my backup
Where is Maine?
I'll share it here.
Even you too from this side
Calmly
Restore it
To ab
This one is yours
There will be no tension.
And
These files here, guys
I did that too.
Laid here
Even PPT notes are there
Here
And your handwritten notes
There are also such ones.
Check this out, man.
You can do it
Thake
And every video of hers
Describe me
And
What you have given me
It's visible, it's clear
Here
You saw it, didn't you?
Thake
So, you guys
This is it
Not even a lite for this video
I hope you like the video
If you like the video
Please like
With friends
Word work is safe
And
I am Milta Hu
In the next video
Until then, guys
Thank you so much
Be careful
Outro