Da Kiwi

postgresql_upgrade_on_freebsd

anonymous@undisclosed.example.com (Anonymous) — Mon, 29 Sep 2025 11:54:15 +0000

2023/09/25 16:51		current
Line 2:		Line 2:

	For minimal downtime during migration, we will use `pg_upgrade` tool, which needs both old and new PostgreSQL binaries available. To do so, we will use FreeBSD's ports system, without `make clean` at first to keep compiled binaries.		For minimal downtime during migration, we will use `pg_upgrade` tool, which needs both old and new PostgreSQL binaries available. To do so, we will use FreeBSD's ports system, without `make clean` at first to keep compiled binaries.
-
	## A note about locales		## A note about locales

-	You might encounter weird locales issue while ensuing `initdb` command, like this:	+	You might encounter weird locale issue while ensuing `initdb` command, like this:

	```bash		```bash
Line 11:		Line 10:
	```		```

-	The only workaround I found was to disable locale detection in the source code:	+	This seems to be caused by a [remaining deprecated locale](https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=274718#c12). You can delete it by using the following command, depending on if you're running PostgreSQL in a jail (I didn't find a cleaner way, sorry):

-	```diff	+	```bash
-	--- /var/ports/basejail/usr/ports/databases/postgresql15-server/work/postgresql-15.2/src/backend/utils/adt/pg_locale.c 2023-08-22 18:55:52.003715000 +0200	+	sudo rm -rf /usr/share/locale/sr_YU.ISO8859-5
-	+++ /tmp/pg_locale.c 2023-08-22 18:54:40.437733000 +0200	+	sudo rm -rf /basejail/usr/share/locale/sr_YU.ISO8859-5
-	@@ -1727,8 +1727,8 @@	+
-	freelocale(loc);	+
-	}	+
-	else	+
-	- // ereport(ERROR,	+
-	- // (errmsg("could not load locale \"%s\"", collcollate)));	+
-	+ ereport(ERROR,	+
-	+ (errmsg("could not load locale \"%s\"", collcollate)));	+
-	#elif defined(WIN32) && _WIN32_WINNT >= 0x0600	+
-	/*	+
-	* If we are targeting Windows Vista and above, we can ask for a name	+
	```		```
-
-	You can apply this patch while compiling new version's port (issue `make`, stop it with ctrl+c after download and extract, patch, then issue `make` again)

	## Compile old and new version from ports		## Compile old and new version from ports

syntax

anonymous@undisclosed.example.com (Anonymous) — Wed, 22 Jul 2026 19:16:28 +0000

2025/05/26 15:34		current
Line 9:		Line 9:
	DokuWiki supports bold, //italic//, __underlined__ and ''monospaced'' texts.		DokuWiki supports bold, //italic//, __underlined__ and ''monospaced'' texts.
	Of course you can __//''combine''//__ all these.		Of course you can __//''combine''//__ all these.
		+
		+	Note that the formatting markers have to directly enclose the text, so ''%% bold %%'' with spaces inside the markers will not be formatted.

	You can use <sub>subscript</sub> and <sup>superscript</sup>, too.		You can use <sub>subscript</sub> and <sup>superscript</sup>, too.
Line 156:		Line 158:
	{{wiki:dokuwiki-128.png }}		{{wiki:dokuwiki-128.png }}
	{{ wiki:dokuwiki-128.png }}		{{ wiki:dokuwiki-128.png }}
		+
		+	You can also set the alignment explicitly with a ''?left'', ''?right'' or ''?center'' parameter. This takes precedence over the whitespace alignment above and can be combined with a size.
		+
		+	{{wiki:dokuwiki-128.png?100&right}}
		+
		+	{{wiki:dokuwiki-128.png?100&right}}

	Of course, you can add a title (displayed as a tooltip by most browsers), too.		Of course, you can add a title (displayed as a tooltip by most browsers), too.

groupware_toaster

anonymous@undisclosed.example.com (Anonymous) — Wed, 21 Jun 2023 20:35:39 +0000

2023/06/11 01:27		current
Line 147:		Line 147:

	* If using classic skin, replace the strange "interrogation mark" button by a prettier one:		* If using classic skin, replace the strange "interrogation mark" button by a prettier one:
		+
	<code bash>		<code bash>
	mv plugins/agendav/skins/classic/agendav.gif plugins/agendav/skins/classic/agendav.old.gif		mv plugins/agendav/skins/classic/agendav.gif plugins/agendav/skins/classic/agendav.old.gif

ipsec

anonymous@undisclosed.example.com (Anonymous) — Fri, 09 Mar 2012 21:43:38 +0000

2011/01/30 14:26		current
Line 1:		Line 1:
	====== IPSec for FreeBSD's jails communication ======		====== IPSec for FreeBSD's jails communication ======

-	Abstract: Here we assume we have two FreeBSD hosts, A using public IP 1.1.1.1 and internal virtual net 192.168.3.0 for jails, and B using public IP 2.2.2.2 and internal net 192.168.6.0 for jails. We need hosts and jails to communicate together, preferably in a encrypted way.	+	Abstract: Here we assume we have two FreeBSD hosts, A using public IP 1.1.1.1 and internal virtual net 192.168.3.0 for jails, and B using public IP 2.2.2.2 and internal net 192.168.6.0 for jails. We need hosts and jails to communicate together, preferably in a crypted way.

	===== Preparation on both hosts =====		===== Preparation on both hosts =====

start

anonymous@undisclosed.example.com (Anonymous) — Thu, 03 Sep 2026 19:47:52 +0000

2023/09/25 11:54		current
Line 14:		Line 14:
	* [[public:deinstall_removed_port\|Deinstall an already removed port on FreeBSD]]		* [[public:deinstall_removed_port\|Deinstall an already removed port on FreeBSD]]
	* [[public:gemini_toaster\|Installing vger on FreeBSD, using inetd and nginx]]		* [[public:gemini_toaster\|Installing vger on FreeBSD, using inetd and nginx]]
-	* [[public:postgresql_upgrade_on_freebsd\|Migration a PostgreSQL cluster using FreeBSD ports]]	+	* [[public:postgresql_upgrade_on_freebsd\|Migration of a PostgreSQL cluster using FreeBSD ports]]
	<newcolumn>		<newcolumn>
	Networking		Networking

mysql

anonymous@undisclosed.example.com (Anonymous) — Sun, 05 Apr 2026 09:06:50 +0000

2022/08/04 15:35		current
Line 161:		Line 161:

	* stop slave		* stop slave
-	<code sql>	+
		+	```sql
	mysql> STOP SLAVE;		mysql> STOP SLAVE;
-	</code>	+	```
	* either manually delete the duplicate entry, or skip counter by issuing:		* either manually delete the duplicate entry, or skip counter by issuing:
-	<code sql>	+
		+	```sql
	mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;		mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
-	</code>	+	```
	* start slave		* start slave
-	<code sql>	+
		+	```sql
	mysql> START SLAVE;		mysql> START SLAVE;
-	</code>	+	```

	==== rebuild database indexes ====		==== rebuild database indexes ====

android_camera

anonymous@undisclosed.example.com (Anonymous) — Fri, 30 Mar 2012 21:17:04 +0000

2012/03/30 23:14		current
Line 2:		Line 2:

	<note warning>		<note warning>
-	Note: this require root access to the terminal; also, this has been only tested under CyanogenMod 7.1 (Gingerbread) and MIUI.us 4.0.3 (Ice Cream Sandwich)	+	Note: this require root access to the terminal; also, this has been only tested under CyanogenMod 7.1 (Gingerbread) and MIUI.us 4.0.3 (Ice Cream Sandwich) ROMs.
	</note>		</note>

welcome

anonymous@undisclosed.example.com (Anonymous) — Mon, 26 May 2025 13:34:07 +0000

2026/09/08 22:59	current
Line 1:	Line 1:
	+	====== Welcome to your new DokuWiki ======
	+
	+	Congratulations, your wiki is now up and running. Here are a few more tips to get you started.
	+
	+	Enjoy your work with DokuWiki,\\
	+	-- the developers
	+
	+	===== Create your first pages =====
	+
	+	Your wiki needs to have a start page. As long as it doesn't exist, this link will be red: [[:start]].
	+
	+	Go on, follow that link and create the page. If you need help with using the syntax you can always refer to the [[wiki:syntax\|syntax page]].
	+
	+	You might also want to use a sidebar. To create it, just edit the [[:sidebar]] page. Everything in that page will be shown in a margin column on the side. Read our [[doku>faq:sidebar\|FAQ on sidebars]] to learn more.
	+
	+	Please be aware that not all templates support sidebars.
	+
	+	===== Customize your Wiki =====
	+
	+	Once you're comfortable with creating and editing pages you might want to have a look at the [[this>doku.php?do=admin&page=config\|configuration settings]] (be sure to login as superuser first).
	+
	+	You may also want to see what [[doku>plugins\|plugins]] and [[doku>templates\|templates]] are available at DokuWiki.org to extend the functionality and looks of your DokuWiki installation.
	+
	+	===== Join the Community =====
	+
	+	DokuWiki is an Open Source project that thrives through user contributions. A good way to stay informed on what's going on and to get useful tips in using DokuWiki is subscribing to the [[doku>newsletter]].
	+
	+	The [[https://forum.dokuwiki.org\|DokuWiki User Forum]] is an excellent way to get in contact with other DokuWiki users and is just one of the many ways to get [[doku>faq:support\|support]].
	+
	+	Of course we'd be more than happy to have you [[doku>teams:getting_involved\|getting involved]] with DokuWiki.

bash_tips

anonymous@undisclosed.example.com (Anonymous) — Sat, 06 Aug 2011 15:10:48 +0000

2011/08/06 17:08		current
Line 91:		Line 91:

	The first command allows completion by pressing just [Tab], the second command adds a sign for each filetype (* for executable file)		The first command allows completion by pressing just [Tab], the second command adds a sign for each filetype (* for executable file)
		+
		+	====== Misc. tweaks ======
		+
		+	Activate timestamping in 'history':
		+	<code>
		+	export HISTTIMEFORMAT='%Y-%m-%d %H:%M:%S '
		+	</code>

	====== Useful links ======		====== Useful links ======

ssh

anonymous@undisclosed.example.com (Anonymous) — Wed, 21 Jun 2023 20:30:04 +0000

2013/12/09 02:12		current
Line 46:		Line 46:
	* install some proxy software (i.e., Squid)		* install some proxy software (i.e., Squid)
	* connect to the server, and map a port to the proxy's one:		* connect to the server, and map a port to the proxy's one:
		+
		+
	<code>		<code>
	ssh -R8181:localhost:3128 server_to_connect_to		ssh -R8181:localhost:3128 server_to_connect_to
	</code>		</code>
	* once connected, enter:		* once connected, enter:
		+
	<code>		<code>
	export http_proxy=http://127.0.0.1:8181		export http_proxy=http://127.0.0.1:8181

dokuwiki

anonymous@undisclosed.example.com (Anonymous) — Mon, 26 May 2025 13:34:07 +0000

2026/09/08 22:59	current
Line 1:	Line 1:
	+	====== DokuWiki ======
	+
	+	[[doku>wiki:dokuwiki\|{{wiki:dokuwiki-128.png }}]] DokuWiki is a simple to use and highly versatile Open Source [[wp>wiki]] software that doesn't require a database. It is loved by users for its clean and readable [[wiki:syntax]]. The ease of maintenance, backup and integration makes it an administrator's favorite. Built in [[doku>acl\|access controls]] and [[doku>auth\|authentication connectors]] make DokuWiki especially useful in the enterprise context and the large number of [[doku>plugins]] contributed by its vibrant community allow for a broad range of use cases beyond a traditional wiki.
	+
	+	Read the [[doku>manual\|DokuWiki Manual]] to unleash the full power of DokuWiki.
	+
	+	===== Download =====
	+
	+	DokuWiki is available at https://download.dokuwiki.org/
	+
	+
	+	===== Read More =====
	+
	+	All documentation and additional information besides the [[syntax\|syntax description]] is maintained in the DokuWiki at [[doku>\|www.dokuwiki.org]].
	+
	+	About DokuWiki
	+
	+	* [[doku>features\|A feature list]] :!:
	+	* [[doku>users\|Happy Users]]
	+	* [[doku>press\|Who wrote about it]]
	+	* [[doku>blogroll\|What Bloggers think]]
	+	* [[https://www.wikimatrix.org/show/DokuWiki\|Compare it with other wiki software]]
	+
	+	Installing DokuWiki
	+
	+	* [[doku>requirements\|System Requirements]]
	+	* [[https://download.dokuwiki.org/\|Download DokuWiki]] :!:
	+	* [[doku>changes\|Change Log]]
	+	* [[doku>Install\|How to install or upgrade]] :!:
	+	* [[doku>config\|Configuration]]
	+
	+	Using DokuWiki
	+
	+	* [[doku>syntax\|Wiki Syntax]]
	+	* [[doku>manual\|The manual]] :!:
	+	* [[doku>FAQ\|Frequently Asked Questions (FAQ)]]
	+	* [[doku>glossary\|Glossary]]
	+
	+	Customizing DokuWiki
	+
	+	* [[doku>tips\|Tips and Tricks]]
	+	* [[doku>Template\|How to create and use templates]]
	+	* [[doku>plugins\|Installing plugins]]
	+	* [[doku>development\|Development Resources]]
	+
	+	DokuWiki Feedback and Community
	+
	+	* [[doku>newsletter\|Subscribe to the newsletter]] :!:
	+	* [[doku>mailinglist\|Join the mailing list]]
	+	* [[https://forum.dokuwiki.org\|Check out the user forum]]
	+	* [[doku>irc\|Talk to other users in the IRC channel]]
	+	* [[https://github.com/splitbrain/dokuwiki/issues\|Submit bugs and feature wishes]]
	+	* [[doku>thanks\|Some humble thanks]]
	+
	+
	+	===== Copyright =====
	+
	+	2004-2020 (c) Andreas Gohr <andi@splitbrain.org>((Please do not contact me for help and support -- use the [[doku>mailinglist]] or [[https://forum.dokuwiki.org\|forum]] instead)) and the DokuWiki Community
	+
	+	The DokuWiki engine is licensed under [[https://www.gnu.org/licenses/gpl.html\|GNU General Public License]] Version 2. If you use DokuWiki in your company, consider [[doku>donate\|donating]] a few bucks ;-).
	+
	+	Not sure what this means? See the [[doku>faq:license\|FAQ on the Licenses]].

deinstall_removed_port

anonymous@undisclosed.example.com (Anonymous) — Thu, 30 Jan 2020 10:00:07 +0000

2026/09/08 22:59	current
Line 1:	Line 1:
	+	====== Deinstall an already removed port on FreeBSD ======

	+	Sometimes we use alternate ports (in my case, openssl111, to get TLS 1.3 under nginx), and the port get replaced by another version (openssl111 got deleted and openssl was upgraded to 1.1.1)
	+
	+	pkg will process dependencies and uninstall all software built against openssl111. And we cannot "make deinstall" openssl111 as the port has been removed.
	+
	+	So assuming we are replacing a port with another one with the same version, we can create a temporary port. I use jails so I have to do this in basejail:
	+
	+	<code>
	+	cd /path/to/basejail/usr/ports
	+	cp -vrp openssl openssl111
	+	sed -i bak s/openssl/openssl111/ openssl111/Makefile
	+	cd openssl111
	+	make deinstall
	+	</code>
	+
	+	Voila! You just have to install openssl now.

2023/09/25 11:54		current
Line 14:		Line 14:
	* [[public:deinstall_removed_port\|Deinstall an already removed port on FreeBSD]]		* [[public:deinstall_removed_port\|Deinstall an already removed port on FreeBSD]]
	* [[public:gemini_toaster\|Installing vger on FreeBSD, using inetd and nginx]]		* [[public:gemini_toaster\|Installing vger on FreeBSD, using inetd and nginx]]
-	* [[public:postgresql_upgrade_on_freebsd\|Migration a PostgreSQL cluster using FreeBSD ports]]	+	* [[public:postgresql_upgrade_on_freebsd\|Migration of a PostgreSQL cluster using FreeBSD ports]]
	<newcolumn>		<newcolumn>
	Networking		Networking

2026/09/08 22:59	current
Line 1:	Line 1:
	+	====== DokuWiki ======
	+
	+	[[doku>wiki:dokuwiki\|{{wiki:dokuwiki-128.png }}]] DokuWiki is a simple to use and highly versatile Open Source [[wp>wiki]] software that doesn't require a database. It is loved by users for its clean and readable [[wiki:syntax]]. The ease of maintenance, backup and integration makes it an administrator's favorite. Built in [[doku>acl\|access controls]] and [[doku>auth\|authentication connectors]] make DokuWiki especially useful in the enterprise context and the large number of [[doku>plugins]] contributed by its vibrant community allow for a broad range of use cases beyond a traditional wiki.
	+
	+	Read the [[doku>manual\|DokuWiki Manual]] to unleash the full power of DokuWiki.
	+
	+	===== Download =====
	+
	+	DokuWiki is available at https://download.dokuwiki.org/
	+
	+
	+	===== Read More =====
	+
	+	All documentation and additional information besides the [[syntax\|syntax description]] is maintained in the DokuWiki at [[doku>\|www.dokuwiki.org]].
	+
	+	About DokuWiki
	+
	+	* [[doku>features\|A feature list]] :!:
	+	* [[doku>users\|Happy Users]]
	+	* [[doku>press\|Who wrote about it]]
	+	* [[doku>blogroll\|What Bloggers think]]
	+	* [[https://www.wikimatrix.org/show/DokuWiki\|Compare it with other wiki software]]
	+
	+	Installing DokuWiki
	+
	+	* [[doku>requirements\|System Requirements]]
	+	* [[https://download.dokuwiki.org/\|Download DokuWiki]] :!:
	+	* [[doku>changes\|Change Log]]
	+	* [[doku>Install\|How to install or upgrade]] :!:
	+	* [[doku>config\|Configuration]]
	+
	+	Using DokuWiki
	+
	+	* [[doku>syntax\|Wiki Syntax]]
	+	* [[doku>manual\|The manual]] :!:
	+	* [[doku>FAQ\|Frequently Asked Questions (FAQ)]]
	+	* [[doku>glossary\|Glossary]]
	+
	+	Customizing DokuWiki
	+
	+	* [[doku>tips\|Tips and Tricks]]
	+	* [[doku>Template\|How to create and use templates]]
	+	* [[doku>plugins\|Installing plugins]]
	+	* [[doku>development\|Development Resources]]
	+
	+	DokuWiki Feedback and Community
	+
	+	* [[doku>newsletter\|Subscribe to the newsletter]] :!:
	+	* [[doku>mailinglist\|Join the mailing list]]
	+	* [[https://forum.dokuwiki.org\|Check out the user forum]]
	+	* [[doku>irc\|Talk to other users in the IRC channel]]
	+	* [[https://github.com/splitbrain/dokuwiki/issues\|Submit bugs and feature wishes]]
	+	* [[doku>thanks\|Some humble thanks]]
	+
	+
	+	===== Copyright =====
	+
	+	2004-2020 (c) Andreas Gohr <andi@splitbrain.org>((Please do not contact me for help and support -- use the [[doku>mailinglist]] or [[https://forum.dokuwiki.org\|forum]] instead)) and the DokuWiki Community
	+
	+	The DokuWiki engine is licensed under [[https://www.gnu.org/licenses/gpl.html\|GNU General Public License]] Version 2. If you use DokuWiki in your company, consider [[doku>donate\|donating]] a few bucks ;-).
	+
	+	Not sure what this means? See the [[doku>faq:license\|FAQ on the Licenses]].