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.
Hello All,
My team has recently been shifted to using (MIT) Kerberos for authentication to our PostgreSQL database.
We are able to successfully authenticate in dBeaver Lite, however we are not able...
0
answers
2
votes
34
views
asked an hour agolg...
Hi everyone,
I wanted to know, when you create a new Role using `CREATE ROLE` command or when you install a new extension using `CREATE EXTENSION` using one of the instances write endpoint in the...
1
answers
0
votes
41
views
asked a day agolg...
RDS Postgresql connection error "SSL SYSCALL error connection reset by peer (0x00002746/10054)"lg...
I need to connect to an RDS Posgresql which has SSL enabled and downloaded latest PgAdmin. I followed Using SSL with a PostgreSQL DB instance - Amazon Relational Database Service. I verified the...
1
answers
0
votes
120
views
asked 3 days agolg...
I have 2 VPCs, one for my EKS cluster and another for the RDS.
I have established a VPC peering between them, but I still receive errors from my application "connection timed out on port 5432".
It's...
2
answers
0
votes
275
views
asked 4 days agolg...
Hi
I have crawler engine that run on 1st and 15th every month, I noticed there is spike on checkpoint lag and CPU utilization.
Currently using: db.t3.medium instance
Checkpoint lag: from100-140 ->...
1
answers
0
votes
98
views
asked 5 days agolg...
I am trying to set up a Drupal project using Apache and I am using PostgreSQL for my database. I have set up my EC2 and RDS instances and I have checked my configurations several times, but I keep...
2
answers
0
votes
172
views
asked 6 days agolg...
Hi everyone,
We are using pg_cron extension with postgres with AWS RDS and would love to use the 'cron.timezone' option which is offered by the extension but not by AWS parameter...
1
answers
0
votes
78
views
asked 6 days agolg...
The [PostgreSQL Anonymizer](https://postgresql-anonymizer.readthedocs.io/en/stable/) is a popular extension for masking data on query results. This is unfortunately not yet supported on RDS.
One...
1
answers
0
votes
146
views
asked 7 days agolg...
Hi re:Post,
We have noted this metric FreeStorageSpace as viewed in a graph for a our RDS instance "db-demo":
![Enter image description...
1
answers
0
votes
140
views
asked 8 days agolg...
Hey all
I am trying to costout PITR.
I have a 55GB Postgres DB, I have setup the back up which is running.
it is set for 10days retention, warm storage only.
what I have worked out is:
DB_Size *...
1
answers
0
votes
137
views
asked 8 days agolg...
I am trying to connect wix site to my postgres database so i can make some integrations. I followed this guide...
2
answers
0
votes
244
views
asked 11 days agolg...
I get this error:
(psycopg2.OperationalError) could not translate host name "DBIPAddress" to address: Name or service not known
when I run the code
db= SQLDatabase.from_uri( )
I'm running the...
1
answers
0
votes
269
views
asked 11 days agolg...