Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1olBZ4-0002pM-4L for pgsql-admin@arkaria.postgresql.org; Wed, 19 Oct 2022 16:05:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1olBZ2-0002O1-NP for pgsql-admin@arkaria.postgresql.org; Wed, 19 Oct 2022 16:05:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1olBZ2-0002Np-C8 for pgsql-admin@lists.postgresql.org; Wed, 19 Oct 2022 16:05:04 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1olBYz-00084v-L0 for pgsql-admin@lists.postgresql.org; Wed, 19 Oct 2022 16:05:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1666195499; bh=4r9ojC9K5eAC+LxUFuzgf+5kup8LLKi/EZcTlMCaLZ8=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=Iij/p+wuerNY+fm4CyZS09xoHCej7S5SPkhH/gU200/QWwzUqsIU1OqXpYtljfAe7 uY6/hrMM0cazU+VDuFuLGWflQflfK7KUh9TGHxynRAUf3Qvl8tQVZZ9ego8CF6Gr0S fGlbhfaKVNK4zi5AjJhpWVbUSac5qPuiWvp3ugJg= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [192.168.178.20] ([83.171.173.102]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MNbp3-1oSJGa0qpn-00P8LO for ; Wed, 19 Oct 2022 18:04:59 +0200 Subject: Re: Database schema changes tools To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: Date: Wed, 19 Oct 2022 18:04:56 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:nngiJJSdbnUpthCUk5bHjAkIcXA175osmesv1E7yL+kecJps+pR Skg2M/cLABR9/aaeB0sXg0KKAHlmzWKXjnyBM8d/TsCmWYdw2MfDAXUD7TaoMjECXUuH7a5 Ax9s0eTqZDz8n9TDjodSC7gyQB918VPQR2IiPm/jLIoT9NzO96qoIUU7Wiejf5tJXxRYaGX vJEzsiz2AOHuhruB/d41g== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:jefS881vIjQ=:4uXl88AfGTBg2/mVqE9Zb3 t/yKf9Qj07RKTynR4LCTa5InHXEhsFr06qKjCSrWvs4in32i0kPNanQ7h2Wcj3re2/DcGNhRK vOpVYlRFSz6ZokMa7lGb8+sUSfgLc1+G/S9MBJFm8mHsWC4ST1ppd6ZMao116mW8TyHLNu4uL 95EO6tpEdJkE+gnnTGeFes8GQTe3+/uY6TebqqYBgQbCrFz25u51Q+Oi3GcUpnCk8hqs41IK3 GieT+dJfxjI0FPzeyyJU2LlJVONASoiNNmxPP+tx5f2QrQlK4mJ3oDxqimoKvGWIDNmjeZ6DZ V0zvVsvJD0GqADsG7b6hJQBZBu9195Wcx3gAqIh8VlDM/82GyFbK/dCvmr++g1/Chr56g9blC va5A+W4gcb7FQApzi2NsUvhqGoQvTeo5H0hSx40Rgt4kEMFK01NrwRKcSj6rKlkDehjvQ3lna 3f9nllXi01Yjs2NZNHWg56bY3arbOzzWfHLzDc69ySa8yUYLDgF05wxWg3DNg1NY1K39ZK/wn SKtt41TGmsroqjjsmOD56wGO3OzCsyVD1Cp893nxuMDAWSSiaHkdh/g2VmU5Ir1cHlakuXi0l +xjnC+8S1344mhaK/XD4QgXXbo0CFk2mQ/lzW/OXeNtT4/j8KwmL20+RtM4HIluvuB/uPwMiK eaYFBdKCo7D1CCNZAyUUg8ojjMny8wGgUmeKdLeTZiNLwvbwTs5kbw5hqzZLhz0jr/wNmPwM7 lDMXteH8+BfFXwMYlbMvZARLFgGMbiB4dUodPiRQFqf6NYaLL9aRiiAXcnTQeVPwAs+0dU4TQ 4UNXpmG6MmQMmsZc99gknFtzxkZXaWLvyMDfTWh8srGazgQr1gvxa32fI6YeU8sph6DWPrkqQ XLErrcU7s8KOlGtHDdmDibgoKSqndN9zUBgPJsAJLuZpTGgzgecZzNKgishPXQcJTAnswROEi v3VnAO9Gxn3rpBY+2K0rsqlWG2OgnVy941W29VUuxD4DucsuL0+axtWzQ0GDNfPLDaNKBQ+Xj Xe//8qoNGXepasmAamdFNNR5yUOrT+UItnLGgyTwGVpjzYNBVwWq/fUE4w9eKeJUtOTSIp1hp 2aiP5exDsSCsz1KecXD7wL++nFsn7Kmk6MgDxfckh/EmpNZtFJD69cKCCLb4/ljSl8NmWodfB wBhIPWc6P/GPmUoxJAWHoxpfM+WnkEKNFDhrUqZdLLIpwDfppfP+eNWmKZqCkvlDQSVUzcLMB lhTENTqV+9AW2ETV+GyYXb79wpMNQFb3EZf8oy9nwvQJ++vzEAZ7HK94aUCIOiwb0bR20w3WE yMdr3iFF10OTDCzFpUGMu0+r0F9tOW4+//eQCQpfErwPb/HVAJIwxiiJLnbVYAJmYRNSArGzr 0y6y04sO5qW8jFW4A3QwasFkFAv9vrAXEB8W4uqvkY9a5t5zdIGWQFsVZF5Z3U5FdU3v5ZYrE zk3IUrnHv3AenVOBi+1yp++POreG30xrU4vXhddT5nG5C9igenzJLu1VbnhJb+4thQP71KPuX DPhbhlfrwreBQ3EmunQzw8aV7Fs1mz/OR4ebV/Hgh6wWO List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk edi mari schrieb am 19.10.2022 um 14:25: > Hi All, > Are you using database schema change tools to manage your Postgres, like Flyway, Liquibase, and DBmaestro ? > Can you please recommend or disrecommend We are using Liquibase exclusively. Some projects require support for multiple database, which is quite easy to do with Liquibase's XML format. For single-DBMS projects we use Liquibase's "annotated SQL" format, which means we are writing SQL scripts that can also be run without Liquibase (which makes testing them easier) Thomas