Pgadmin 4 pg_restore: [archiver] input file appears to be a text format dump. Please use psql

pg-dump pgadmin-4 postgresql-11
Maha Dev picture Maha Dev · Feb 1, 2019 · Viewed 6.9k times · Source

Hi I am using Postgres 11 and pgadmin 4.1. I have a SQL file i am trying to import in my newly created database in pgadmin 4.

I know its a generalized error but I tried my best to resolve it, but not working for me.

Here is the error:

enter image description here

Here are a few SQL file lines.

enter image description here

Answer

Laurenz Albe picture Laurenz Albe · Feb 1, 2019

Since this plain format dump does not contain any backslash commands, which could only be interpreted by psql, you can simply run it with pgAdmin's query tool while being connected with the destination database as superuser.

Related questions

Postgresql 9.2 pg_dump version mismatch

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How ever i am getting this error. pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 pg_dump: aborting because of server version …

Read More
How to create a backup of a single table in a postgres database?

Is there a way to create a backup of a single table within a database using postgres? And how? Does this also work with the pg_dump command?

Read More
How do I do a schema only backup and restore in PostgreSQL?

How do I take a schema level backup in PostgreSQL database and restore on the another database? Is there any single command available for this? For example, can I pg_dump and restore in single line?

Read More