Stay up to date with the latest from the Knowledge Center. See all new Knowledge Center articles published in the last month, and re:Post's top contributors.
Questions tagged with PostgreSQL
Amazon RDS makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud.
Content language: English
Select tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
774 results
I'm encountering an issue when attempting to run the Postgres Pre-Setup Script when creating a new database
The error I'm seeing is:
`ERROR: must be owner of type numeric
SQL state: 42501`
This oc...
We’re running a Go-based application on ECS, connecting to an RDS PostgreSQL instance in the ap-southeast-1 region. Recently, we’ve seen intermittent ```could not contact db``` errors in our logs, but...
I use RDS Postgres (17.4) and I utilize less than 7GB of data but the initial size was set to 100 GB and so I was trying to shrink it using the blue/green deployment as explained here : https://repost...
I am trying to modify an RDS Postgres instance class from **db.r7g.large** to **db.t4g.small**, but I am receiving the error:
> Cannot modify the instance class because there are no instances of the r...
We're encountering an issue with IAM authentication on our RDS for PostgreSQL 17.5 instance. Connections fail with "FATAL: PAM authentication failed for user..."
# Setup & Troubleshooting:
* **RDS In...
I have a PostgeSQL version 15.12 database running in a Linux 2023 EC2 image. After I used `dnf` to update the Linux 2023 system to `Version 2023.7.20250512`, PostgreSQL is warning me:
`The database w...
I have an RDS instance with Postgres, and all of a sudden it was turned off "temporarily" for 6 days. I reviewed the Terraform code managing it, and did not find anything that could cause the instance...
I have checked multiple time and am 100% sure this is not the issue. My s3 bucket and rds is in same region. Tried creating different roles with varying permission but no luck getting same error.
The...
Hi AWS Support, I am unloading a .csv file from S3 bucket to Redshift but while running the SQL query using Workbench. Here is the code:
```
DROP TABLE IF EXISTS demo_schema.sample_backbook_data;
CR...
asked a month ago
Can Migration Evaluator discover and create a business case for migrating on-prem PostgreSQL to AWS RDS or Aurora?
When trying to import raster data into Aurora PostgreSQL, we get the error `WARNING: Unknown GDAL driver: `.
Sample import that produces the error:
```sh
$ raster2pgsql -d -f raster_data -Y 1000 -...
Hello team,
I ahve an AWS RDS for PostgreSQL (Version 13.15). An AWS DMS job moves data from RDS to AWS Redshift. I executed an SQL to alter one column of a table from int to bigint.
```
alter table...