PK
(9Qݻ/ _rels/.rels ( PK (9Q$ postgresql.nuspec ( Xn8o`] M[v:3dT:m&3@;,iQmH'CNN#E{xT]њk#|>'ßfo؊J|Z[S33EQK;UTBtL<ߙd00%2g
eJss%d<
~mRuT+kVTiL-XFgȹtUYA#\몍^}[)V7<귵l&b.
cƀf3\+
B61 UZ}aAO!/V'rf%ptq|Ucf\U45淥ue8epadnb-
0$f9̂ BbIڜ}7CrR.ί.ޝSR̒M9'ݒZKR0goxƷRE hEu{90s
lEH6R2҂,Ldlq
s_32NEC11hYp*1*K~1P"bZleԜ;'i(to(5ˏThf=ɉ,` -zðǧ_Me{CxYw
r\2c6J'MV9[$VGɨ*r1$k+pl#8j9jU&E88!e7B[}5Ta( 5[sI,X*C -cԹJTXPG-`J2QƵWVlE7v)[ڪRðóAs>|1 G:B.
}9~,?UILFV9;lC FxabCWfXg'yVZZ^c-V/"C'
91r_!$meknBk j" =G+n]GX`de)>jI鷞';?Sgjd1J)[8B@OHJ^dPD5 =ōدH\Xշ"<@3ImY"}C/:h薾WjYB-r:Kej-ۂKZ"P>heJ~VuULDEoί~}*Ieuil}A.Jqh!mJѻju4W;:
YZFi;;?8|+w8`㰾rxa롐Aa-g9o[[p XbnSʹK1'MM[AК̓/8ms-ZqHKf?Mp j5?GH
b*/Ͽizzd2=Y> tH223*8˻!I5,A{{cw>#ռ ?oZW%,`qm !6w{+=M ]Fq{FF3H(rua._Ǫymja~ZA_E%χz6>]W>)h{xr=/PK
(9Q{z z Q package/services/metadata/core-properties/8e6a3d984c564f8da583005655de578f.psmdcp ( PostgreSQL Global Development GroupPostgreSQL 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
- [Feature Matrix](https://www.postgresql.org/about/featurematrix)
## Package parameters
- `/Password` - Password to be assigned to the `postgres` user. If omitted, it will be generated and shown in the install output. PostgreSql installer ignores this parameter if there is existing installation.
- `/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](https://www.enterprisedb.com/edb-docs/d/postgresql/installation-getting-started/installation-guide-installers/10/PostgreSQL_Installation_Guide.1.16.html).
- If you have problems during installation see [troubleshooting page](https://wiki.postgresql.org/wiki/Troubleshooting_Installation).
- 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` to `trust` and restart service with `Restart-Service postgresql*`
- Execute `"alter user postgres with password '[my password]';" | psql -Upostgres`
- Revert back `data\pg_hba.conf` to METHOD `md5` and restart service
### Virtual package
Each major version has its own package: [postgresql12](https://chocolatey.org/packages/postgresql12), [postgresql11](https://chocolatey.org/packages/postgresql11), [postgresql10](https://chocolatey.org/packages/postgresql10), [postgresql9](https://chocolatey.org/packages/postgresql9).
**Virtual package** [postgresql](https://chocolatey.org/packages/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
```postgresql13.0.1foss cross-platform postgres postgresql sql relational database adminPostgreSQLchoco, Version=0.10.15.0, Culture=neutral, PublicKeyToken=79d02ea9cad655eb;Microsoft Windows NT 6.3.9600.0;.NET Framework 4PK
(9Qܴ [Content_Types].xml ( PK-
(9Qݻ/ _rels/.relsPK- (9Q$ 4 postgresql.nuspecPK-
(9Q{z z Q )
package/services/metadata/core-properties/8e6a3d984c564f8da583005655de578f.psmdcpPK-
(9Qܴ . [Content_Types].xmlPK 8