Downloads:
91,569
Downloads of v 14.6.2:
28
Last Update:
18 Jan 2023
Package Maintainer(s):
Software Author(s):
- PostgreSQL Global Development Group
Tags:
foss cross-platform postgres postgresql sql relational database adminPostgreSQL
Downloads:
91,569
Downloads of v 14.6.2:
28
Maintainer(s):
Software Author(s):
- PostgreSQL Global Development Group
PostgreSQL
- 1
- 2
- 3
Some Checks Have Failed or Are Not Yet Complete
Not All Tests Have Passed
Validation Testing Passed
Verification Testing Unknown
Scan Testing Pending
This package was rejected on 22 Feb 2023. The reviewer chocolatey-ops has listed the following reason(s):
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
/AllowRemote
- Allow remote connections with username and password from all hosts by adding appropriate lines in thepg_hba.conf
/Password
- Password to be assigned to thepostgres
user. If omitted, it will be generated and shown in the install output. PostgreSql installer ignores this parameter if there is existing installation./Port
- Server port, if not set it defaults to5432
or the first available port after it./NoPath
- Do not add PostgreSql bin directory to the PATH.
Other parameters could be set via --ia
argument, for example, to set custom components:
choco install postgresql13 --params '/Password:test /Port:5433' --ia '--enable-components server,commandlinetools'
Check all installer options by adding --help
as command line argument.
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]
. - If you have problems during installation see troubleshooting page.
- If you didn't specify password during setup and didn't record the generated one, you need manually reset it using the following steps:
- Open file
data\pg_hba.conf
in PostgreSql installation directory - Change
METHOD
totrust
and restart service withRestart-Service postgresql*
- Execute
"alter user postgres with password '[my password]';" | psql -Upostgres
- Revert back
data\pg_hba.conf
to METHODmd5
and restart service
- Open file
- If you have trouble selecting specific install components see this issue
Virtual package
Each major version has its own package: postgresql<Version>
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
$ErrorActionPreference = 'Stop'
$packageName = $Env:ChocolateyPackageName
$softwareNamePattern = 'PostgreSQL 14*'
[array] $key = Get-UninstallRegistryKey $softwareNamePattern
if ($key.Count -eq 1) {
$key | % {
$packageArgs = @{
packageName = $packageName
silentArgs = "--mode unattended"
fileType = 'EXE'
validExitCodes = @(0)
file = $_.UninstallString.Replace('"', '')
}
Uninstall-ChocolateyPackage @packageArgs
}
}
elseif ($key.Count -eq 0) {
Write-Warning "$packageName has already been uninstalled by other means."
}
elseif ($key.Count -gt 1) {
Write-Warning "$($key.Count) matches found!"
Write-Warning "To prevent accidental data loss, no programs will be uninstalled."
Write-Warning "Please alert package maintainer the following keys were matched:"
$key | % {Write-Warning "- $($_.DisplayName)"}
}
Write-Host "Uninstallation log: $Env:TEMP\uninstall-postgresql.log"
No results available for this package. We are building up results for older packages over time so expect to see results. If this is a new package, it should have results within a day or two.
Add to Builder | Version | Downloads | Last Updated | Status |
---|---|---|---|---|
PostgreSQL 14.10.0 | 6999 | Wednesday, January 17, 2024 | Approved | |
PostgreSQL 14.5.1 | 41044 | Friday, August 12, 2022 | Approved | |
PostgreSQL 14.4.1 | 5700 | Sunday, June 19, 2022 | Approved | |
PostgreSQL 14.3.1 | 3854 | Friday, May 13, 2022 | Approved | |
PostgreSQL 14.2.2 | 2523 | Tuesday, April 19, 2022 | Approved | |
PostgreSQL 14.2.1 | 7783 | Thursday, February 10, 2022 | Approved | |
PostgreSQL 14.1.1 | 8540 | Sunday, November 14, 2021 | Approved | |
PostgreSQL 14.0.1.20211027 | 228 | Wednesday, October 27, 2021 | Approved | |
PostgreSQL 14.0.1 | 12271 | Friday, October 1, 2021 | Approved |
Copyright © 1996-2019 The PostgreSQL Global Development Group
-
- chocolatey-core.extension (≥ 1.3.3)
- vcredist140 (≥ 14.23.27820)
Ground Rules:
- This discussion is only about PostgreSQL and the PostgreSQL package. If you have feedback for Chocolatey, please contact the Google Group.
- This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
- The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
- Tell us what you love about the package or PostgreSQL, or tell us what needs improvement.
- Share your experiences with the package, or extra configuration or gotchas that you've found.
- If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.
majkinetor (maintainer) on 18 Jan 2023 01:02:44 +00:00:
User 'majkinetor' (maintainer) submitted package.
chocolatey-ops (reviewer) on 18 Jan 2023 01:36:57 +00:00:
postgresql14 has passed automated validation. It may have or may still fail other checks like testing (verification).
Congratulations! This package passed automatic validation review without flagging on any issues the validator currently checks. A human review could still turn up issues a computer may not easily find.
chocolatey-ops (reviewer) on 18 Jan 2023 03:08:17 +00:00:
postgresql14 has failed automated package testing (verification).
Please visit https://gist.github.com/92df6bdb60a8b575939ebc7a639bec78 for details.
The package status will be changed and will be waiting on your next actions.
majkinetor (maintainer) on 22 Jan 2023 11:15:42 +00:00:
rerun
Verification Status Change - Verification tests have been set to rerun.
chocolatey-ops (reviewer) on 22 Jan 2023 12:14:36 +00:00:
postgresql14 has failed automated package testing (verification).
Please visit https://gist.github.com/07e2f791dcbe7b4612a39b4e78781e24 for details.
The package status will be changed and will be waiting on your next actions.
chocolatey-ops (reviewer) on 07 Feb 2023 01:38:04 +00:00:
We've found postgresql14 v14.6.2 in a submitted status and waiting for your next actions. It has had no updates for 20 or more days since a reviewer has asked for corrections. Please note that if there is no response or fix of the package within 15 days of this message, this package version will automatically be closed (rejected) due to being stale.
Take action:
If your package is failing automated testing, you can use the chocolatey test environment to manually run the verification and determine what may need to be fixed.
Note: We don't like to see packages automatically rejected. It doesn't mean that we don't value your contributions, just that we can not continue to hold packages versions in a waiting status that have possibly been abandoned. If you don't believe you will be able to fix up this version of the package within 15 days, we strongly urge you to log in to the site and respond to the review comments until you are able to.
chocolatey-ops (reviewer) on 22 Feb 2023 01:42:30 +00:00:
Unfortunately there has not been progress to move postgresql14 v14.6.2 towards an approved status within 15 days after the last review message, so we need to close (reject) the package version at this time. If you want to pick this version up and move it towards approval in the future, use the contact site admins link on the package page and we can move it back into a submitted status so you can submit updates.
Status Change - Changed status of package from 'submitted' to 'rejected'.