<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.8" -->
<?xml-stylesheet href="https://www.cmsws.com/wiki/lib/exe/css.php?s=feed" type="text/css"?>
<rss version="2.0">
    <channel xmlns:g="http://base.google.com/ns/1.0">
        <title>CMS Web Services</title>
        <description></description>
        <link>https://www.cmsws.com/wiki/</link>
        <lastBuildDate>Wed, 29 Apr 2026 08:37:43 +0000</lastBuildDate>
        <generator>FeedCreator 1.8</generator>
        <image>
            <url>https://www.cmsws.com/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg</url>
            <title>CMS Web Services</title>
            <link>https://www.cmsws.com/wiki/</link>
        </image>
        <item>
            <title>start</title>
            <link>https://www.cmsws.com/wiki/doku.php?id=start&amp;rev=1773589747&amp;do=diff</link>
            <description>Gaming Stuff

	*  Explaining the Leaderboard

Arduino Stuff

	*  Power Relays
	*  Fading
	*  By Open Green Energy

Programming

	*  Linux Containers using LXD/LXC
	*  Collection+JSON
	*  Collection.next+JSON
	*  Laravel
		*  Sort tables using traits


Linux Utilities

	*  Screen Tips
		*  SSH Stuff
		*  Make Bootable USB
		*  Display system information
		*  Linuxmint 19.1 + HPLIP
		*  Zabbix
		*  Importing data into Postgresql
		*  Postgresql pg_dump &amp; pg_restore
		*  Change default encoding to …</description>
            <author>jlucas@undisclosed.example.com (jlucas)</author>
            <pubDate>Sun, 15 Mar 2026 15:49:07 +0000</pubDate>
        </item>
        <item>
            <title>testing</title>
            <link>https://www.cmsws.com/wiki/doku.php?id=testing&amp;rev=1759081989&amp;do=diff</link>
            <description>“This is a quote.”  (OK)

“This is a strong quote.”  (OK)

“This is a quote with an ellipsis at the end...”  (OK)

“This is a strong quote with an ellipsis at the end...“  (WRONG)

“This is an underlined quote with an ellipsis at the end</description>
            <author>jlucas@undisclosed.example.com (jlucas)</author>
            <pubDate>Sun, 28 Sep 2025 17:53:09 +0000</pubDate>
        </item>
        <item>
            <title>change_to_utf8_encoding - created</title>
            <link>https://www.cmsws.com/wiki/doku.php?id=linux:database:postgresql:change_to_utf8_encoding&amp;rev=1619051652&amp;do=diff</link>
            <description>Change default encoding to UTF-8

References:

	*  &lt;https://www.endpoint.com/blog/2017/07/21/postgres-migrating-sqlascii-to-utf-8&gt;
	*  &lt;https://www.shubhamdipt.com/blog/how-to-change-postgresql-database-encoding-to-utf8/&gt;

NOTE: Never perform this work on a database that is being written to.  For my example a DB used by a very busy instance of Zabbix.

Verify current server encoding


root@zabdb:~ # psql -U zabbix zabbix
psql (11.9)
Type &quot;help&quot; for help.

zabbix=&gt; SHOW SERVER_ENCODING;
 server_e…</description>
            <author>jlucas@undisclosed.example.com (jlucas)</author>
            <pubDate>Thu, 22 Apr 2021 00:34:12 +0000</pubDate>
        </item>
        <item>
            <title>makebootusb</title>
            <link>https://www.cmsws.com/wiki/doku.php?id=linux:utilities:makebootusb&amp;rev=1607621037&amp;do=diff</link>
            <description>Mount the ISO:
sudo mount -t udf -o loop,ro,unhide /path/to/file.iso /mnt
Insert the USB drive.

Run fdisk and specify the device name of the USB drive; for example:
sudo fdisk /dev/sdc
	*  Delete any existing partition table and create a new one.
	*</description>
            <author>jlucas@undisclosed.example.com (jlucas)</author>
            <pubDate>Thu, 10 Dec 2020 17:23:57 +0000</pubDate>
        </item>
        <item>
            <title>partitioning - [Dump individual Zabbix database tables for testing] </title>
            <link>https://www.cmsws.com/wiki/doku.php?id=linux:monitoring:zabbix:database:postgresql:partitioning&amp;rev=1585840800&amp;do=diff</link>
            <description>Adding DB table partitioning to Zabbix DB

Note from the Author

First off, the servers that I&#039;m using in my setup are OpenBSD.  Therefore the CLI commands shown below will most likely be different then what you need to be able to run the same command on your system.  For example, I&#039;ll be using &#039;doas&#039; in place of &#039;sudo&#039; and &#039;rcctl&#039; in place of &#039;service&#039; or &#039;systemctl&#039;.  Be sure to pay attention to this when issue these commands.</description>
            <author>jlucas@undisclosed.example.com (jlucas)</author>
            <pubDate>Thu, 02 Apr 2020 15:20:00 +0000</pubDate>
        </item>
        <item>
            <title>playground</title>
            <link>https://www.cmsws.com/wiki/doku.php?id=playground:playground&amp;rev=1585600717&amp;do=diff</link>
            <description>PlayGround</description>
            <author>jlucas@undisclosed.example.com (jlucas)</author>
            <pubDate>Mon, 30 Mar 2020 20:38:37 +0000</pubDate>
        </item>
    </channel>
</rss>
