GitLab - Revision history

Mdb571: /* Hosting */

2022-11-24T03:43:54Z

Hosting

← Older revision		Revision as of 09:13, 24 November 2022
Line 3:		Line 3:
	==Hosting==		==Hosting==

	Sponsored by [http://about.gitlab.com GitLab Inc]~~. Hosted at gandi.net in France.~~		Sponsored by [https://www.infomaniak.com/en/about Infomaniak]. Hosted in Switzerland with infomaniak.com.

			Previously sponsored by [http://about.gitlab.com GitLab Inc] (2016-2022)

	==Setup==		==Setup==

Akshay: add link to common tracker, to status update

2021-08-19T12:30:28Z

add link to common tracker, to status update

← Older revision		Revision as of 18:00, 19 August 2021
Line 29:		Line 29:
	==Maintenance==		==Maintenance==

	Maintenance discussion at [https://www.loomio.org/g/Qu3O8mSf/fosscommunity-in-git-fosscommunity-in-maintainers this loomio subgroup] and [https://matrix.to/#/#git.fosscommunity.in:matrix.org this matrix chat room]		Maintenance discussion at [https://www.loomio.org/g/Qu3O8mSf/fosscommunity-in-git-fosscommunity-in-maintainers this loomio subgroup] and [https://matrix.to/#/#git.fosscommunity.in:matrix.org this matrix chat room]. Can also use the [https://git.fosscommunity.in/community/management/-/issues git tracker] for development issues.

	* [https://git.fosscommunity.in/community/gitlab/ team repo with access details] (private)		* [https://git.fosscommunity.in/community/gitlab/ team repo with access details] (private)

			If expecting service disruptions, downtime, or user-facing errors, consider adding an update to [[Status]]

	==Gitlab QA - running tests==		==Gitlab QA - running tests==

Pravs: /* Setup */ gitlabce.tk expired

2021-02-26T19:24:32Z

Setup: gitlabce.tk expired

← Older revision		Revision as of 00:54, 27 February 2021
Line 15:		Line 15:
	Letsencrypt domains:		Letsencrypt domains:

	letsencrypt --expand --webroot --webroot-path /usr/share/gitlab/public -d git.fosscommunity.in ~~-d gitlabce.tk~~ -d gitlab.debian.net -d wiki.fsci.org.in -d git.fsci.org.in certonly		letsencrypt --expand --webroot --webroot-path /usr/share/gitlab/public -d git.fosscommunity.in -d gitlab.debian.net -d wiki.fsci.org.in -d git.fsci.org.in certonly

	== Mail Server Setup ==		== Mail Server Setup ==

Pravs at 17:17, 6 March 2020

2020-03-06T17:17:17Z

← Older revision		Revision as of 22:47, 6 March 2020
Line 153:		Line 153:

	$ ps -ef \| grep sender		$ ps -ef \| grep sender
			$ psql -c "select * from pg_stat_activity where usename='rep';"

	On slave server,		On slave server,

Pravs at 17:14, 6 March 2020

2020-03-06T17:14:12Z

← Older revision		Revision as of 22:44, 6 March 2020
Line 47:		Line 47:
	Backup server is provided by Manu (KVM virtual machine with 100 GB storage and 1 GB ram). Running on debian gnu/linux 10 buster.		Backup server is provided by Manu (KVM virtual machine with 100 GB storage and 1 GB ram). Running on debian gnu/linux 10 buster.

	Documentation: https://linuxhint.com/setup_postgresql_replication/		Documentation: https://linuxhint.com/setup_postgresql_replication/ and https://www.percona.com/blog/2018/09/07/setting-up-streaming-replication-postgresql/

	===Slave configuration: Step 1===		===Slave configuration: Step 1===
Line 134:		Line 134:

	# systemctl restart postgresql		# systemctl restart postgresql

	~~Start the backup process,~~

	~~psql -c "select pg_start_backup('initial_backup');"~~
	~~rsync -cva -e 'ssh -p 12022' --inplace --exclude=pg_xlog /var/lib/postgresql/11/main/ 62.210.83.200:/var/lib/postgresql/11/main/~~
	~~psql -c "select pg_stop_backup();"~~

	Open 5432 port in the firewall		Open 5432 port in the firewall
Line 146:		Line 140:

	===Slave Configuration: Step 2===		===Slave Configuration: Step 2===
	~~Create a recovery file called~~ recovery.conf ~~and add following lines.~~
	~~standby_mode = 'on'~~		Copy data from master and create recovery.conf
	~~primary_conninfo = 'host=213~~.~~167~~.~~243.152 port=5432 user=~~rep ~~password~~=~~yourpassword'~~		$ pg_basebackup -h git.fosscommunity.in -D /var/lib/postgresql/11/main/ -P -U rep --wal-method=fetch -R
	~~trigger_file = '/tmp/postgresql.trigger.5432'~~

	Start the slave server		Start the slave server

Pravs: /* Backup */ update for postgresql 11

2020-03-06T13:05:47Z

Backup: update for postgresql 11

← Older revision		Revision as of 18:35, 6 March 2020
Line 45:		Line 45:
	==Backup==		==Backup==

	Backup server is provided by Manu. Running on debian gnu/linux ~~9 stretch~~.		Backup server is provided by Manu (KVM virtual machine with 100 GB storage and 1 GB ram). Running on debian gnu/linux 10 buster.

			Documentation: https://linuxhint.com/setup_postgresql_replication/

	===Slave configuration: Step 1===		===Slave configuration: Step 1===
	Install postgresql and rsync		Install postgresql and rsync

	# apt-get install postgresql-contrib-~~9.6~~ rsync		# apt-get install postgresql-contrib-11 rsync

			Check postgresql server is running

			# su postgres -c psql

	Make sure en_US.UTF-8 locale is available		Make sure en_US.UTF-8 locale is available
Line 59:		Line 65:

	# su - postgres		# su - postgres
	$ ssh-keygen		$ ssh-keygen -t ed25519

	Now copy /var/lib/postgresql/.ssh/~~id_rsa~~.pub to master postgres users' /var/lib/postgresql/.ssh/authorized_keys		Now copy /var/lib/postgresql/.ssh/id_ed25519.pub to master postgres users' /var/lib/postgresql/.ssh/authorized_keys

	Stop postgresql before changing any configuration		Stop postgresql before changing any configuration
	~~$ pg_ctlcluster 9.6~~ main ~~stop~~		# systemctl stop postgresql@11-main

	cd /etc/postgresql/~~9.6~~/main		as postgres user
			$ su - postgres
			$ cd /etc/postgresql/11/main

	Open the postgres configuration file		Open the postgres configuration file

	nano postgresql.conf		$ nano postgresql.conf

	Set the following configuration options in the postgresql.conf file		Set the following configuration options in the postgresql.conf file

	listen_addresses = 'localhost,192.168.0.115'		listen_addresses = 'localhost,192.168.0.115'
	port=5432		port=5432
	wal_level = ~~'hot_standby'~~		wal_level = replica
			max_wal_senders = 1
	archive_mode = on		archive_mode = on
	archive_command = 'cd .'		archive_command = 'cd .'
	~~max_wal_senders = 1~~
	hot_standby = on		hot_standby = on

Line 96:		Line 105:
	Allow slave to connect to master using the user just created.		Allow slave to connect to master using the user just created.

	$ cd /etc/postgresql/~~9.6~~/main		$ cd /etc/postgresql/11/main

	$ nano pg_hba.conf		$ nano pg_hba.conf
Line 112:		Line 121:
	listen_addresses = 'localhost,213.167.243.152'		listen_addresses = 'localhost,213.167.243.152'
	port=5432		port=5432
	wal_level = ~~'hot_standby'~~		wal_level = replica
			max_wal_senders = 1
	archive_mode = on		archive_mode = on
	archive_command = 'cd .'		archive_command = 'cd .'
	~~max_wal_senders = 1~~
	hot_standby = on		hot_standby = on

	Now, to activate your changes, reload the postgresql server		Now, to activate your changes, reload the postgresql server

	~~$ pg_ctlcluster 9.6~~ main ~~reload~~		# systemctl reload postgresql@11-main

	You may need to restart it via systemd,		You may need to restart it via systemd,
Line 129:		Line 138:

	psql -c "select pg_start_backup('initial_backup');"		psql -c "select pg_start_backup('initial_backup');"
	rsync -cva -e 'ssh -p 12022' --inplace --exclude=pg_xlog /var/lib/postgresql/~~9.6~~/main/ 62.210.83.200:/var/lib/postgresql/~~9.6~~/main/		rsync -cva -e 'ssh -p 12022' --inplace --exclude=pg_xlog /var/lib/postgresql/11/main/ 62.210.83.200:/var/lib/postgresql/11/main/
	psql -c "select pg_stop_backup();"		psql -c "select pg_stop_backup();"

			Open 5432 port in the firewall

			# ufw allow from 62.210.83.200 to any port 5432 proto tcp

	===Slave Configuration: Step 2===		===Slave Configuration: Step 2===
Line 140:		Line 153:
	Start the slave server		Start the slave server

	~~$ pg_ctlcluster 9.6~~ main ~~start~~		# systemctl start postgresql@11-main

	===Replication Status===		===Replication Status===

Pravs: update gitlab setup section

2020-03-06T09:25:12Z

update gitlab setup section

← Older revision		Revision as of 14:55, 6 March 2020
Line 3:		Line 3:
	==Hosting==		==Hosting==

	Sponsored by [http://about.gitlab.com GitLab Inc].Hosted at gandi.net in France.		Sponsored by [http://about.gitlab.com GitLab Inc]. Hosted at gandi.net in France.

	==Setup==		==Setup==

	Running on debian gnu/linux ~~9 stretch~~ with postgresql ~~9.6~~. Using gitlab package from ~~https~~://~~people~~.debian.~~org/~praveen/gitlab/~~		Running on debian gnu/linux 10 buster with postgresql 11. Using gitlab package from http://fasttrack.debian.net

	~~Note~~: ~~We install~~ gitlab ~~dependencies from stretch-backports, so all apt commands should enable stretch-backports (''apt -t stretch-backports'')~~.		Check https://wiki.debian.org/gitlab for installation/update instructions.

	Debian package specific documentation -> https://salsa.debian.org/ruby-team/gitlab/raw/~~stretch~~-~~backports~~/debian/README.Debian		Debian package specific documentation -> https://salsa.debian.org/ruby-team/gitlab/raw/buster-fasttrack/debian/README.Debian

	Letsencrypt domains:		Letsencrypt domains:

Pravs: /* Maintenance */ add qa tasks here

2018-12-15T18:11:46Z

Maintenance: add qa tasks here

← Older revision		Revision as of 23:41, 15 December 2018
Line 32:		Line 32:

	* [https://git.fosscommunity.in/community/gitlab/ team repo with access details] (private)		* [https://git.fosscommunity.in/community/gitlab/ team repo with access details] (private)

			==Gitlab QA - running tests==

			<Create a user account for QA>

			<code>
			$ sudo gem install gitlab-qa

			$ GITLAB_USERNAME=<username> GITLAB_PASSWORD=<password> gitlab-qa Test::Instance::Any gitlab/gitlab-ce-qa:<gitlab version> https://git.hacksk.xyz
			</code>

	==Backup==		==Backup==

Pravs: /* Setup */ add link to documentation

2018-10-10T07:21:55Z

Setup: add link to documentation

← Older revision		Revision as of 12:51, 10 October 2018
Line 10:		Line 10:

	Note: We install gitlab dependencies from stretch-backports, so all apt commands should enable stretch-backports (''apt -t stretch-backports'').		Note: We install gitlab dependencies from stretch-backports, so all apt commands should enable stretch-backports (''apt -t stretch-backports'').

			Debian package specific documentation -> https://salsa.debian.org/ruby-team/gitlab/raw/stretch-backports/debian/README.Debian

	Letsencrypt domains:		Letsencrypt domains:

Pravs: /* Setup */ mention stretch-backports

2018-10-10T07:18:16Z

Setup: mention stretch-backports

← Older revision		Revision as of 12:48, 10 October 2018
Line 8:		Line 8:

	Running on debian gnu/linux 9 stretch with postgresql 9.6. Using gitlab package from https://people.debian.org/~praveen/gitlab/		Running on debian gnu/linux 9 stretch with postgresql 9.6. Using gitlab package from https://people.debian.org/~praveen/gitlab/

			Note: We install gitlab dependencies from stretch-backports, so all apt commands should enable stretch-backports (''apt -t stretch-backports'').

	Letsencrypt domains:		Letsencrypt domains: