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

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

vimbashfactory

anonymous@undisclosed.example.com (Anonymous) — Thu, 04 Aug 2022 13:31:20 +0000

2012/10/25 15:46		current
Line 4:		Line 4:
	* Install it (:source path_to_vim_script)		* Install it (:source path_to_vim_script)
	* Create the following script in .vim/templates/sh:		* Create the following script in .vim/templates/sh:
-	<code>	+
		+	<code bash>
	#!/bin/sh		#!/bin/sh

Line 58:		Line 59:
	exit 0		exit 0
	</code>		</code>
		+
	* Add the following line in .vimrc:		* Add the following line in .vimrc:
-	<code>	+
		+	<code vim>
	au BufWritePost * if getline(1) =~ "^#!" \| if getline(1) =~ "/bin/" \| silent !chmod a+x <afile> \| endif \| endif		au BufWritePost * if getline(1) =~ "^#!" \| if getline(1) =~ "/bin/" \| silent !chmod a+x <afile> \| endif \| endif
	</code>		</code>

deinstall_removed_port

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

2026/04/15 04:40	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.

fofox

anonymous@undisclosed.example.com (Anonymous) — Fri, 10 Apr 2026 20:11:56 +0000

2026/04/10 22:11		current
Line 29:		Line 29:
	* [[https://greasyfork.org/fr/scripts/395497-facebook-and-instagram-login-popup-remover\|Facebook and Instagram login popup remover]]: same as Pinterest but for Facebook & Instagram, obviously.		* [[https://greasyfork.org/fr/scripts/395497-facebook-and-instagram-login-popup-remover\|Facebook and Instagram login popup remover]]: same as Pinterest but for Facebook & Instagram, obviously.
	* [[https://greasyfork.org/en/scripts/406535-instagram-download-button\|Instagram Download Button]]: add the download button and the open button to download or open profile picture and media in the posts, stories, and highlights in Instagram		* [[https://greasyfork.org/en/scripts/406535-instagram-download-button\|Instagram Download Button]]: add the download button and the open button to download or open profile picture and media in the posts, stories, and highlights in Instagram
		+
	====== My favorite Thunderbird extensions ======		====== My favorite Thunderbird extensions ======

my_own_ipv6_tips_for_servers

anonymous@undisclosed.example.com (Anonymous) — Sat, 30 Mar 2024 21:22:28 +0000

2023/06/21 22:25		current
Line 24:		Line 24:
	</code>		</code>
	* /etc/vsftpd_ipv6.conf:		* /etc/vsftpd_ipv6.conf:
		+
	<code>		<code>
	listen=NO		listen=NO
Line 50:		Line 51:
	remember that ipv6 needs icmp to work, so you have to enable it:		remember that ipv6 needs icmp to work, so you have to enable it:
	<code>		<code>
-	# ip6tables -A INPUT -p icmpv6 -j ACCEPT	+	# ip6tables -A INPUT -p icmpv6 -j ACCEPT
	</code>		</code>

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 ====

vpn_vs_proxies

anonymous@undisclosed.example.com (Anonymous) — Tue, 21 Feb 2012 17:42:57 +0000

2012/02/21 18:41		current
Line 23:		Line 23:

	<code>		<code>
-	port-share //remoteserver// 443	+	port-share remoteserver 443
	</code>		</code>