Re: How do I restore this file?

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Rob Richardson <RDRichardson(at)rad-con(dot)com>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: How do I restore this file?
Date: 2014-03-12 17:21:20
Message-ID: CA+OCxozE2wg+cs270cDYST4+kv_v-iRZJ674jb+BL9=LNqbiEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi

On Wed, Mar 12, 2014 at 5:06 PM, Rob Richardson
<RDRichardson(at)rad-con(dot)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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message liliwow 2014-03-14 09:09:11 I'm in a fix... please help quick
Previous Message Rob Richardson 2014-03-12 17:06:57 How do I restore this file?