I don't know anything about Aurora, only have experience with RDS
Postgresql.
We successfully migrated from on-prem Oracle (12c, I think) to RDS
Postgresql 12, and were very happy: little down time (I take pride in
designing/implementing that; thanks, ora2pg!), with lower disk (8TB, down
to 5TB) a
Thank you so much for the response.
Got your point, will check if we really need details or summary for the
historical data. But it looks like we will need detailed transaction data
for ~2 years at least.
My understanding was that AWS has two different offerings and "aurora
postgresql" is more pe
On Sat, Dec 9, 2023 at 2:13 PM veem v wrote:
>
> Ron Johnson
> wrote:
>
>> "OK" is relative, but it's what we did in a similar situation: two years
>> of data on-line and 5 years of data in compressed files in S3. (We're
>> required to keep data for 7 years, but they *never* ask for records mo
Ron Johnson
wrote:
> "OK" is relative, but it's what we did in a similar situation: two years
> of data on-line and 5 years of data in compressed files in S3. (We're
> required to keep data for 7 years, but they *never* ask for records more
> than 2 years old. If they ever do, we'll manually l
On 12/9/23 07:54, Igniris Valdivia Baez wrote:
this is the settings for my local db which I failed to say is also in
Postgres 14, the dev db is in Postgres 15.4 has UTF an en_US.utf8
collation, for the ETL process I'm using Pentaho Data Integration
tool, also known as kettle, thanks in advance
On Sat, Dec 9, 2023 at 6:14 AM veem v wrote:
[snip]
> Many of the applications are moving from on premise to AWS cloud as part
> of modernization journey and AWS being chosen cloud partner also the
> product is expected to expand across more regions and this system is
> expected to serve increase
this is the settings for my local db which I failed to say is also in
Postgres 14, the dev db is in Postgres 15.4 has UTF an en_US.utf8
collation, for the ETL process I'm using Pentaho Data Integration
tool, also known as kettle, thanks in advance
El sáb, 9 dic 2023 a las 10:50, Adrian Klaver
() e
On 12/9/23 07:41, Igniris Valdivia Baez wrote:
hello, thank you for answering, it's not a typo, in the attachments
you can see that this is actually my collation, algo a pic of the
problem for more clarification,
thank you all
You picture shows the database collation as Spanish_Cuba.1252 not th
hello, thank you for answering, it's not a typo, in the attachments
you can see that this is actually my collation, algo a pic of the
problem for more clarification,
thank you all
best regards
El sáb, 9 dic 2023 a las 1:01, Laurenz Albe
() escribió:
>
> On Fri, 2023-12-08 at 23:58 -0500, Igniris V
Hello All,
Although it's not exactly related to opensource postgre but want to ask
this question here to understand colleagues' view, considering having
decades of experience in the database world, We want some guidance, if the
below design looks okay for our customer use case.
We currently have
10 matches
Mail list logo
