jayroh / pgchief

A simple ruby script to manage postgresql databases and users

pgchief

I don't need an entire web application to manage some self-hosted postgres servers.

I also don't have the entirety of every PG command to back up and restore databases, manage users, assign permissions to databases, etc, catalogued in my brain.

What would be helpful is to have something that assists in some of those tasks with a clean and intuitive CLI interface.

Hence why I made this pgchief thing. It's a simple ruby script utilizing the tty-prompt and tty-command rubygems to collect info, and run the correct commands.

---

NOTE: Almost nothing has been built. This is in active pre-alpha development.

---

$ pgchief --init # create the TOML file in your home dir (w/600 permissions)
$ pgchief

Welcome! How can I help?
 ‣ Database management
   User management

# --- Database management: Creating a DB ---

Database management, got it! What's next?
 ‣ Create one
   Drop one
   Back it up
   Restore one

What is the database's name?

# --- Database management: Dropping a DB ---

Which database would you like to drop?
 ‣ fabulous-filly
   great-grape
   faster-fuscia

# --- User management: Create a user ---

User management? Ok! Who and what?
 ‣ Create user
   Allow access to database

What is the user's name?
rando-username

Give "rando-username" access to database(s):
 ‣ ⬡ fabulous-filly
   ⬡ great-grape
   ⬡ faster-fuscia
   ⬡ none of the above

# ... etc.

Format of ~/.pgchief.toml

pgurl = "postgres://username:password@host:5432"
backup_dir = "~/.pg_backups"

---

Feature Roadmap

• Create database
• Create user
• Give user permissions to use database
• Back up database
• Restore database
• Initialize toml file