Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1EF3564FCE2 for ; Thu, 18 Sep 2008 12:50:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21467-03 for ; Thu, 18 Sep 2008 12:50:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 475D864FCD8 for ; Thu, 18 Sep 2008 12:50:26 -0300 (ADT) Received: from perhan.alvh.no-ip.org (190-95-19-82.bk17-dsl.surnet.cl [190.95.19.82]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m8IFrnVZ029598 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 18 Sep 2008 08:53:52 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 2E3B547CAE; Thu, 18 Sep 2008 11:50:18 -0400 (CLT) Date: Thu, 18 Sep 2008 11:50:18 -0400 From: Alvaro Herrera To: Julius Tuskenis Cc: pgsql-admin@postgresql.org Subject: Re: CVS for postgresql Message-ID: <20080918155018.GC3868@alvh.no-ip.org> References: <48D21D11.1030309@nsoft.lt> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <48D21D11.1030309@nsoft.lt> User-Agent: Mutt/1.5.18 (2008-05-17) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Thu, 18 Sep 2008 08:53:53 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/195 X-Sequence-Number: 30288 Julius Tuskenis wrote: > Hello > > we develop applications on postgresql, use alot of functions, edit them > very often so there is a need for a version control. Is there a solution > like CVS or something for PG databases? Well - for schemas at least. Not directly. People are used to storing schema definitions in text files and storing those under revision control. When schema changes are needed, new files are added with the appropriate ALTER TABLE etc commands. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support