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 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
431
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
2072
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
1038
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
2142
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
303
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
3284
views
asked a year agolg...
For context see [announcement](https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-rds-postgresql-pgvector-ml-model-integration/) of pgvector support in the RDS for PostgreSQL 15.2.
pgvector...
1
answers
0
votes
645
views
asked a year agolg...
I am trying to load data from my AWS RDS PostgreSQL v14.7 instance hosted on ECS, and I kept getting the following error whenever I test my connection in the AWS Glue connectors:
```
Check that your...
0
answers
0
votes
70
views
asked a year agolg...
Hello,
As a student, I'm currently training in AWS architecture.
My project is the following:
- Using a python script to scrape data every day, which is stored in an S3 bucket (700kb CSV file)
-...
2
answers
1
votes
249
views
asked a year agolg...
We are trying to restore a PSQL DB snapshot. However, our DB Instance Class dropdown menu is empty and we cannot move forward. This is happening across both Firefox and Chrome so I don't believe it to...
3
answers
0
votes
626
views
asked a year agolg...
I have built and published PostgresDB community component . But the deployment of the component is failing with following error message:
We have verified that AWSIOT is installed...
1
answers
0
votes
215
views
asked a year agolg...
AWS Lightsail Databases: Loading data from s3 into Postgres using the aws_s3 postgres extension.lg...
Previously, using AWS RDS for Postgres, I have loaded data directly from s3 buckets into psotgres database tables using functions such as ***aws_s3.table_import_from_s3***
Does this same...
2
answers
0
votes
315
views
asked a year agolg...