agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Paul M. Aoki <aoki@CS.Berkeley.EDU>
To: postgres-arch@postgres.Berkeley.EDU
Subject: [sarum@monosys.com: copy of a database in postgres]
Date: Fri, 09 Dec 94 15:27:13 -0800
Message-ID: <199412092327.PAA14801@faerie.CS.Berkeley.EDU> (raw)
------- Forwarded Message
From: David Allan Finch <sarum@monosys.com>
To: aoki@cs.berkeley.edu
Subject: Re: copy of a database in postgres
Date: Tue, 25 Oct 94 17:09:39 GMT
|> From: David Allan Finch <sarum@vger.demon.co.uk>
|> Message-Id: <9310072315.AA00525@vger.demon.co.uk>
|> To: postgres@postgres.berkeley.edu
|> Subject: Dump/restore a postgres database
|> Date: Fri, 8 Oct 93 00:07:18 BST
|>
|> Version 0.3 of the ongoing pgperl script...
|> this version will dump all databases except template1 and
|> postgres. With a little more work it will store all the stuff
|> nead to recreate a full database. Tommorow I will hopeful have
|> a restore script. Which I will use to upgrade to V4.1, If anyone
|> can see any bugs please tell me. Also it would be nice to dump
|> indexes, function etc, anyone got any ideas about how to do this?
Hi,
For those that may asked; I did not take the script
any furthur. For some reason I could not get all
the infomation out of the classes before either the
backend or pgperl died :-( (we where talking about
vast number of records, insome cases 1 insert
per-minute over a 3 month period ~ 133000 records per
class and we had 30 of these classes)
PS - we were recording live currency and metal trading,
it produces some very pretty graphs :-)
I not long after that moved companies and I am afraid
I don't know what they did with the DB after that.
If someone is brave enought to finish it, please be my
guest as I will not be returning to DB work in the
near future.
--
/ Chair of 1996 British Roleplaying Convention 'ConTraptions'
/\|/\ Ban all the Orange Books
| K | All Hail Discordia
\___/ sarum@vger.demon.co.uk & sarum@monosys.com
------- End of Forwarded Message
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: aoki@CS.Berkeley.EDU, postgres-arch@postgres.Berkeley.EDU
Subject: Re: [sarum@monosys.com: copy of a database in postgres]
In-Reply-To: <199412092327.PAA14801@faerie.CS.Berkeley.EDU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox