pg_restore problem with 7.3.1

Поиск
Список
Период
Сортировка
От Ian Burrell
Тема pg_restore problem with 7.3.1
Дата
Msg-id 3E3B18DA.4010601@onsitetech.com
обсуждение исходный текст
Ответы Re: pg_restore problem with 7.3.1  (Jeff Ross <jross@openvistas.net>)
Re: pg_restore problem with 7.3.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_restore problem with 7.3.1  (Kevin Brown <kevin@sysexperts.com>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "codeWarrior"
Дата:
Сообщение: Re: Making connections to postgres under FreeBSD
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: COPY as non super user