Home > Software > Database > Other > PostgreSQL

PostgreSQL logo

Details

Package ID
postgresql9
Version
9.6.17
Downloads
4441
Website
https://postgresql.org/

Summary

PostgreSQL is an object-relational database management system

Description

PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRE, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.

PostgreSQL can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic.

Features

Package parameters

  • /Password - Password to be assigned to the postgres user. If omitted, it will be generated and shown in the install output.
  • /NoPath - Do not add postgresql bin directory to the PATH.

Notes

  • Test installation (specify your password):
    $Env:PGPASSWORD='test'; '\conninfo' | psql -Upostgres
    This should output:
    You are connected to database "postgres" as user "postgres" on host "localhost" at port "5432"
  • This package will install PostgreSQL to $Env:ProgramFiles\PostgreSQL\[MajorVersion].
  • Silent install options.
  • If you have problems during installation see troubleshooting page.

Virtual package

Each major version has its own package: postgresql12, postgresql11, postgresql10, postgresql9.

Virtual package postgresql also contains all versions that depend on adequate major version, but using it without problems require some special choco parameters.

To propagate package parameters to dependencies use --params-global choco install parameter with virtual package postgresql. Assuming latest version is 12, to provide password the following two examples result in identical installation:

cinst postgresql --params '/Password:test' --params-global
cinst postgresql12 --params '/Password:test'

To uninstall dependent package use --force-dependencies:

# The following two examples are identical
cuninst postgresql --force-dependencies
cuninst postgresql12 postgresql

# This example uninstalls only postgresql virtual package and not postgresql12 
cuninst postgresql

To force reinstallation via virtual package use --force-dependencies:

# The following two examples are identical
cinst postgresql --force --force-dependencies
cinst postgresql12 --force --force-dependencies

# This will reinstall only postgresql virtual package and not its dependency postgresql12 
cinst postgresql -force

# This one is different then the first one as vcredist140 dependency is not reinstalled
cinst postgresql12 --force

Comments

Loading comments...