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.
How to setup PostgreSQL in an AWS Local Zone
1
answers
0
votes
680
views
asked a year agolg...
Error from the log.
From PG_upgrade_Internal.log
Checking for presence of required libraries fatal
Your installation references loadable libraries that are missing from the
new...
1
answers
0
votes
257
views
asked a year agolg...
pgvector for Auroralg...
Any plans on allowing us to use pgvector in Aurora?
4
answers
0
votes
1362
views
asked a year agolg...
I am trying to connect to my Aurora PostgreSQL db, you must forgive me for I am new to AWS.
these settings keep returning this error in datagrip
> DBMS: PostgreSQL (no ver.)
Case sensitivity:...
2
answers
0
votes
3803
views
asked a year agolg...
Hi all,
I have the production MariaDB instance in RDS and I need to create a Postgres replica of it. (Asyncronous daily replication)
Which service would allow me to do that? Basically what I need is a...
1
answers
0
votes
259
views
asked a year agolg...
Hi All,
I am working on database architecture for my company and unable to decide whether should I go for Multi-AZ DB Cluster or Multi-AZ DB Instance for Amazon RDS for PostgreSQL. Can anyone help...
1
answers
0
votes
1376
views
asked a year agolg...
I would really like to reduce the retention period for logs, or at least verify the default value of 3 days.
I know I can't access it without being a super-user, and ChatGPT recommends reachingout to...
Accepted AnswerPostgreSQL
1
answers
0
votes
405
views
asked a year agolg...
Hello AWS community,
I am encountering an issue while attempting to insert records into a table in Amazon Redshift, and I'm seeking assistance from the community to help me resolve it. The error...
3
answers
0
votes
1989
views
asked a year agolg...
Json data is being considered as string while loading data from postgres to json file by AWS Gluelg...
I want to migrate postgres data to redshift, but I have a lot of jsonb data in postgres so for that I had given SUPER data type in Redshift but the problem here is while loading the data to redshift...
1
answers
0
votes
1015
views
asked a year agolg...
I have created a database instance in RDS postgres having below details in the screenshot
![Enter image description here](/media/postImages/original/IMuOVwHPyzRNGULVJhjDzIFg)
Security group inbound...
4
answers
1
votes
2057
views
asked a year agolg...
Hello,
We are currently running our production rds on 10.23 version.. which is being deprecated.. So while we are trying to upgrade the snapshot it is npot being upgraded to the next version ie....
1
answers
0
votes
291
views
asked a year agolg...
Hello,
I'm trying to understand why the GB-Mo keep growing on my RDS instance without using it. So I tired to check the size of the log files with :
```
SELECT name, setting AS file_path,...
5
answers
1
votes
3176
views
asked a year agolg...