Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.37.53]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id PAA08406 for ; Fri, 9 Dec 1994 15:27:21 -0800 Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.9/8.1B) with SMTP id PAA14801; Fri, 9 Dec 1994 15:27:19 -0800 Message-Id: <199412092327.PAA14801@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol From: aoki@CS.Berkeley.EDU (Paul M. Aoki) To: postgres-arch@postgres.Berkeley.EDU Reply-To: aoki@CS.Berkeley.EDU (Paul M. Aoki) Subject: [sarum@monosys.com: copy of a database in postgres] Date: Fri, 09 Dec 94 15:27:13 -0800 Sender: aoki@postgres.Berkeley.EDU X-Mts: smtp ------- Forwarded Message From: David Allan Finch 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 |> 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