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 have an RDS PostgreSQL instance that I would like to keep in the Free Tier. However, after a month with minimal data (6 tables with no data and one table with 5 rows and 4 columns of varchars and...
2
answers
0
votes
190
views
asked 3 months agolg...
What is the correct way to handle Postgres logical replication with DMS CDC after Postgres major update?
Found out that RDS requires removal of logical replication slots before Postgres major version...
1
answers
0
votes
337
views
asked 3 months agolg...
I have a scenario where I need to move data from S3 to a Postgres database running on an EC2 instance. All of this is part of cdk app so I'm looking to add this as a step to the current step function....
1
answers
0
votes
293
views
asked 3 months agolg...
Hello
I have created AWS RDS DB Proxy in Terraform to connect through it with our application. We are using ssl root certs for encryption. And everything works fine if connect from app to DB...
4
answers
0
votes
499
views
asked 3 months agolg...
We need a working fulltext search on aurora postgres, so we need to create a custom dictionary.
How can we install/upload the dictionary files to the server.
1
answers
0
votes
224
views
asked 3 months agolg...
When config Grafana Postgres data source; host, user, pwd, etc with AWS RDS credentials i get the error: `pq: no pg_hba.conf entry for host "X.X.X.X", user "xxxx", database "xxxx", no...
2
answers
0
votes
549
views
asked 3 months agolg...
I'm trying to write a script to upgrade an RDS PostgreSQL instance from version x to version y. Since RDS only supports direct upgrades to certain versions, the script uses multiple "hops" to upgrade,...
0
answers
0
votes
150
views
asked 3 months agolg...
Hello,
I am thinking of using the [aws-advanced-jdbc-wrapper](https://github.com/awslabs/aws-advanced-jdbc-wrapper). My setup consists of a single PostgreSQL RDS instance (non-clustered) but with...
1
answers
0
votes
403
views
asked 3 months agolg...
Hello All!
Would like to Importing data from Amazon S3 into an RDS for PostgreSQL DB instance, but something is wrong from my side:
ERROR: HTTP -1. curlCode: 28, Timeout was reached
CONTEXT: SQL...
2
answers
0
votes
525
views
asked 3 months agolg...
I have an Amazon RDS instance with an allocated storage of 3000GB, but the actual storage usage is only around 1300GB. This means I'm paying for 1700GB of storage that I'm not utilizing, incurring...
2
answers
0
votes
303
views
asked 3 months agolg...
Hi there,
Can I use RDS PostgreSQL for the continues data feed? I expect at least 100 Records per minute to being with. I expect the application insert the data in to the RDS PostgreSQL 24x7x365...
Accepted AnswerPostgreSQL
1
answers
0
votes
170
views
asked 3 months agolg...
Hi team,
Is the wal_level modifiable from replica to logical in aurora PostgreSQL ?
I can see rds.logical_replication as modifiable parameter. But when I create a new parameter group for Aurora, it...
2
answers
0
votes
415
views
asked 3 months agolg...