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.
SQL Error [0A000]: ERROR: extension "hypopg" is not available
Detail: Could not open extension control file "/rdsdbbin/aurora-15.4.15.4.1.18244.0/share/postgresql/extension/hypopg.control": No such...
2
answers
0
votes
191
views
asked 6 months agolg...
Hi,
I am using a SQL function in postgres RDS which make http call, However we are unbale to implement it due to following reasons:
We are trying to install this extension which are use to make api...
1
answers
0
votes
270
views
asked 6 months agolg...
i ve created a rds postgres instance and AWS managed in the same VPC . created the user in AD and RDS. when i try to connect to RDS via Kerberos authentcation from the domin joined EC2, am getting the...
0
answers
0
votes
84
views
asked 6 months agolg...
Hello everyone,
I've received an unexpected charge on my AWS account. The charge was made under "Relational Database Service".
Is this because I've connected my EC2 to my RDS upon creation of my RDS...
1
answers
0
votes
213
views
asked 6 months agolg...
Hi,
In a Aurora PostgreSQL table, we would like to setup TTL (Time-to-live) kind of thing, where rows will expire or will be deleted automatically after few hours/days.
What is the best way to do...
1
answers
0
votes
1484
views
asked 6 months agolg...
I have a Postgre RDS instance running in a t3.medium. I am running a code that reads a csv in 250k chunks abd my issue is that after I bulk insert this 250k rows in a table, the database seems to get...
1
answers
0
votes
252
views
asked 6 months agolg...
I am trying to set up a Glue Job that automatically crawls a source Aurora RDS Postgres instance and writes it another instance in a different cluster.
I was able to perform an initial copy/load via...
1
answers
0
votes
357
views
asked 6 months agolg...
Is it possible to provision a Redis cache specifically for a single schema on an AWS PostgreSQL RDS, and what strategies can be employed to ensure data consistency between the Redis cache and the...
0
answers
0
votes
99
views
asked 6 months agolg...
I created connections to RDS and Redshift in AWS Glue connections. Both connections worked when running Test Connection and Crawler. I see that once in a while RDS connection test fails throwing a...
2
answers
1
votes
374
views
asked 6 months agolg...
We have a RDS - PostgreSQL db.
Auto snapshots are taken every day. Would like to change the frequency to once every week. I did not see a way to do it. Looks like I can only control the backup...
2
answers
0
votes
395
views
asked 6 months agolg...
The documentation for PostgreSQL RDS mentions an extension `rds_tools`, and there are at least 2 functions in it (`rds_version()` and `role_password_extension_type()` ) that are mentioned in passing...
0
answers
0
votes
183
views
asked 6 months agolg...
I need to provide a custom list of stop words to my postgres DB. To do this I need to update the stopwords file in $SHAREDIR/tsearch_data/.
Is it possible to do upload a file to an AWS rds instance?
1
answers
0
votes
180
views
asked 6 months agolg...