How do I restore this file?
От | Rob Richardson |
---|---|
Тема | How do I restore this file? |
Дата | |
Msg-id | 67D108EDFAD3C148A593E6ED7DCB4BBDD84271CC@RADCONWIN2K8PDC.radcon.local обсуждение исходный текст |
Ответы |
Re: How do I restore this file?
|
Список | pgadmin-support |
Hello! I have been using PostgreSQL v8.4 and its associated PGAdmin version for a few years. I've only recently begin migratingto 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 boxin PGAdmin has been completely revamped since 8.4. It's got two format versions: Custom or tar, and directory. It doesnot have the "plain" I'm used to seeing from 8.4. This appears to be a plain backup file. How do I restore it usingPGAdmin? Thank you very much. RobR
В списке pgadmin-support по дате отправления: