Setting up PGCluster - Revision history

Sertonix: replace /etc/init.d with rc-service

2023-11-17T10:41:14Z

replace /etc/init.d with rc-service

← Older revision		Revision as of 10:41, 17 November 2023
Line 26:		Line 26:

	Create the database files (same as for postgresql)		Create the database files (same as for postgresql)
	{{Cmd\|~~/etc/init.d/~~pgcluster setup}}		{{Cmd\|rc-service pgcluster setup}}

	Edit the config files in the data path found above (usually /var/lib/posgresql/pgcluster)		Edit the config files in the data path found above (usually /var/lib/posgresql/pgcluster)

Zcrayfish: This software is obsolete.

2023-08-26T05:54:42Z

This software is obsolete.

← Older revision		Revision as of 05:54, 26 August 2023
Line 1:		Line 1:
			{{Obsolete\|This package is no longer a part of alpine, upstream is NOT actively maintained since early 2013}}

	PGCluster is a fork of PostgreSQL that allows multi-master replication. This document explains how to set it up.		PGCluster is a fork of PostgreSQL that allows multi-master replication. This document explains how to set it up.

Zcrayfish: /* References */ Rescued a dead link and removed some others.

2023-08-26T05:52:19Z

References: Rescued a dead link and removed some others.

← Older revision		Revision as of 05:52, 26 August 2023
Line 157:		Line 157:

	== References ==		== References ==
	* https://~~pgfoundry.org/projects/pgcluster/~~		* https://wiki.postgresql.org/wiki/PgCluster
	* https://pgcluster.i-logic.hu/cgi-bin/trac.cgi{{dead link}}
	* https://pgcluster.projects.postgresql.org/~~{{dead link}}~~
	* [https://web.archive.org/web/20090830041417/http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html PostgreSQL Replication with PGCluster (via archive.org)]		* [https://web.archive.org/web/20090830041417/http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html PostgreSQL Replication with PGCluster (via archive.org)]

	[[Category:SQL]]		[[Category:SQL]]

Sertonix: use https

2023-08-07T11:15:55Z

use https

← Older revision		Revision as of 11:15, 7 August 2023
Line 157:		Line 157:

	== References ==		== References ==
	* ~~http~~://pgfoundry.org/projects/pgcluster/		* https://pgfoundry.org/projects/pgcluster/
	* ~~http~~://pgcluster.i-logic.hu/cgi-bin/trac.cgi{{dead link}}		* https://pgcluster.i-logic.hu/cgi-bin/trac.cgi{{dead link}}
	* ~~http~~://pgcluster.projects.postgresql.org/		* https://pgcluster.projects.postgresql.org/{{dead link}}
	* [https://web.archive.org/web/20090830041417/http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html PostgreSQL Replication with PGCluster (via archive.org)]		* [https://web.archive.org/web/20090830041417/http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html PostgreSQL Replication with PGCluster (via archive.org)]

	[[Category:SQL]]		[[Category:SQL]]

Zcrayfish: /* References */ Rescued a dead link via archive.org

2021-12-23T01:35:42Z

References: Rescued a dead link via archive.org

← Older revision		Revision as of 01:35, 23 December 2021
Line 160:		Line 160:
	* http://pgcluster.i-logic.hu/cgi-bin/trac.cgi{{dead link}}		* http://pgcluster.i-logic.hu/cgi-bin/trac.cgi{{dead link}}
	* http://pgcluster.projects.postgresql.org/		* http://pgcluster.projects.postgresql.org/
	* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html~~{{dead link}}~~		* [https://web.archive.org/web/20090830041417/http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html PostgreSQL Replication with PGCluster (via archive.org)]

	[[Category:SQL]]		[[Category:SQL]]

Zcrayfish: Marked a dead link.

2021-12-20T19:01:01Z

Marked a dead link.

← Older revision		Revision as of 19:01, 20 December 2021
Line 158:		Line 158:
	== References ==		== References ==
	* http://pgfoundry.org/projects/pgcluster/		* http://pgfoundry.org/projects/pgcluster/
	* http://pgcluster.i-logic.hu/cgi-bin/trac.cgi		* http://pgcluster.i-logic.hu/cgi-bin/trac.cgi{{dead link}}
	* http://pgcluster.projects.postgresql.org/		* http://pgcluster.projects.postgresql.org/
	* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html{{dead link}}		* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html{{dead link}}

	[[Category:SQL]]		[[Category:SQL]]

Zcrayfish: /* References */ Marked a dead link.

2021-12-20T01:58:47Z

References: Marked a dead link.

← Older revision		Revision as of 01:58, 20 December 2021
Line 160:		Line 160:
	* http://pgcluster.i-logic.hu/cgi-bin/trac.cgi		* http://pgcluster.i-logic.hu/cgi-bin/trac.cgi
	* http://pgcluster.projects.postgresql.org/		* http://pgcluster.projects.postgresql.org/
	* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html		* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html{{dead link}}

	[[Category:SQL]]		[[Category:SQL]]

Dubiousjim: Category:SQL

2012-03-23T20:16:00Z

Category:SQL

← Older revision		Revision as of 20:16, 23 March 2012
Line 162:		Line 162:
	* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html		* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html

	[[Category:~~Unknown~~]]		[[Category:SQL]]

Dubiousjim: Category:Unknown

2012-03-21T15:52:59Z

Category:Unknown

← Older revision		Revision as of 15:52, 21 March 2012
Line 161:		Line 161:
	* http://pgcluster.projects.postgresql.org/		* http://pgcluster.projects.postgresql.org/
	* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html		* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html

			[[Category:Unknown]]

Fab: minor layout changes

2011-06-23T06:29:51Z

minor layout changes

← Older revision		Revision as of 06:29, 23 June 2011
Line 10:		Line 10:

	First install the packages		First install the packages
	apk add pgcluster pgcluster-client
			{{Cmd\|apk add pgcluster pgcluster-client}}

	For recovery, you'll need ssh and rsync		For recovery, you'll need ssh and rsync
	apk add openssh rsync
			{{Cmd\|apk add openssh rsync}}

	== Configuration ==		== Configuration ==
Line 22:		Line 24:

	Create the database files (same as for postgresql)		Create the database files (same as for postgresql)
	/etc/init.d/pgcluster setup		{{Cmd\|/etc/init.d/pgcluster setup}}

	Edit the config files in the data path found above (usually /var/lib/posgresql/pgcluster)		Edit the config files in the data path found above (usually /var/lib/posgresql/pgcluster)
Line 31:		Line 33:

	To start it manually:		To start it manually:
	su postgres		{{Cmd\|su postgres
	cd /var/lib/postgresql/pgcluster		cd /var/lib/postgresql/pgcluster
	pg_ctl -D . start		pg_ctl -D . start}}
	or
	postgres -D .		or

			{{Cmd\|postgres -D .}}

	==== postgresql.conf ====		==== postgresql.conf ====
Line 43:		Line 47:

	You might also want to changed the logging settings.		You might also want to changed the logging settings.


	==== pg_hba.conf ====		==== pg_hba.conf ====
Line 52:		Line 55:

	This file is new with PGCLuster - it configures the patched database instance.		This file is new with PGCLuster - it configures the patched database instance.


	Add a block like this for each replication server:		Add a block like this for each replication server:
Line 80:		Line 82:
	# <Table_Name> log_table </Table_Name>		# <Table_Name> log_table </Table_Name>
	</Not_Replicate_Info>		</Not_Replicate_Info>


	=== pgreplicate ===		=== pgreplicate ===
Line 87:		Line 88:

	To start it manually:		To start it manually:
	su postgres		{{Cmd\|su postgres
	cd /var/lib/postgresql/pgcluster		cd /var/lib/postgresql/pgcluster
	pgreplicate -D .		pgreplicate -D .}}

	If you want debug output change the last line to:		If you want debug output change the last line to:
	pgreplicate -D . -n -v		{{Cmd\|pgreplicate -D . -n -v}}

	==== pgreplicate.conf ====		==== pgreplicate.conf ====
Line 124:		Line 125:

	To start it manually:		To start it manually:
	su postgres		{{Cmd\|su postgres
	cd /var/lib/postgresql/pgcluster		cd /var/lib/postgresql/pgcluster
	pglb -D .		pglb -D .}}

	If you want debug output change the last line to:		If you want debug output change the last line to:
	~~pglb -D . -n -v~~

			{{Cmd\|pglb -D . -n -v}}

	==== pglb.conf ====		==== pglb.conf ====
Line 150:		Line 151:
	<File_Name>pg_log/pgreplicate.log</File_Name>		<File_Name>pg_log/pgreplicate.log</File_Name>
	</Log_File_Info>		</Log_File_Info>


	== Recovery ==		== Recovery ==
Line 157:		Line 157:

	== References ==		== References ==
	http://pgfoundry.org/projects/pgcluster/		* http://pgfoundry.org/projects/pgcluster/
			* http://pgcluster.i-logic.hu/cgi-bin/trac.cgi
	http://pgcluster.i-logic.hu/cgi-bin/trac.cgi		* http://pgcluster.projects.postgresql.org/
			* http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html
	http://pgcluster.projects.postgresql.org/

	http://odyssi.blogspot.com/2007/08/postgresql-replication-with-pgcluster.html