| From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
|---|---|
| To: | stephen(at)cass-ltd(dot)co(dot)uk, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Urgent: Restoring many schemas in a database |
| Date: | 2003-06-05 20:18:54 |
| Message-ID: | 200306051319.09566.jgardner@jonathangardner.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Thursday 05 June 2003 03:49, Stephen J. Thompson wrote:
> 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).
>
Put a .pgpass file in the home directory of the user.
It should have a line:
*:*:*:<username>:<password>
- --
Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
(was jgardn(at)alumni(dot)washington(dot)edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE+36W3WgwF3QvpWNwRAnvkAJ4zcFGBMemqGRqYTRTdcPQTZqUvwACeMmIn
Lgiq5VrDOowcpmdSbn5EtDU=
=Ldm6
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Gardner | 2003-06-05 20:22:42 | Re: Backup and Restore |
| Previous Message | Terry Hampton | 2003-06-05 19:49:12 | White Paper |