From: | Rob Richardson <RDRichardson(at)rad-con(dot)com> |
---|---|
To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | How do I restore this file? |
Date: | 2014-03-12 17:06:57 |
Message-ID: | 67D108EDFAD3C148A593E6ED7DCB4BBDD84271CC@RADCONWIN2K8PDC.radcon.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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?
Thank you very much.
RobR
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2014-03-12 17:21:20 | Re: How do I restore this file? |
Previous Message | matshyeq | 2014-03-12 14:33:55 | Fwd: fetchSize parameter |