The video shows how to import database using pgAdmin for PostgreSQL #postgres #postgresql #sql #advanced #beginners #database #datascience #analysis #query
Hi I have an issue. I loaded a new hard drive into my system. How do I import database from my old harddrive (it contains all the databases from my previous PostgreSql software) into my current PostgreSql software. P.S: I still use my old harddrive as an external drive.
@@h4zmeister go to preference in the the file menu , then binary path you will the copy the path of the utility files from where you setup files are then save
Wow its very easy now ... Thanks Sir
Welcome,please share and spread the word to collegues
Hi I have an issue.
I loaded a new hard drive into my system.
How do I import database from my old harddrive (it contains all the databases from my previous PostgreSql software) into my current PostgreSql software.
P.S: I still use my old harddrive as an external drive.
Real legend
Thanks, please subscribe and share the video.
Can you please show how it’s done via coding it for iOS device?
what about a JSON file?
What if my import is showing failed.
What's the solution to that
There is a description below, it shows why it failed? By expanding view processes
Can u also use this method to import csv?
Yes, I will make a video of it.
@@arnoldkilaini okay that will be great
I tried this same step but getting this error "pg_restore: error: input file does not appear to be a valid archive", please help what to do
What type of file are you importing?
@@arnoldkilaini .csv file
Can we restore .sql file instead of tar file??
Yes, you can restore
Worth it... Muda wa practice tu sasa
kabisa Kaka
I got this error, how do I troubleshoot: pg_restore: error: input file does not appear to be a valid archive
Hello, What is the file format of the file you are working with?
@@arnoldkilaini .sql
Using a Mac.
I mean is it a tar file or custom file? @@AmeliaRDream100
@@arnoldkilaini it's a .sql file, so I am thinking custom?
My postgres (PgAdmin) won't allow me to select the file for some reason. Know why?
Which type of file? Is there any message showed by PgAdmin?
@@arnoldkilaini when i click on restore it gives me this error. 'Utility file not found. Please correct the Binary Path in the Preferences dialog'
@@h4zmeister go to preference in the the file menu , then binary path you will the copy the path of the utility files from where you setup files are then save
I am not able to import data
It is showing process failed
What type of database data are you importing?
@@arnoldkilaini I am Importing A. Sql File
@@arnoldkilaini but is showing process failed again and again
Same here :( @@ankitrawat9369