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.
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
190
views
asked 2 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
107
views
asked 2 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
353
views
asked 2 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
72
views
asked 2 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
121
views
asked 2 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
183
views
asked 2 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
94
views
asked 3 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
131
views
asked 3 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
166
views
asked 3 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
230
views
asked 3 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
267
views
asked 3 months agolg...
Hi,
I have a use case for comparing two DB snapshot engine versions. From https://docs.aws.amazon.com/sdkfornet/latest/apidocs/items/TRDSDBSnapshotNET45.html, Engine Versions come as strings. Engine...
2
answers
0
votes
253
views
asked 3 months agolg...