So you’ve installed postgres onto your machine, and you want to start working with it.
How?
The key to understanding the post-installation procedure is to realize that it “depends”.
It “depends” on the OS i.e. MSWindows vs Linux.
It “depends” on the flavor of Linux i.e. Debian vs RedHat.
It “depends” if it’s a package install or from source […]
Today I’m going to talk about my favorite trope, “database security”.
When done right, a good security policy not only protects your data but improves performance, system stability, and enhances the development life-cycle. When done wrong it not only risks the confidentiality and integrity of your data but it leaves your organization open to significant […]
Security, when done right, not only protects your data but improves performance, system stability, and enhances the development life-cycle. Because PostgreSQL security can easily become an all-encompassing activity, we’ll deal with the most common mechanisms.
Three files control security in the postgres data cluster but for our purposes, we’ll deal only with postgresql.conf and pg_hba.conf, […]
Taking our cue from Peter Zaitsev’s article on MySQL Performance Bottlenecks, I’m going to talk a little about the PostgreSQL perspective of removing bottlenecks caused by high traffic.
Many stacks these days are implemented by trusting the Object Relational Mapper, ORM, to do the right thing with PostgreSQL while one creates critical business logic on […]
Mastering Geographical Information Systems, better known simply as GIS, can be considered in some ways as a rite of passage. The complexities and challenges involved learning, what are ostensibly non-IT concepts, is steep. However, as they say, “there’s more than one way to skin a cat“. I’d like to share with you one way […]
Read more