Re: Aurora PostgreSQL Support

Поиск
Список
Период
Сортировка
От Prince Pathria
Тема Re: Aurora PostgreSQL Support
Дата
Msg-id CAON0DaymVrW_hAyFP=ZFuo5fQPRvXoSfDbfzH2=hLBM++44wQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Aurora PostgreSQL Support  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Ответы Re: Aurora PostgreSQL Support  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Список pgsql-admin
One of the issues I faced in the past is limited(not expandable) tmp storage. If your query is huge, it may fail.
AWS docs don't tell such things explicitly so have intensive testing on Aurora before planning to migrate.
RDS seems to be a safe choice.

Quoting from the doc - "Each Aurora DB instance contains a limited amount of local storage that is determined by the DB instance class. Typically, the amount of local storage is twice the amount of memory on the DB instance."
ref. https://aws.amazon.com/premiumsupport/knowledge-center/postgresql-aurora-storage-issue/ 

Happy to help :)
Prince Pathria Cloud Engineer II| Certified Kubernetes Administrator | AWS Certified Solutions Architect Evive +91 9478670472 goevive.com


On Thu, Feb 18, 2021 at 11:33 AM dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
Hi Rakesh
I would suggest to go for EC2 then install PostgreSQL then use it. I am facing lot of problems in Aurora PostgreSQL

Thanks
Ashok

On Thu, Feb 18, 2021, 10:04 Rakesh T <aryan.goti@gmail.com> wrote:
Hi Listeres,

I am looking for suggestions from people who have experience with Aurora PostgreSQL. 

I work as a database admin in my company. We are migrating some of our Oracle databases to Aurora PostgreSQL. Since this falls under the RDS category I understand that the majority of the admin work will be managed by AWS team itself. But from a business unit perspective, they are looking for support from my team with regards to general BU work and performance and tuning. Can someone shed some light on possible areas which we can support in the RDS Aurora PostgreSQL world?

Thanks in Advance!

Thanks,
Goti

В списке pgsql-admin по дате отправления:

Предыдущее
От: dbatoCloud Solution
Дата:
Сообщение: Re: Aurora PostgreSQL Support
Следующее
От: Walters Che Ndoh
Дата:
Сообщение: Error after Streaming Replication