Re: pg_restore blues - Mailing list pgsql-admin

From Allan Engelhardt
Subject Re: pg_restore blues
Date
Msg-id 3BCD33EF.2030909@cybaea.com
Whole thread Raw
In response to pg_restore blues  (Allan Engelhardt <allane@cybaea.com>)
List pgsql-admin
Oh, no!  Please don't tell me I also can't use BLOB in PostgreSQL.
Surely there is a way to backup and restore the *whole* database?

I've tried creating the database manually and then
    $ droplang  plpgsql foo
before the restore, but that didn't work either.  The language is, of
course, created in template1.


I'm stumped.  :-(  I can backup my db, but I can't restore it.  Not much
use, is it...?


Allan.

Lee Harr wrote:

> On Tue, 16 Oct 2001 18:42:19 +0100, Allan Engelhardt <allane@cybaea.com> wrote:
>
>>OK, I'm probably doing something very stupid, but can somebody explain how I'm supposed to restore a custom archive
dump?
>>
>>$ createdb foo
>>CREATE DATABASE
>>$ psql foo
>>foo=# create table users (id serial);
>>NOTICE:  CREATE TABLE will create implicit sequence 'users_id_seq' for SERIAL column 'users.id'
>>NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'users_id_key' for table 'users'
>>CREATE
>>foo=# \q
>>$ pg_dump --blobs --clean --create --file=/tmp/foo.dump --format=c --compress=9 foo
>>$ dropdb foo
>>DROP DATABASE
>>$ pg_restore --create -d test /tmp/foo.dump
>>
>
>
> I never use pg_restore... Actually did not know it was there.
>
> I always use psql:
>
> psql
> create database restordbname;
> \c restordbname
> \i foo.dump
> \q
>
> Of course I also do not use blobs....
>
>
>



pgsql-admin by date:

Previous
From: "Moovarkku Mudhalvan"
Date:
Subject: Convertion of Oracle Database to Postgresql
Next
From: Allan Engelhardt
Date:
Subject: Automatically starting postmaster after system crash