Menu

Tag: postgresql

Creating a read-only user in PostgreSQL

First you need to create a ‘role’ (i.e. a user). You possibly also want the password to never expire: CREATE ROLE averagejoe LOGIN ENCRYPTED PASSWORD ‘***’ NOINHERIT VALID UNTIL ‘infinity’; Now grant this role access to the selected database: GRANT CONNECT ON DATABASE cooldb TO averagejoe; Now connect to said database: \c cooldb Allow SELECT […]

Upgrading GitLab with external PostgreSQL

If you’ve migrated from the internal PostgreSQL instance to an external one, you’ll see something like this, when trying to update: [[email protected] ~]# yum update Loaded plugins: fastestmirror, post-transaction-actions Loading mirror speeds from cached hostfile * base: ftp.foobar.org * extras: ftp.foobar.org * updates: ftp.foobar.org gitlab_gitlab-ce/x86_64/signature | 836 B 00:00:00 gitlab_gitlab-ce/x86_64/signature | 1.0 kB 00:00:00 !!! […]

Migrating GitLab from internal to external PostgreSQL

PostgreSQL Installation This will cover CentOS 7 and PostgreSQL 10, and GitLab 10/11 installed using Omnibus. On other systems YMMV. Find the URL for the current CentOS 7 PostgreSQL RPM, then install it. E.g.: yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm Then open /etc/yum.repos.d/CentOS-Base.repo and add to the base and updates sections: exclude=postgresql* Install the server and the contrib […]

Installing GitBucket with PostgreSQL and Tomcat on CentOS 7

Preamble When it comes to on-premises Git hosting, GitBucket is definitely my current favorite. It has monthly updates, LDAP authentication, email notifications, forks, wikis, issues, pull requests, inline commenting, public and private repos, plugins, skins, protected branches, HTTP and SSH transports… you name it, man. I’ve already sent a few patches to its current maintainer, […]

Redmine on CentOS 7

NOTE: This tutorial is for Redmine 2. For Redmine 3, make sure to read Redmine 3 on CentOS 7 as well. Preamble This is a supplementary blogpost for my previous post, Installing, Migrating & Upgrading Redmine with LDAP on Ubuntu. I’m not going to cover the migration, upgrade, authentication, etc. parts again coz they’re almost […]

Installing, Migrating & Upgrading Redmine with LDAP on Ubuntu

Preamble Note for CentOS users: please refer to my more recent guide, Redmine on CentOS 7 This article will guide you through the installation, migration and upgrading of a Redmine instance on Ubuntu Server 13.10. The article’ll also explain how to switch from an SQLite database backend to PostgreSQL. For authentication we’ll be using LDAP. […]