Posts

PG::Error: ERROR: new encoding (UTF8) is incompatible

First, we need to drop template1. Templates can't be dropped, so we first modify it so t's an ordinary database: UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1'; Now we can drop it: DROP DATABASE template1; Now its time to create database from template0, with a new default encoding: CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE'; Now modify template1 so it's actually a template: UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1'; Now switch to template1 and VACUUM FREEZE the template: \c template1 VACUUM FREEZE; Problem should be resolved.

Download the secure file to local machine or view its content in Azure DevOps with build administrator privilege

Create a pipeline and execute. trigger: - main pool:   vmImage: ubuntu-latest steps: - task: DownloadSecureFile@1   displayName: 'Download secure file'   inputs:     secureFile: <securefilename> - task: PublishBuildArtifacts@1   displayName: 'Publish Artifact: drop'   inputs:     PathtoPublish: '$(DOWNLOADSECUREFILE.SECUREFILEPATH)'

.gitlab-ci.yaml use image with a specific user

In yaml Instead of image : xyz you can do image:  name: xyz  docker:    user: root

ProxMox LxC container open vpn Cannot open TUN/TAP dev /dev/net/tun: No such file or directory (errno=2)

Adding the following to /etc/pve/lxc/xxx.conf solves the problem: lxc.cgroup.devices.allow: c 10:200 rwm lxc.mount.entry: /dev/net dev/net none bind,create=dir

VPN Support with WSL2

update to WSL offers experimental features which resolve the issue for me. I'm using WSL2 on Windows 11 with Global protect. Add the following flags  C:\Users\_username_\.wslconfig  file: [experimental] networkingMode=mirrored dnsTunneling=true Or in wsl specific distro vim /etc/wsl.conf [experimental] networkingMode=mirrored dnsTunneling=true

Let's Encrypt/ACME client and library written in Go

go-acme/lego: Let's Encrypt/ACME client and library written in Go (github.com)

How to change default port for GitLab

As suggested on https://github.com/gitlabhq/gitlabhq/issues/6581  you can configure port on below file. Change port to 81 (You can choose your own) at port: near by production:$base >> gitlab: for file /opt/gitlab/embedded/service/gitlab-rails/config/gitlab.yml Change your host address if you like to use different from your ip address or localhost Change server port to 81 in file "/opt/gitlab/embedded/conf/nginx.conf" Restart gitlab using command "sudo gitlab-ctl restart". After applying all above changes still my nginx was running on port 80 only and not sure why also reconfiguring gitlab reset may all change on gitlab.yml files. Finally, file "/etc/gitlab/gitlab.rb" make this work for me.  Open "/etc/gitlab/gitlab.rb" to text editor where currently I have external_url 'http://myipaddress/' as text. I just change to  external_url 'http://gitlab.com.local:81/' then reconfigure using comm...