Search code examples
postgresqlpgadminpgadmin-4

How can I import a pg_dump via PgAdmin4 without psql? "[archiver] input file appears to be a text format dump. Use psql."

I am trying to import a pg_dump from a Linux machine called "dump.sql" into a windows machine that has PgAdmin4 that does not have psql working.

I keep getting this error message:

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

Any help is greatly appreciated.

Solution

  • You cannot do that.

    One problem is the COPY FROM STDIN that you can find in an SQL dump, and the other is the \c command you will find in dumps created with -C.

    Not sure if there are more problems, but these are definitely showstoppers.

    Did you delete the psql executable?
    I have not seen a Windows pgAdmin installation without a psql.exe so far.