Questions tagged with PostgreSQL
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hi,
Can anybody help me provide the costs per RDS instance for Postgresql 11 Extended support please?
The email we received states the following:
"You can find an estimate of the Amazon RDS...
2
answers
0
votes
289
views
asked 4 months agolg...
I just found out that the free tier RDS ipv4 address started to charge monthly fee. I'm currently connecting DB through public endpoint. I checked the document and it seems the to access the RDS...
1
answers
0
votes
223
views
asked 4 months agolg...
In the database log, user rdsadmin connects to rdsadmin every 3 minutes, we are wondering if this is normal? what is the purpose of doing this?
```
2024-02-16 19:05:44...
1
answers
0
votes
150
views
asked 4 months agolg...
We have been using PostgreSQL RDS v12, and recently upgraded to v15.
I understand recovery.conf has been merged to postgresql.conf, but in the RDS database log, this warning keeps showing up:...
1
answers
0
votes
732
views
asked 4 months agolg...
I have an Aurora PostgreSQL regional cluster database (version 15.5), with one writer instance and two reader instances. This database has a large partitioned table with 97 partitions of varying...
0
answers
0
votes
87
views
asked 4 months agolg...
Hi,
The issue I'm encountering seems to be a bug. I attempted to create a read replica from my cluster, but later decided to cancel it. Upon noticing the "delete" option available, I clicked on it...
1
answers
0
votes
148
views
asked 4 months agolg...
Hi,
I want to use the temporal table extension in the Aurora PostgreSQL but saw that it is not supported yet:...
1
answers
0
votes
275
views
asked 4 months agolg...
I am trying out DMS as a proof of concept from postgres RDS to postgres RDS - when migrating a databse containing only 1 table no problem is encountered however when attempting to migrate a larger...
0
answers
1
votes
107
views
asked 4 months agolg...
In a new pipeline we are adding to our product, we are collecting a bunch of data from different sources with something similar to keywords. The collected data is mainly text with associated metadata....
0
answers
0
votes
145
views
asked 4 months agolg...
Hi,
I am interested in using CLI's for our Aurora PostgreSQL. When using through Interface if I restore a snapshot it creates cluster & DB instance.I understand when using CLI's first I need to...
1
answers
0
votes
200
views
asked 4 months agolg...
Hello,
Its db.r7g.8xlarge aurora postgres 32VCPU, 256GB RAM instance. PG version 15.4.
A non-partitioned table having ~4.8 billion rows in it and is having data size as ~1.4TB, row size as ~313 bytes...
0
answers
0
votes
239
views
asked 4 months agolg...
I'm trying to setup a blue/green deployment of my Postgres 14.10 database.
On the database, I can see the following settings.
| name | setting |
| --- | --- |
| max_logical_replication_workers | 4...
0
answers
0
votes
278
views
asked 4 months agolg...