Search Results

Adapted from here: https://docs.rundeck.com/docs/administration/maintenance/backup.html We will use the rd tool to access the RunDeck API and export the project job list. We will be backing things up to this folder: /projects/rundeck_backups 1. Execute thi...

If you accidentally execute a long-running operation that you want to cancel, and the SSMS client doesn't seem to accept the cancellation, then the database engine is likely involved in a large rollback, to restore the original state. Run this to identify the...

If you come across the need to purge many records from a datatable, and doing so will result in a large rollback snapshot, you can split the deletion into chunks that will execute much faster and with less resources. Use something like this: SET NOCOUNT ON; ...

Sometimes, a a dotnet runtime closes without releasing a listening port. This will prevent it from restarting, because the port is already in use.   While running the dotnet run if you stop the server using ctr + z then it Ctrl+z sends the SIGTSTP (Signal T...

Here’s a short list of steps for setting up an SSH server in Ubuntu. Install SSH Server Installing the open ssh server is pretty straightforward on Debian. Run the following to install the service and libraries: sudo apt-get updatesudo apt-get install opens...

Below is a list of commonly used systemd commands. If you are needing to configure a binary as a linux service, see this: Ubuntu Service Creation Reload Systemd Units Each time you edit a systemd unit file, you must tell systemd to reload changes.To reload ...

Below are instructions on how to setup a binary as a linux service. For additional systemd commands, see this: SystemCtl Usage Service Creation Here are steps to run a binary as a linux service. Create a systemd unit file for the service by generating a fi...

When running containers in Docker, you will come across the need for a container to gain access to a resource on the host.If you have UFW firewall enabled, you will need to allow ingress from the docker network, running on the host. To identify the docker net...

Here's steps to work through, to ensure remote access to a PostgreSQL instance. Check PostgreSQL is Listening on All Interfaces From a terminal, open the postgresql.conf file, with this: sudo nano /etc/postgresql/<version>/main/postgresql.conf NOTE: Replac...

Adapted steps from here: https://www.c-sharpcorner.com/article/crud-operations-in-postgresql-with-ef-core-and-asp-net-core-web-api/ https://documentation.ubuntu.com/server/how-to/databases/install-postgresql/index.html Download PostgreSQL can be downloaded...

Access Postgres as SuperUser Use this terminal command to access the local PostgreSQL instance as the postgres user: sudo -u postgres psql Setting Postgres (Superuser) Password Normally, the postgres user (superuser) does NOT have a set password.This is be...

Here’s a list of commands to remember for docker administration. List Containers To list all docker containers on a host: sudo docker ps -a Remove Containers To remove all docker containers on a host: sudo docker rm -f $(sudo docker ps -aq) Container Lo...

Here’s a short command line statement that will fetch the host ssh key fingerpring without authenticating with it: ssh-keyscan host | ssh-keygen -lf - Here’s another way to clean up ssh host key fingerprints: # remove any old fingerprints for the host ssh-...

General Notes SSH keys can be easily generated in Windows, using PuttyGen. See this article for an update based on obsolete SHA-1 RSA key usage: Ubuntu 22.04 SSH the RSA key isn't working since upgrading from 20.04 Based on the obsolescence of RSA keys in U...

When setting up a new host, you will come across the need to copy SSH keys to it. This is easy to do, before disabling password authentication.But, the command line gyrations to copy a public key to a remote host while simultaneously logging into it with a di...

This page describes a good naming convention for SSH keys, that makes them easier to track, rotate, and revoke. You should use this naming convention for the filename of keys.And as well, use the same convention when populating the the comment field of each k...

Creating an SSH key is straightforward on a linux client, using this command: ssh-keygen By default recent versions of ssh-keygen will create a 3072-bit RSA key pair, which is secure enough for most use cases (you may optionally pass in the -b 4096 flag to c...