Unanswered 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.
My system has a write intensive workload largely consisting of deletes and inserts. The work is applied by drawing from queues such that I can control the concurrency. The transactions touch about...
0
answers
0
votes
118
views
asked a year agolg...
Hi,
I have created a managed database in my Lightsail dashboard (PostgreSQL database (15.2) / 240 GB SSD).
On the networking tab I have enabled the "Public mode".
I can connect using a desktop...
0
answers
0
votes
185
views
asked a year agolg...
How to force stop a hung aws rds cluster. I was upgrading aurora pg 14.5 to 15.2 and cluster is hung in upgrading ...
log says .. database system shutting down
0
answers
0
votes
68
views
asked a year agolg...
Database owner does not have (implicit) **usage** permissions for `pg_database_owner` unless triggered by "related" query.
## First false, then true
```
initech=> \conninfo
You are connected to...
0
answers
0
votes
80
views
asked a year agolg...
I have created AWS Aurora Read Replica from RDS PostgreSQL Primary database.
After creating Aurora Read Replica I have enabled Performance Insights for it, once it is enabled I started using Aurora...
0
answers
0
votes
105
views
asked a year agolg...
Greetings.
A while ago I created an Aurora instance to migrate my database, but it had a lot of performance issues. Responses are 2-3 times slower than normal on the current host (digital ocean). How...
0
answers
0
votes
62
views
asked a year agolg...
Newer versions of Amazon Aurora PostgreSQL-compatible edition are now available and database cluster(s) running Aurora PostgreSQL minor versions 11.13, 11.14, 11.15, 12.8, 12.10, 13.4, 13.5, and 13.6...
0
answers
0
votes
406
views
This seems like a zeitwerks load issue ... I have manually set the value in ENV same error -
Here is code block of message with trace:
```
`program:~/environment/timpdaley_2 (upgradeRails61to70) $...
0
answers
0
votes
105
views
asked a year agolg...
I've been leveraging the pg_cron extension to run scheduled precompute jobs within the Postgres DB for over a year now, and have never had this issue.
This extension comes with a table that logs the...
0
answers
0
votes
76
views
asked a year agolg...
Hi,
I have a PostgreSQL RDS instance (subscriber) that lives in the same AZ and VPC as an EC2 machine with PostgreSQL (publisher). I established logical replication subscription against the publisher...
0
answers
2
votes
144
views
asked a year agolg...
I am trying to migrate data from an on prem SQL Server DB to Postgres Aurora using AWS DMS. The data migrates just fine, but for tables that have a boolean column in the primary key, during validation...
0
answers
0
votes
90
views
asked a year agolg...
Hello friends!
Today I have a big problem that I cannot extend the user who requests information from the RDS through Power BI using the solution that Amazon provides at this...
0
answers
0
votes
106
views
asked a year agolg...