Skip to content

Instantly share code, notes, and snippets.

@soiqualang

soiqualang/Change password postgresql.md

Created November 12, 2020 07:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save soiqualang/8a401bf0060b0cb5653372ceaeac536d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save soiqualang/8a401bf0060b0cb5653372ceaeac536d to your computer and use it in GitHub Desktop.
Download ZIP
Change password postgresql
Raw
Change password postgresql.md

Change password postgresql

psql --help

Connection options:
  -h, --host=HOSTNAME      database server host or socket directory (default: "local socket")
  -p, --port=PORT          database server port (default: "5432")
  -U, --username=USERNAME  database user name (default: "ictla")
  -w, --no-password        never prompt for password
  -W, --password           force password prompt (should happen automatically)

psql -p 5433 postgres postgres
\password

Input your new pass

\q
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment