| 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-06 21:11:21 |
| Message-ID: | 200306061411.22752.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).
>
Try ~/.pgpass with one 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+4QN5WgwF3QvpWNwRAuzdAJwJUYr/aabryj1ZyvfeLrgcMBJGGwCgk7FC
itynkuB0XX3Y6VgqGzTayA8=
=wdgM
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Gardner | 2003-06-06 21:36:18 | Re: Shared_buffers and kernel parameters, tuning |
| Previous Message | Ben Schneider | 2003-06-06 20:12:50 | Help! Error when calling a function |