1

I have taken a dump of postgres database from server, let's say abc.sql whose total size is 56 GB. I created a local database in postgres, let's say import_here where I have to import the abc.sql. I am using the following command to import:

sudo -u postgres psql import_here < abc.sql

I get the following error:

enter image description here

I have tried the solutions from the following link but nothing worked for me:

https://italux.medium.com/postgresql-out-of-memory-3fc1105446d#:~:text=The%20most%20common%20cause%20of,writing%20to%20temporary%20disk%20files

I am using ubuntu 20.04. I am also sharing disk space status for your reference: enter image description here

Improve this question
2
  • 1
    The error messages suggest that the dump is not interpreted correctly. Find the first error message and add it to the question. Never mind the OOM error. Commented Mar 16, 2021 at 7:15
  • 1
    @LaurenzAlbe Thanks. I was unable to see the first error message because it was crossing quickly so I recorded the video and saw it. The main error was that the postgis scripts were missing. sudo apt-get install postgis postgresql-12-postgis-scripts fixed the problem for me. Commented Mar 16, 2021 at 8:02

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.