1 of 1

psu Command Line Tool

psu is a command line utility for working with PowerShell Universal.

psu is included with the PowerShell Universal installation media.

admin

Admin account operations

reset

Reset the local admin account password in the event of a lockout. The account will be admin with a password of admin .

psu admin reset --connection-string 'Data Source=C:\ProgramData\UniversalAutomation\database.db'

Argument

Description

Required

--connection-string

The database connection string

✅

database-type

PostgreSQL, SQL or SQLite (default)

❌

--encryption-key

Database vault encryption key, if changed.

❌

--password

Database vault password, if changed.

❌

--key-size

Database vault password key size, if changed from 128.

❌

db

Commands for working with the PowerShell Universal database.

convert

Convert a v4 LiteDB Database to SQLite

psu db convert --path C:\ProgramData\UniversalAutomation\databased.db

Argument

Description

Required

--path

The path of the database to convert

✅

schema

Migrate from one schema version to another. Migrating to lower versions can cause data loss.

psu db schema --connection-string 'Server=SQL;Data Source=PSU;Integrated Security=True' --schema-version 5.1.0 --database-type 'SQL'

Argument

Description

Required

--connection-string

Connection string to the database

✅

--target-version

The database schema version. Defaults to "Latest"

❌

--database-type

PostgreSQL, SQL or SQLite (default)

❌

Migrate

Migrates from one database to another. This command can migrate between database types.

psu db migrate --source-connection-string 'Server=SQL;Data Source=PSU;Integrated Security=True' -source-database-type 'SQL' --target-connection-string 'Server=PostgreSQL;Data Source=PSU;Integrated Security=True' --target-database-type 'PostgreSQL'

Argument

Description

Required

--target-connection-string

Target database connection string

✅

--source-connection-string

Source database connection string

✅

--target-database-type

PostgreSQL, SQL or SQLite (default)

❌

--source-database-type

PostgreSQL, SQL or SQLite (default)

❌

git

Commands for working with PSU git repositories. This command uses the internal git services to work with the local repository.

clone

Clones a git repository using the git sync service.

psu git clone --url http://github.com/ironmansoftware/psu.git --path C:\ProgramData\UniversalAutomation\Repository --username 'adamdriscoll' --password 'gh__1234123' --branch main

Argument

Description

Required

--url

The URL of the git remote.

✅

--path

The local path to clone to

✅

--username

The user name for the remote.

❌

--password

The password for the remote

❌

--branch

The branch to clone (default is main).

❌

pull

Pulls from a git remote. A clone will be called if the local repository does not exist.

psu git pull --url http://github.com/ironmansoftware/psu.git --path C:\ProgramData\UniversalAutomation\Repository --username 'adamdriscoll' --password 'gh__1234123' --branch main

Argument

Description

Required

--url

The URL of the git remote.

✅

--path

The local path to clone to

✅

--username

The user name for the remote.

❌

--password

The password for the remote

❌

--branch

The branch to clone (default is main).

❌

push

Pushes to a git remote. The repository needs to be cloned first. Changes will not be staged during the push.

psu git push --url http://github.com/ironmansoftware/psu.git --path C:\ProgramData\UniversalAutomation\Repository --username 'adamdriscoll' --password 'gh__1234123' --branch main

Argument

Description

Required

--url

The URL of the git remote.

✅

--path

The local path to clone to

✅

--username

The user name for the remote.

❌

--password

The password for the remote

❌

--branch

The branch to clone (default is main).

❌