Re: pg_restore blues

On Tue, 16 Oct 2001 18:42:19 +0100, Allan Engelhardt <allane(at)cybaea(dot)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....