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 по дате отправления:

Предыдущее
От: matshyeq
Дата:
Сообщение: Fwd: fetchSize parameter
Следующее
От: Dave Page
Дата:
Сообщение: Re: How do I restore this file?