From: | "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Copy & Re-copy of DB |
Date: | 2021-01-23 12:52:43 |
Message-ID: | 1402129814.2072651.1611406363403@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We are an ISV. I agree the risk involved in sharing the data. Still few of my customers need that facility and are accustomed to it when using SQL Server. On switch over to PG, I face this issue as a limitation. Need to find and provide a solution.
For those customers, having good volume of data, we're implementing replication which resolves this issue. For smaller sized database (company(ies)), they prefer (and we too) this copy and re-copy procedure, to transfer the data between home and office.
And this pandemic made this a compulsory feature, which they don't want to loose. This transfer is not a one time job, it gets repeated, which they have been doing for years. Here security is not a big concern for them.
Portability is the need for them.
Happiness AlwaysBKR Sivaprakash
On Friday, 22 January, 2021, 09:28:13 pm IST, Rory Campbell-Lange <rory(at)campbell-lange(dot)net> wrote:
On 22/01/21, Benedict Holland (benedict(dot)m(dot)holland(at)gmail(dot)com) wrote:
> Sometimes it is easier to simply > replicate the existing bad process
> that a team agrees to rather than making > a better process.
As Alvar Aalto said in a lecture at MIT
It is not by temporary building that Parthenon comes on Acropolis.
From | Date | Subject | |
---|---|---|---|
Next Message | Condor | 2021-01-23 12:57:24 | Need help with trigger |
Previous Message | Paul Förster | 2021-01-23 09:12:35 | Re: localhost ssl |