Skip to content

Latest commit

 

History

History
74 lines (48 loc) · 2.19 KB

README.md

File metadata and controls

74 lines (48 loc) · 2.19 KB
Raw

pg_user

Release GoDoc Quality Test

Is a cli application for managing postgres users.

Features

  • Creating new users with roles
  • Deleting existing users
  • Extending the validity of existing users
  • Resetting passwords (random or specific) of existing users
  • Listing existing users and their associated roles
  • Listing all configured hosts
  • Listing existing roles

Installation

Linux amd64

# install
curl -L https://github.com/frederikhs/pg_user/releases/latest/download/pg_user_Linux_x86_64.tar.gz -o pg_user.tar.gz
tar -xvf pg_user.tar.gz
sudo chmod +x pg_user
sudo mv pg_user /usr/local/bin/pg_user

# clean up
rm pg_user.tar.gz

Other

Other distributions or OS visit the releases page

Configuration

pg_user uses the format and location of the .pgpass file the resides in the $HOME directory of the user running the program.

Example of a host details in the .pgpass format

<HOST>:<PORT>:<DATABASE>:<USERNAME>:<PASSWORD>

Examples of usage

$ pg_user add [email protected] --host mydatabase.com

This requires the hostname mydatabase.com must be configured in the .pgpass file

To also add roles to the user when creating use

$ pg_user add [email protected] --host mydatabase.com --roles role1,role2

Development

This repository is very plain and simple and development of the application only required go.

$ go run main.go hosts will compile the application and list all configured hosts in your .pgpass file.

Release

release a new version by creating a tag and pushing it, then goreleaser will do the rest

git tag -a v0.x.0 -m "v0.x.0"
git push origin v0.x.0