Hi On Wed, Mar 12, 2014 at 5:06 PM, Rob Richardson <rdrichard...@rad-con.com> wrote: > Hello! > > I have been using PostgreSQL v8.4 and its associated PGAdmin version for a > few years. I've only recently begin migrating to the PostgreSQL 9 world. I > have PostreSQL 9.1 and PGAdmin version 1.14.0. > > I have a backup file named WSC.backup. The file begins with: > > -- > -- PostgreSQL database dump > -- > > -- Dumped from database version 9.1.1 > -- Dumped by pg_dump version 9.1.1 > -- Started on 2014-03-12 09:37:01 > > SET statement_timeout = 0; > SET client_encoding = 'UTF8'; > SET standard_conforming_strings = on; > SET check_function_bodies = false; > SET client_min_messages = warning; > > -- > -- TOC entry 248 (class 3079 OID 11638) > -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: > -- > > CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; > > > -- > -- TOC entry 2861 (class 0 OID 0) > -- Dependencies: 248 > -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: > -- > > COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; > > When I try to restore this file using PGAdmin, it says that it does not > appear to be a backup file. The restore dialog box in PGAdmin has been > completely revamped since 8.4. It's got two format versions: Custom or tar, > and directory. It does not have the "plain" I'm used to seeing from 8.4. > This appears to be a plain backup file. How do I restore it using PGAdmin?
pgAdmin has never supported restore of PLAIN dumps, only creation. You need to use the psql command line tool to read such a file. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
