Blog: Denish Patel

210 blogs updated: 62 min. ago
Audit logging with Postgres partitioning
As I mentioned in my previous post "Audit logging using JSONB in Postgres" , audit tables can be partitioned easily in Postgres 10. Let's us...
09-07-2018 21:24:52 Denish Patel PostgreSQL
Audit logging using JSONB in Postgres
Recently, someone reached out to me asking "what's the best way to achieve database DML auditing in Postgres?" I have suggested a couple of ...
06-07-2018 19:49:21 Denish Patel PostgreSQL
Connecting Postgres to Active Directory for Authentication
I have connected our Postgres instance to Active Directory for authentication because I didn't want to manage passwords for hundreds for use...
10-01-2018 22:20:08 Denish Patel PostgreSQL
Tracing Tableau to Postgres connectivity issue using Wireshark!
I spent last couple of weeks trying to resolve connection issues from Tableau Server 10.3 to Postgres 9.6.6. If you are not familiar with Ta...
26-12-2017 22:26:20 Denish Patel PostgreSQL
Christmas Gift!
Merry Christmas!! If you are using SQL Server or Oracle databases, I'm giving away my 1 hour of time for rest of this week for free of cost ...
26-12-2016 20:45:06 Denish Patel PostgreSQL
Running Postgres in Docker
For last six months, I have been working on moving Postgres from bare metal & VM based systems in Docker. As of today, we have migrated a co...
30-11-2016 00:15:51 Denish Patel PostgreSQL
YUM repo location & HTTPS change for Postgres !
As Devrim blogged about changes in Postgres YUM repo location changes, I wanted to write down procedure I have to follow this morning for my...
29-09-2016 18:09:18 Denish Patel PostgreSQL
Advanced Postgres Monitoring!
Today, I presented at PgOpen 2016 (Postgres conference) in Dallas, TX. Here is the slide deck :
15-09-2016 17:37:59 Denish Patel PostgreSQL
Recovering Postgres database from disk level corruption!!
A couple of weeks ago, I had to deal with corrupted Postgres database cluster. At the end, we couldn't able to recover some of the data but ...
10-09-2016 01:46:06 Denish Patel PostgreSQL
Analyzing effect on default_statistics_target on ANALYZE
Last week, I received request to increase PostgreSQL's config parameter default_statistics_target on one of the very large DB clusters. The ...
16-01-2016 08:47:55 Denish Patel PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.