PostgreSQL

postgresql

The world's most advanced open source relational database.

Detected by psql, pg_dump, pg_dumpall, pg_restore, pg_isready, pgbench, createdb, dropdb | macOS, Linux, Windows |www.postgresql.org

Sync it postgresql.toml

Sync rules

What travels, what stays, what never leaves

PostgreSQL in your home directory Every rule on this page, by file

· ~/.psqlrc Sync

· ~/.psqlrc-* Sync

· ~/.pg_service.conf Sync

· ~/.psql_history Exclude

· ~/.pgpass Never synced

· psqlrc.conf Sync

· .pg_service.conf Sync

· psql_history Exclude

· pgpass.conf Never synced

Only what the catalog names. A directory that syncs brings everything inside it except what is listed as excluded here.

apps/postgresql.tomlThe file this page is generated from

id = "postgresql"

name = "PostgreSQL"

homepage = "https://www.postgresql.org"

description = "The world's most advanced open source relational database."

icon = "theSVG:postgresql"

# One entry for the libpq client programs rather than one per binary: they all

# read the same ~/.pgpass and ~/.pg_service.conf, and psql adds its own startup

# file on top of them.

detect = [

"psql",

"pg_dump",

"pg_dumpall",

"pg_restore",

"pg_isready",

"pgbench",

"createdb",

"dropdb",

]

# https://www.postgresql.org/docs/current/app-psql.html, "Files": "The user's

# personal startup file is named .psqlrc and is sought in the invoking user's

# home directory. On Windows, which lacks such a concept, the personal startup

# file is named %APPDATA%\postgresql\psqlrc.conf." The same section: the

# startup file "can be made psql-version-specific by appending a dash and the

# PostgreSQL major or minor release number to the file name, for example

# ~/.psqlrc-9.2" — hence the glob. The docs spell that variant out only for the

# Unix name, so only that one is globbed here.

# https://www.postgresql.org/docs/current/libpq-pgservice.html: "By default,

# the per-user service file is named ~/.pg_service.conf", and "On Microsoft

# Windows, it is named %APPDATA%\postgresql\.pg_service.conf". It holds

# connection parameters (host, port, user, dbname) in INI format; passwords

# live in .pgpass, below.

paths = [

"~/.psqlrc",

"~/.psqlrc-*",

"%APPDATA%/postgresql/psqlrc.conf",

"~/.pg_service.conf",

"%APPDATA%/postgresql/.pg_service.conf",

]

# Same psql "Files" section: "The command-line history is stored in the file

# ~/.psql_history, or %APPDATA%\postgresql\psql_history on Windows." History,

# not configuration.

exclude = [

"~/.psql_history",

"%APPDATA%/postgresql/psql_history",

]

# https://www.postgresql.org/docs/current/libpq-pgpass.html: "The file .pgpass

# in a user's home directory can contain passwords to be used if the connection

# requires a password", one

# `hostname:port:database:username:password` per line, and "On Microsoft

# Windows the file is named %APPDATA%\postgresql\pgpass.conf". Every line of it

# is a password.

secret = [

"~/.pgpass",

"%APPDATA%/postgresql/pgpass.conf",

]

# Read once when a client starts up, by a process that then exits.

side_effect = false

# No machine_lines. A .psqlrc is \set and \pset preferences — the thing a user

# wants on every machine — and a service definition names a database reachable

# from anywhere, not a property of this laptop.

Use it with your dotfile manager

Same data, in the shape your tool already reads

Opens Otty and adds this tool to what it syncs

Opens otty://sync/add/postgresql. Otty ships with this catalog, so the link only has to name the tool — nothing is downloaded.

Every one of these keeps all credential files out.