| From: | Ian Burrell <ib(at)onsitetech(dot)com> | 
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org | 
| Subject: | pg_restore problem with 7.3.1 | 
| Date: | 2003-02-01 00:46:18 | 
| Message-ID: | 3E3B18DA.4010601@onsitetech.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
I am upgrading my PostgreSQL install from 7.2.3 to 7.3.1.  I ran into a 
problem with pg_restore creating the database.  I am not sure if this is 
a documentation problem or a real bug.  I have one database with BLOBs 
and used tar format backup: "pg_dump -Ft -b mpmx > backup.tar".
I saw the -C option for pg_restore to create the database.  The man page 
also says that with the -C option, the -d option specifies the database 
create the database from
pg_restore -C -d template1 backup.tar
Instead of creating the mpmx database, the command loaded everything 
into the template1 database.
Is the man page correct about the operation of the -C option?  Should I 
have run things differently?  I noticed that without the -d option, 
pg_restore spits out a script to restore the database.  Should I create 
the database manually and restore it by piping pg_restore into psql?
How can I return template1 to its initial state?
- Ian
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-02-01 06:44:53 | Re: COPY as non super user | 
| Previous Message | Mintoo Lall | 2003-01-31 19:24:54 | Re: Postgres server output log |