X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9B5A4DB5B0 for ; Thu, 17 Nov 2005 16:18:15 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12407-02 for ; Thu, 17 Nov 2005 20:18:15 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 0ECB2D6D07 for ; Thu, 17 Nov 2005 16:18:13 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jAHKIBWq060294 for ; Thu, 17 Nov 2005 20:18:11 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jAHK45EV020289 for pgsql-admin@postgresql.org; Thu, 17 Nov 2005 20:04:05 GMT (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: restore challenge Date: Thu, 17 Nov 2005 14:04:42 -0500 Organization: cbbrowne Computing Inc Lines: 34 Message-ID: <60fypvgkol.fsf@dba2.int.libertyrms.com> References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:XhP1Egq21Kkak5ASM0OpN2Bn/Sw= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.277 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.163] X-Spam-Score: -1.277 X-Spam-Level: X-Archive-Number: 200511/231 X-Sequence-Number: 19604 "codeWarrior" writes: > it doesnt work that way.... this is postgreSQL -- a relational database..... > you can't just copy the data directory like you can with mySQL or DBase, or > BTrieve or any of the "old-school" databases... if you need to backup and > restore data you need to look at pg_dump and pg_dumpall and the import > statements in psql... Actually, that's wrong. You certainly *can* copy the set of data directories; there is no particular magic here. The data is stored as a set of files in a set of directories; for there to be some other "magical something else" would seem very strange. What you generally can't do safely is to take a copy while the postmaster is up and running, as you risk parts of the data not being consistent with one another. If your OS or disk hardware supports some sort of "snapshotting" technology, so that you can grab a copy of the whole thing as an instant atomic operation, that provides a way to grab a copy while postmaster is running. If not, then you have to take a copy while the postmaster is shut down. The resulting filesystem copy will only be compatible with the same major version of PostgreSQL, and with versions running on the same architecture, but that can still let it be useful. -- (format nil "~S@~S" "cbbrowne" "ntlug.org") http://cbbrowne.com/info/oses.html ">in your opinion which is the best programming tools ? The human brain and a keyboard." -- Nathan Wagner