PostgreSQL allows for a kind of snapshot to be taken before changes are made. Once the changes have been made, the administrator has the option to accept the changes or roll back to the previous state. Test before use. Note that any changes made between the “BEGIN” and the “ROLLBACK”
Read moreCategory: PostgreSQL
Browse our PostgreSQL Database articles here. We’ve documented and provided tutorials on installing, managing, backing up, restoring and performance tuning databases.
Splitting PostgreSQL Read and Write Queries to Different Database Servers with PGPool2
There are times when we need to send read/write queries to one server, and reads to another server (or multiple servers). If we control the application (the client), we can easily do this by coding such that different queries go to different database servers. However, what if we don’t control
Read moreInstall and Configure PostgreSQL Stream Replication
This article walks us through the process of installing and configuring two Postgres servers for stream replication. “Stream” replication allows us to replicate all databases from the master to the/a slave. There’s another kind of replication called “Logical” replication, that will replicate “individual” databases on the master to the slave.
Read more
Install PostgreSQL, Create a User/Role, Create a DB, Backup a DB, and Restore a DB
This article walks you through the process of installing PostgreSQL, creating a user, backing up a database and restoring a database. In this tutorial, we’re using Ubuntu, but the commands are the same for everything except the installation. Install PostgreSQL on Ubuntu: apt install postgresql postgresql-contrib systemctl start postgresql ufw
Read moreConfluence – Recover from User Directory Trouble
If you’re in a situation where you can’t log into Confluence because you messed up your User Directories, try these two steps. First, attempt to log in locally. If that doesn’t work, diddle with the database and reset the state of your User Directories. In this article, we’re assuming the
Read moreConfigure Metasploit with NMap and the Database – Advanced
This article walks you through the process of installing, configuring and running scans using Metasploit and Nmap. Both CentOS 7 and Ubuntu 20.04 are discussed. Our objective is to be able to run nmap scans and have the results go into a database so we can filter the results later
Read more
Installing Confluence & Migrating the Database to MySQL or PostgreSQL
This article explains the process of installing Confluence on your own server and then later migrating your content and settings from the “evaluation” database to something more professional such as MySQL or PostgreSQL. This article is basically an example with sensible assumptions. We’re using CentOS 7. When you first get
Read more
Preparing PostgreSQL for Confluence on CentOS 7
This article explains how to install and configure PostgreSQL for a Confluence on a CentOS 7 server. Read the other Confluence articles on this blog to ensure your web server (if you’re using one) is configured correctly. yum install postgresql-server postgresql-contrib Next you’ll need to do the automatic setup: postgresql-setup
Read more
How to Copy Postgresql Role Permissions From One Server to Another
This article shows how to copy role permissions from one server to another. In other words, if you’re moving a database from one server to another and you want permissions to come across too, you’ll be interested in this article. If you have trouble with this tutorial, make sure you
Read morecPanel overwriting my pg_hba.conf file
This article describes and solves (work-around) a problems with PostgreSQL and cPanel. The issue is that cPanel modifies the file “/var/lib/pgsql/9.4/data/pg_hba.conf” setting it back to a default state. This article has more information: http://www.davidghedini.com/pg/entry/installing_postgresql_9_on_cpanel By setting that file to your liking such as the following: local all all md5 host
Read more