X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D2E8F56373 for ; Sun, 27 Feb 2005 12:37:19 +0000 (GMT) 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 21929-10 for ; Sun, 27 Feb 2005 12:37:04 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 66CA452A6D for ; Sun, 27 Feb 2005 12:37:10 +0000 (GMT) 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 j1RCb1Qv024091 for ; Sun, 27 Feb 2005 12:37:01 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j1RCJ29D019936 for pgsql-general@postgresql.org; Sun, 27 Feb 2005 12:19:02 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.general Subject: Re: postgresql 8.0 advantages Date: 27 Feb 2005 12:19:18 GMT Organization: cbbrowne Computing Inc Lines: 15 Message-ID: <38ds65F5n9liuU1@individual.net> References: <421F3926.6090201@graciousstyle.com> <5708.1109348115@sss.pgh.pa.us> <421F5E5D.1010902@graciousstyle.com> <1109410075.4089.216.camel@jeff> <20050226213527.GA84483@decibel.org> X-Draft-From: ("nntp+wolfe:pgsql.general" 4767) X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne To: pgsql-general@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/1420 X-Sequence-Number: 74224 Yes, that certainly ought to work. If what you're meaning is that you make a replica that sits in /opt/VERSION8, and then, once the upgrade is complete, rename that to /opt/MYDATABASE which was where your version 7.4 DB used to be. We have copied databases from one server to another by copying the files; making it work was as easy as making sure we ran "pg_ctl -D $RIGHT_DIRECTORY start" :-). -- let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;; http://cbbrowne.com/info/lisp.html "I don't know why, but first C programs tend to look a lot worse than first programs in any other language (maybe except for FORTRAN, but then I suspect all FORTRAN programs look like `firsts')" -- Olaf Kirch