Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jGjcv-0002TC-17 for pgsql-www@arkaria.postgresql.org; Tue, 24 Mar 2020 13:29:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jGjct-00068l-R0 for pgsql-www@arkaria.postgresql.org; Tue, 24 Mar 2020 13:29:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jGjct-00068b-Jk for pgsql-www@lists.postgresql.org; Tue, 24 Mar 2020 13:29:51 +0000 Received: from mout.perfora.net ([74.208.4.196]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jGjcr-000418-8J for pgsql-www@postgresql.org; Tue, 24 Mar 2020 13:29:51 +0000 Received: from [192.168.1.143] ([98.169.208.7]) by mrelay.perfora.net (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0M2sPQ-1jZ5n52M6A-00shrx for ; Tue, 24 Mar 2020 14:29:45 +0100 To: pgsql-www@postgresql.org Subject: Wiki editor request From: MichaelDBA Message-ID: Date: Tue, 24 Mar 2020 09:29:42 -0400 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 PostboxApp/7.0.12 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------0E5D26AE1504CD1994E2C206" Content-Language: en-US X-Provags-ID: V03:K1:ecRUL2g/dF4o0HC01fjpmsR5MHY5xyK18sKQYWhEIpZus5IctDK ZegUOVysVW0QXJa5Mo7ZI4cMk+5EdZWNP844qZ+I6IOL2v0r+O2vn6HN9ZwJzpAAt/xD0Eb WqNPntzfRAWGeU0hgApUOkR2cmKZB0iK2MGTyvHaMhLCFf7J/dcLj4/jv4i0R+YZX2oTvhc 7ej3yg1Uwa9a26VvfEqbw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:mKx0Z4wv9qg=:5Wd6uQbEqgqQhx3eCh/xSr 5qUzodmRMJCmBeonJ6krioBhCtxe1DvQg8ULq6k/qmJChiKf2WrR2qWAup76RwBPOfmJLZCmD 6mvXBhXpXWhAJidIcO/2/zqfIui8HxvoZKnTBwWsGnD9Hy48lFe0luQm8sDWvjKcSTUSuCV0h GxpHlNqEc7TuTObcduw0wmJ9xXeDJhy/2EHY2wXl7fdv2BUINbPVcE9kcR1yfcObJd2nAWD4F L+g2T687zbWcCDVYHRCbSMuCEyCEySIY7+bHVsKW6yJR01D9ksshEYn7i0qws9UFlJXP6HcTe QUlO8y2HJvdnhjvZVu4Psgfc4U07LGH8Wj/LB+Pq2QGeANc7+eTg210udlPMq7pcmVCduBBar IORkuPN6pqvYNJF7ux9dC+F6VeVGYUw+UOHO7z4APdzjSMxhcsyqDJy56/Cn5i/swBc2h6F0Y psb8XMb5TSZdxxkJKELUNa7SO5fGJM1mZTp9bKAEzVJqFE38c4r0WnspZ7GCu8wAo89goXkx/ 3ye8oZrwcBhmkWee7ZBsGXqZhNa0MVjDt7xMZ9VDoC8GairwcxoSfdVMtNBqlRTKT26UtpHVT /bhwI7FERSq2c2zq6NcsMmk0Ff5SX7vKTuKkGk4PfLP9e2VX3uQ6o3KNZcy17SJYfergiRoSh ZyyvP+7JwGbbEK/mZO3HAyfA+ZLMd8yMmbkeXiijDXppggGLKWkQVfbSar3FOK+IM8YxgMhE/ +NmR1PCnhhYBDRyudDV9zC8IEId+5MXNsCVShUTBxuNwrzo40romrUVv0UgIKuF+cE5LPFCGS 2QjsxHOdstqTqntYxaCVZM1m8k2vErOeI2myLQTIX0aZxhCMhb+ft+iGmjwySfXXV/W7IEZ List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------0E5D26AE1504CD1994E2C206 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Can I be added as an editor to the PG WIKI on migrations from Oracle to Postgres?  I want to add this section: One special case of Oracle RAC to PG is where they have multiple, separate heavy-hitting applications connected to the same RAC Cluster. The mistake is to assume that they can simply migrate these applications to point to one PG Instance. At this point they miss the big picture of ACTIVE-ACTIVE (Oracle RAC) and ACTIVE-PASSIVE (PG). While Oracle can divvy up the applications and load balance them across the Nodes in the Cluster, there is no such thing in PostgreSQL. Absent some rearchitecture and/or 3rd party tools, it might be wise to move the heavy-hitting apps to a one-to-one relationship between APP and PG Instance. Regards, Michael Vitale --------------0E5D26AE1504CD1994E2C206 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGh0bWwgdGhlbWU9ImRlZmF1bHQtbGlnaHQiPjxoZWFkPg0KPG1ldGEgaHR0cC1lcXVpdj0i Y29udGVudC10eXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPjwvaGVh ZD48Ym9keQ0KIHRleHQ9IiMwMDAwMDAiPg0KQ2FuIEkgYmUgYWRkZWQgYXMgYW4gZWRpdG9y IHRvIHRoZSBQRyBXSUtJIG9uIG1pZ3JhdGlvbnMgZnJvbSBPcmFjbGUgdG8gDQpQb3N0Z3Jl cz/CoCBJIHdhbnQgdG8gYWRkIHRoaXMgc2VjdGlvbjo8YnI+DQogIDxicj4NCiAgPHNwYW4g c3R5bGU9ImNvbG9yOiByZ2IoMzQsIDM1LCAzMSk7IGZvbnQtZmFtaWx5OiAmcXVvdDtTb3Vy Y2UgU2FucyBQcm8mcXVvdDssIEhlbHZldGljYSwgc2Fucy1zZXJpZjsgZm9udC1zaXplOiAx NS4xMnB4OyBmb250LXN0eWxlOiBub3JtYWw7IGZvbnQtdmFyaWFudC1saWdhdHVyZXM6IG5v cm1hbDsgZm9udC12YXJpYW50LWNhcHM6IG5vcm1hbDsgZm9udC13ZWlnaHQ6IDQwMDsgbGV0 dGVyLXNwYWNpbmc6IG5vcm1hbDsgb3JwaGFuczogMjsgdGV4dC1hbGlnbjogbGVmdDsgdGV4 dC1pbmRlbnQ6IDBweDsgdGV4dC10cmFuc2Zvcm06IG5vbmU7IHdoaXRlLXNwYWNlOiBwcmUt d3JhcDsgd2lkb3dzOiAyOyB3b3JkLXNwYWNpbmc6IDBweDsgLXdlYmtpdC10ZXh0LXN0cm9r ZS13aWR0aDogMHB4OyBiYWNrZ3JvdW5kLWNvbG9yOiByZ2IoMjQ3LCAyNDcsIDI0Nyk7IHRl eHQtZGVjb3JhdGlvbi1zdHlsZTogaW5pdGlhbDsgdGV4dC1kZWNvcmF0aW9uLWNvbG9yOiBp bml0aWFsOyBkaXNwbGF5OiBpbmxpbmUgIWltcG9ydGFudDsgZmxvYXQ6IG5vbmU7Ij5PbmUg c3BlY2lhbCBjYXNlIG9mIE9yYWNsZSBSQUMgdG8gUEcgaXMgd2hlcmUgdGhleSBoYXZlIG11 bHRpcGxlLCBzZXBhcmF0ZSBoZWF2eS1oaXR0aW5nIGFwcGxpY2F0aW9ucyBjb25uZWN0ZWQg dG8gdGhlIHNhbWUgUkFDIENsdXN0ZXIuICBUaGUgbWlzdGFrZSBpcyB0byBhc3N1bWUgdGhh dCB0aGV5IGNhbiBzaW1wbHkgbWlncmF0ZSB0aGVzZSBhcHBsaWNhdGlvbnMgdG8gcG9pbnQg dG8gb25lIFBHIEluc3RhbmNlLiAgQXQgdGhpcyBwb2ludCB0aGV5IG1pc3MgdGhlIGJpZyBw aWN0dXJlIG9mIEFDVElWRS1BQ1RJVkUgKE9yYWNsZSBSQUMpIGFuZCBBQ1RJVkUtUEFTU0lW RSAoUEcpLiAgV2hpbGUgT3JhY2xlIGNhbiBkaXZ2eSB1cCB0aGUgYXBwbGljYXRpb25zIGFu ZCBsb2FkIGJhbGFuY2UgdGhlbSBhY3Jvc3MgdGhlIE5vZGVzIGluIHRoZSBDbHVzdGVyLCB0 aGVyZSBpcyBubyBzdWNoIHRoaW5nIGluIFBvc3RncmVTUUwuICBBYnNlbnQgc29tZSByZWFy Y2hpdGVjdHVyZSBhbmQvb3IgM3JkIHBhcnR5IHRvb2xzLCBpdCBtaWdodCBiZSB3aXNlIHRv IG1vdmUgdGhlIGhlYXZ5LWhpdHRpbmcgYXBwcyB0byBhIG9uZS10by1vbmUgcmVsYXRpb25z aGlwIGJldHdlZW4gQVBQIGFuZCBQRyBJbnN0YW5jZS4NCg0KDQpSZWdhcmRzLA0KTWljaGFl bCBWaXRhbGUNCjwvc3Bhbj4NCjwvYm9keT4NCjwvaHRt bD4= --------------0E5D26AE1504CD1994E2C206--