Skip to main content

Posts

Showing posts from March, 2019

atlassian database configuration file

Where is the Database configuration file? I "often" have to change the database location from "localhost" to another one in the Atlassian products I use and I spend some amount of time figuring out where is the configuration stored. Here I am. Bamboo database configuration is in "bamboo-home/bamboo.cfg.xml" Bitbucket database configuration is in "application-data/shared/bitbucket.properties" Confluence database configuration is in "confluence/application-data/confluence.cfg.xml" Jira database configuration is in "jira/application-data/dbconfig.xml"

move postgresql datadir

How to move PostgreSQL datadir The context I run RHEL 7 and CentOS 7 . The sysadmin team has setup a virtual machine for me and they put a big "/data" partition. The default PostgreSQL installation usually use "/var/lib/pgsql" for PostgreSQL location. I want to change it to "/data/pgsql" How to Stop PostgreSQL systemctl stop postgresql Move  "/var/lib/pgsql" and retain ownership & permissions rsync -av /var/lib/pgsql /data/ Note: don't remove "/var/lib/pgsql" yet! Configure "/data/pgsql/data/postgresql.conf" with the new location: - #data_directory = 'ConfigDir'           + data_directory = '/data/pgsql/data' Configure systemd service file "/usr/lib/systemd/system/postgresql.service" - Environment=PGDATA=/var/lib/pgsql/data + Environment=PGDATA=/data/pgsql/data Start PostgreSQLand check it all: # systemctl start postgresql # systemctl status postgresql # ps aux | grep pgsql #