By using AWS re:Post, you agree to the AWS re:Post Terms of Use

Questions tagged with Database

Benefit from the broadest selection of purpose-built databases for all your application needs

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.

1683 results
#### **Issue Summary** We are experiencing an issue with our AWS RDS PostgreSQL database (Postgres version 16 upgraded to 17 a while ago - likely when the problem started) where rows in a specific tab...
2
answers
0
votes
27
views
profile picture
asked 13 hours ago
What are the conditions that cause private IP address changes in Amazon RDS? The following site explains the conditions under which RDS IP addresses can change: https://repost.aws/knowledge-center/rd...
1
answers
0
votes
24
views
asked 2 days ago
I want to create an external table to copy s3 data int htat table for the use of redshift spectrum. The specified location includes parquet and mp4 files. I only want to copy the parquet files. And ...
1
answers
0
votes
19
views
asked 7 days ago
Hi all, I have created foreign data wrappers for both RDS PostgreSQL and RDS SQL Server databases and can successfully read from these, so my issue does not relate at all to the connections here. Wha...
1
answers
0
votes
39
views
asked 8 days ago
we have a manufacturing client and they have 20 distributors. Each of them needs to have inventory and financial accounting management ERP. So we need to keep a separate Database for them. In the f...
1
answers
0
votes
19
views
asked 9 days ago
I have an RDS Oracle reserved instance (1 yr, all upfront) with db.r5.8xlarge class. I want to downgrade it to db.r5.4xlarge due to less usage during the next renewal. Can I upgrade it back to db.r5.8...
2
answers
0
votes
29
views
asked 10 days ago
i need to do beginsWith on the account and folder hierarchy paths. Example: accountHierarchyPath: account1#account2#account3 pageHierarchyPath: folder1#folder2#folder3 i would like to do beginsWith a...
1
answers
0
votes
18
views
asked 11 days ago
I have a temporary table created with a name based on a numeric ID. This table is sometimes created with a 0 as the leading character of the digits in the table name such as: "schema_name"."tmp_012345...
1
answers
0
votes
22
views
asked 13 days ago
I have created RDS instance which has public access but unable to connect it using pgAdmin, I have attached security group which has port 5432 open, getting connection timeout issue message in pgAdmin...
1
answers
0
votes
48
views
asked 13 days ago
I have created a DMS task that replicated a table along with changes to S3 - but the CDC files lack the column name. I have the AddColumnName set to true, and my initial table load file has the column...
3
answers
0
votes
32
views
asked 13 days ago
Hi, I am a total newbie to DocumentDB or MongoDB. Unfortunately, need to check on everything that get send my way :-) One of our clients thinks the DocumentDB is 'bloated', fragmented or has lots of ...
1
answers
-1
votes
35
views
asked 14 days ago
Hello I am trying to change the date format of my AWS Lightsail Database (Postgresql) to ISO DMY When I connect to pdAdmin with the command SELECET NOW(); the result I get is. YYYY...
1
answers
0
votes
21
views
asked 16 days ago