On Tue, 16 Oct 2001 18:42:19 +0100, Allan Engelhardt <[EMAIL PROTECTED]> 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.... ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
