silenius
/ gist:629a4a4a5f49d4b50052ebc8a36686e5
Created
January 20, 2021 15:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /data/jails/pg11/data11 /jails/pg11/data/data11 nullfs rw 0 0 | |
| /data/jails/pg11/backups /jails/pg11/data/backups nullfs rw 0 0 | |
| /data/jails/pg11 /jails/pg11/data nullfs rw 0 0 |
silenius
/ gist:f1899ebb5cf58ca33b3e5edafc85d549
Created
January 15, 2021 15:14
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ~/ zfs list -r zroot/data zroot/jails | |
| NAME USED AVAIL REFER MOUNTPOINT | |
| zroot/data 132G 1.32T 128K /data | |
| zroot/data/jails 132G 1.32T 151K /data/jails | |
| zroot/data/jails/amq1 128K 1.32T 128K /data/jails/amq1 | |
| zroot/data/jails/antabif 128K 1.32T 128K /data/jails/antabif | |
| zroot/data/jails/chat 128K 1.32T 128K /data/jails/chat | |
| zroot/data/jails/dev 128K 1.32T 128K /data/jails/dev | |
| zroot/data/jails/geoserver1 6.80M 1.32T 6.80M /data/jails/geoserver1 | |
| zroot/data/jails/geoserver2 6.79M 1.32T 6.79M /data/jails/geoserver2 |
silenius
/ gist:9b42ade2e416a33bed7f2e4412bab48d
Created
January 13, 2021 10:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@srv:~ # mount -t nullfs|grep pg | |
| /data/jails/pg11/data11 on /jails/pg11/data/data11 (nullfs, local) | |
| /data/jails/pg11/backups on /jails/pg11/data/backups (nullfs, local) | |
| /data/jails/pg13/data13 on /jails/pg13/data/data13 (nullfs, local) | |
| /data/jails/pg13/backups on /jails/pg13/data/backups (nullfs, local) | |
| /data/jails/pg11/data11 on /jails/pg13/data/data11 (nullfs, local) | |
| /jails/pg11 on /jails/pg13/tmp/migration/exec (nullfs, local) |
silenius
/ gist:13073346243d1fa5d275bc8aa649d369
Created
January 11, 2021 14:07
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| regex="^[^#]"class":\\$"; | |
| if (match($0, regex)) { | |
| print $0 | |
| } | |
| } |
silenius
/ gist:8e6daa97aaad4538dcc83bd851eb98d6
Created
January 11, 2021 13:44
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| r1% cat foo.awk | |
| { if (match($0, "^[^#]"class":\\$")) { print $0 } } | |
| r1% awk -v class=default -f foo.awk /etc/login.conf | |
| r1% |
silenius
/ gist:1cf961eec6a89ec12809e0b8817b88a3
Created
January 8, 2021 13:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| osm=# SELECT postgis_extensions_upgrade(); | |
| WARNING: unpackaging raster | |
| WARNING: PostGIS Raster functionality has been unpackaged | |
| HINT: type `SELECT postgis_extensions_upgrade(); to finish the upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster; | |
| ERROR: could not access file "$libdir/postgis-2.5": No such file or directory | |
| CONTEXT: PL/pgSQL function _postgis_drop_function_if_needed(text,text) line 6 at FOR over SELECT rows | |
| SQL statement "ALTER EXTENSION postgis UPDATE TO "3.0.3";" | |
| PL/pgSQL function postgis_extensions_upgrade() line 22 at EXECUTE | |
| osm=# |
silenius
/ gist:b5499992ffa9f78b8f6dcaa93b4ed67f
Created
January 8, 2021 13:20
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ pg_upgrade -b /data/upgrade/usr/local/bin/ -B /usr/local/bin/ -d /data/data11/ -D /data/data13/ -j 4 | |
| Performing Consistency Checks | |
| ----------------------------- | |
| Checking cluster versions ok | |
| Checking database user is the install user ok | |
| Checking database connection settings ok | |
| Checking for prepared transactions ok | |
| Checking for reg* data types in user tables ok | |
| Checking for contrib/isn with bigint-passing mismatch ok | |
| Checking for tables WITH OIDS ok |
silenius
/ gist:44ebac581b4e4807177dcc3f2c9a01be
Created
January 5, 2021 10:19
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cp: /data/archives/0000000100000006000000F2: No such file or directory | |
| 2021-01-05 11:04:24.410 CET [97004] LOG: restored log file "0000000100000006000000F2" from archive | |
| 2021-01-05 11:04:26.817 CET [97004] LOG: restored log file "0000000100000006000000F3" from archive | |
| 2021-01-05 11:04:29.026 CET [97004] LOG: restored log file "0000000100000006000000F4" from archive | |
| 2021-01-05 11:04:31.640 CET [97004] LOG: restored log file "0000000100000006000000F5" from archive | |
| cp: /data/archives/0000000100000006000000F6: No such file or directory | |
| cp: /data/archives/0000000100000006000000F6: No such file or directory | |
| (...) | |
| cp: /data/archives/0000000100000006000000F6: No s |
silenius
/ gist:0319de64e3c4f3dfc63d1393d94e2603
Created
December 17, 2020 14:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@srv:~ # cat /etc/ctl.conf | |
| auth-group ag0 { | |
| #chap-mutual "user" "secret" "mutualuser" "mutualsecret" | |
| auth-type "chap" | |
| chap "test" "testtesttest" | |
| initiator-portal 192.168.0.0/24 | |
| initiator-portal 192.168.13.0/24 | |
| initiator-portal 192.168.14.0/24 | |
| } |
silenius
/ gist:727300cbaafff6d0fd7f33483baf09b6
Created
December 17, 2020 14:15
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| julien@x1:~/ > echo "1.98,1.98,r2,1,1608213675,8G,,8192,5,109,99,25701,13,11753,5,177,99,50230,14,1338,87,16,,,,,10475,69,+++++,+++,22007,99,11000,82,+++++,+++,19994,99,96045us,539ms,2841ms,66041us,39819us,15868us,258ms,298us,172us,221ms,356us,265us" | bon_csv2txt | |
| Version 1.98 ------Sequential Output------ --Sequential Input- --Random- | |
| -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- | |
| Name:Size etc /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP | |
| r2 8G::8192:5 109k 99 25.1m 13 11.5m 5 177k 99 49.1m 14 1338 87 | |
| Latency 96045us 539ms 2841ms 66041us 39819us 15868us | |
| ------Sequential Create------ --------Random Create-------- | |
| -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- | |
| files:max:min /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP | |
| r2 16 10475 69 +++++ +++ 22007 99 11000 82 +++++ +++ 19994 99 |