Urgent: Restoring many schemas in a database

Поиск
Список
Период
Сортировка
От Stephen J. Thompson
Тема Urgent: Restoring many schemas in a database
Дата
Msg-id 200306051149.32063.stephen@cass-ltd.co.uk
обсуждение исходный текст
Ответы Re: Urgent: Restoring many schemas in a database  (<mallah@trade-india.com>)
Re: Urgent: Restoring many schemas in a database  (Oliver Elphick <olly@lfix.co.uk>)
Re: Urgent: Restoring many schemas in a database  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Urgent: Restoring many schemas in a database  (Bruno Wolff III <bruno@wolff.to>)
Re: Urgent: Restoring many schemas in a database  (Jonathan Gardner <jgardner@jonathangardner.net>)
Re: Urgent: Restoring many schemas in a database  (Jonathan Gardner <jgardner@jonathangardner.net>)
Список pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello all,

I am trying to restore a 7.3 database with many schemas and schema users in
it. The issue I am having is that there are many \connect statements in the
backup file and it keeps asking me for a new password each time. Is there an
easier way than examining the file and carefully following the connect
statement orders and entering the correct password. (btw there are over 100
connect statements).

Thanks.


Stephen.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE+3yA7DAwPLUWQb6sRAn27AJ9TgcQ8BNqStKA6WKGpV3+De26m5wCgnHas
5jBZaAp/3NchLvRpof14emU=
=Z9On
-----END PGP SIGNATURE-----


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

Предыдущее
От: "David A. Leedom"
Дата:
Сообщение: Backup and Restore
Следующее
От: Peter Childs
Дата:
Сообщение: Re: interpret vacuum verbose output