Key | Value |
---|---|
FileSize | 475512 |
MD5 | 5E7D287735ECE35970F69C16D1D5DAE8 |
PackageDescription | additional facilities for PostgreSQL The PostgreSQL contrib package provides several additional features for the PostgreSQL database. This version is built to work with the server package postgresql-9.5. contrib often serves as a testbed for features before they are adopted into PostgreSQL proper: . adminpack - File and log manipulation routines, used by pgAdmin btree_gist - B-Tree indexing using GiST (Generalised Search Tree) chkpass - An auto-encrypted password datatype cube - Multidimensional-cube datatype (GiST indexing example) dblink - Functions to return results from a remote database earthdistance - Operator for computing the distance (in miles) between two points on the earth's surface fuzzystrmatch - Levenshtein, metaphone, and soundex fuzzy string matching hstore - Store (key, value) pairs intagg - Integer aggregator/enumerator _int - Index support for arrays of int4, using GiST (benchmark needs the libdbd-pg-perl package) isn - type extensions for ISBN, ISSN, ISMN, EAN13 product numbers lo - Large Object maintenance ltree - Tree-like data structures oid2name - Maps OIDs to table names pageinspect - Inspection of database pages passwordcheck - Simple password strength checker pg_buffercache - Real time queries on the shared buffer cache pg_freespacemap- Displays the contents of the free space map (FSM) pg_trgm - Determine the similarity of text based on trigram matching pg_standby - Create a warm stand-by server pgbench - TPC-B like benchmark pgcrypto - Cryptographic functions pgrowlocks - A function to return row locking information pgstattuple - Returns the percentage of dead tuples in a table; this indicates whether a vacuum is required. postgresql_fdw - foreign data wrapper for PostgreSQL seg - Confidence-interval datatype (GiST indexing example) sepgsql - mandatory access control (MAC) based on SELinux spi - PostgreSQL Server Programming Interface; 4 examples of its use: autoinc - A function for implementing AUTOINCREMENT/ IDENTITY insert_username - function for inserting user names moddatetime - Update modification timestamps refint - Functions for implementing referential integrity (foreign keys). Note that this is now superseded by built-in referential integrity. timetravel - Re-implements in user code the time travel feature that was removed in 6.3. tablefunc - examples of functions returning tables uuid-ossp - UUID generation functions vacuumlo - Remove orphaned large objects . PostgreSQL is an object-relational SQL database management system. |
PackageMaintainer | Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com> |
PackageName | postgresql-contrib-9.5 |
PackageSection | database |
PackageVersion | 9.5.7-0ubuntu0.16.10 |
SHA-1 | 2BDE3B9F6304148EFB7E9C325734625040F77CB4 |
SHA-256 | C0428D7EAFFA8875EE1E295E03E4C4EB143BD167A4BAB1BAE58AA716B4AC3B1E |
hashlookup:children-total | 209 |
hashlookup:trust | 50 |
The searched file hash includes 209 children files known and seen by metalookup. A sample is included below:
Key | Value |
---|---|
CRC32 | CAC71646 |
FileName | ./usr/share/postgresql/9.5/extension/pg_stat_statements--1.3.sql |
FileSize | 1399 |
MD5 | EB0FE2C36C79E2C9A93E165A682A5ACE |
OpSystemCode | 362 |
ProductCode | 214728 |
RDS:package_id | 222721 |
SHA-1 | 00316F55E76E91551F11FC1325AE5C5AF65CECBC |
SHA-256 | AF32118751CEC1A1A9761EF569A62C92C03BDA87EFD091128020D1330E347679 |
SHA-512 | E2AD13532FBABC7F717F7D6FA3B48830D73A8BDD24C880224ED0FCEF8844C8C22AB5D05DDC1403C33627D66D297DF900AE6FDFA72FDEBEFE1CB73989BBDFBF43 |
SSDEEP | 24:YxmoDuXmXOuweKw2eKQ7WvBsb3syIz40SHLfymXzvUqY9RjTfV27:hXgZwi2CqUsyI8PagzsljDq |
SpecialCode | |
TLSH | T1DF2133963631380BB865E6F8DC0FA7B2D95185EF0D483A85B43550B40F6DE9E103F827 |
db | nsrl_modern_rds |
insert-timestamp | 1728203722.3720212 |
mimetype | text/plain |
source | snap:1zy3uUavfmiDDJGndmJytxjhErpnxf0n_49 |
tar:gname | bin |
tar:uname | root |
Key | Value |
---|---|
FileName | ./usr/share/postgresql/12/contrib/sepgsql.sql |
FileSize | 1644 |
MD5 | 9E1AFBF02A645143D8BC69C38B945BEC |
RDS:package_id | 222721 |
SHA-1 | 030AFBD139D7A2133ADD05401D4DB702798DF036 |
SHA-256 | 1F5E1386E651D6F76161FA009842F6A64789543D83FF1FBA589101995E29AF0E |
SHA-512 | 27F84C7EFD719E26D4ED3A675487EBF06CFE6779CC25C7DEB95C3AD4D89B1B549088D08A24D6BA2C240DFD5F88B7EBD93CE5839FC0D2DD82E98D6E47B12C06A6 |
SSDEEP | 48:iZtrMCB8cM21BFQICMuAcRNsuEZ/WhhuDe:a9hUpEOhhIe |
TLSH | T17C311F163EECFB42E9B2D7B065E3CE21CE00542B29256ACC32DEB2540F607D461E7476 |
insert-timestamp | 1728243589.9536636 |
mimetype | text/plain |
source | snap:qTrmKx7sF7jXgcofO1a0ZKeuYnJRxmRT_6 |
Key | Value |
---|---|
CRC32 | 8A6B3E06 |
FileName | ./usr/share/postgresql/10/extension/chkpass.control |
FileSize | 150 |
MD5 | 6C4208300DF0DB8053A4F789BC504329 |
OpSystemCode | 362 |
ProductCode | 227528 |
RDS:package_id | 222721 |
SHA-1 | 04F2F932B4519792CF942500A93489E0A1D78668 |
SHA-256 | 86AA11CBDB87B199FB225103894F3457321C8BA3B117B1404F7615700EA096E7 |
SHA-512 | 3AD69F6C96F75721F23EBCBDE775E723231A9CC481A6EF9CACBACF65C5887920F498F196AC5787E855375F0601C7052EA6A0204AA5A4F4845C7EC0FF17013278 |
SSDEEP | 3:SW2AlTVodU95AaWgXBaB4AGN6KB8VERNwoCEHBUkeEGpdFR1n:SnAlTVodmeaWgXPNhBEErwoXHBUnvn |
SpecialCode | |
TLSH | T17AC08C4430F988931038AA05CD0000409AB279BC2201346232BCC1E814E0B8AA28070C |
db | nsrl_modern_rds |
insert-timestamp | 1728213063.1994183 |
mimetype | text/plain |
source | snap:uGPNhSRJ9EjdUR2tQlM8viGtlpGOcRpZ_52 |
tar:gname | root |
tar:uname | root |
Key | Value |
---|---|
CRC32 | 1771C7E9 |
FileName | ./usr/share/postgresql/12/extension/tsm_system_time.control |
FileSize | 192 |
MD5 | 363B93F1ED8E7253C645DD7F52298287 |
OpSystemCode | 362 |
ProductCode | 214728 |
RDS:package_id | 222721 |
SHA-1 | 073AEC77773B867F4E3657AC87EFB38F4C1BE537 |
SHA-256 | C919909EB8E9060B6C9516FA3D74F75AD7F76A8B9AC159ACBA65C3E7988EE5AF |
SHA-512 | 665A38997ABF8C005EBF7E66ECC925ACDAB57889799A94A7C5DCC6BFD758C3C275550DA1B5BCC5B2F9A7FEC6AB4B81870F5DAD345F7A5BD75630A74F02434E76 |
SSDEEP | 3:SVtn9F4mTqkoOTraQ3Em7/9FKFxHX2LA6CIQ5B4AGN6KB8VERNwoCEHBDP/tn9CK:SVrF4mTfZTzvxsFxX2LAvJSNhBEErwoZ |
SpecialCode | |
TLSH | T1BDC0121102B964E254AC7609D74266C2BF7078B82042B9AD36CEC4A050DE66A4355929 |
db | nsrl_modern_rds |
insert-timestamp | 1728206345.6955073 |
mimetype | text/plain |
source | snap:GoV2YaJT1a71k1OxwmwN1l0MctPVUGdx_50 |
tar:gname | root |
tar:uname | root |
Key | Value |
---|---|
CRC32 | AE6F8157 |
FileName | ./usr/share/postgresql/12/extension/pgrowlocks--1.0--1.1.sql |
FileSize | 651 |
MD5 | 3100F7B398C8B8429C03CF4EC65A18E0 |
OpSystemCode | 362 |
ProductCode | 214728 |
RDS:package_id | 222721 |
SHA-1 | 074021C222CEEBEE320599EFEB1FD01A1C19AE70 |
SHA-256 | 679105D3CF9C1AE69EE1F95653BC3BDFD6501B1CE2B4F166749937C7A7C9E52F |
SHA-512 | CD018A35FD173F796B371FEFB33E2A18058ED562FD3CA0940C2E6B22F6E83398C439C1F91BAA5A86F4AF317D842F649C897B31180407702681431F511F40A665 |
SSDEEP | 12:UCONOOOSoUEeBNFY/tlSvO9HSvO7SvOb14SvOb1emSvObfqK9eCWZCaCAI2XWRuR:bpJConQWQqQtQ2emQuffA/XWYbSOF |
SpecialCode | |
TLSH | T105F0441EBFB5B50151F027E5ED3C84B1B500840F1F09A350A4A7D2B68FCF888CA2E755 |
db | nsrl_modern_rds |
insert-timestamp | 1728245026.5658987 |
mimetype | text/plain |
source | snap:idVMgkvkiKaOC8BjKlJRPUH50fvibpp8_179 |
tar:gname | root |
tar:uname | root |
Key | Value |
---|---|
CRC32 | 0DB7DC45 |
FileName | ./usr/share/postgresql/12/extension/tablefunc.control |
FileSize | 174 |
MD5 | F45BD2855D6BE339586F5DEF199F0ACC |
OpSystemCode | 362 |
ProductCode | 227528 |
RDS:package_id | 222721 |
SHA-1 | 08056420C7C60622057524F0E7E237012B6EE493 |
SHA-256 | F9EB2E2DFDABB3CB64DC7A347E3CCB10B8F88352B1D53681CAD3A932AB9BDC17 |
SHA-512 | 3C96F723BB6AA30EC23CD559F926C7C16100DDD3C843A6333D13223A1A81454FD8137BC5F19263EBE932A3DDCA3CB4565F5CE19102ACF786140E943CC0AE7FBC |
SSDEEP | 3:SkOKeBTmyqZRLEYM+KqRuZUMSkCy4AGN6KB8VERNwoCEHBDGAKUpdFR1n:SkQBTmyqvm+KqkOMHINhBEErwoXHBTlv |
SpecialCode | |
TLSH | T1C4C08C2513FAB0A3486AE628D68650589EA17AF82501387912DB848411F479E7A53E2D |
db | nsrl_modern_rds |
insert-timestamp | 1728213061.7982585 |
mimetype | text/plain |
source | snap:uGPNhSRJ9EjdUR2tQlM8viGtlpGOcRpZ_52 |
tar:gname | root |
tar:uname | root |
Key | Value |
---|---|
CRC32 | 134B8875 |
FileName | ./usr/share/postgresql/12/extension/moddatetime--unpackaged--1.0.sql |
FileSize | 266 |
MD5 | E85C64C2606023F807FF864994E23F7C |
OpSystemCode | 362 |
ProductCode | 214728 |
RDS:package_id | 222721 |
SHA-1 | 097F7F86712C6F732E79DA4577A9E3CDE1FF0920 |
SHA-256 | 265BA33AD821EA33E022128F00183B11703A2C561327412E1D3632D9B3A9AE77 |
SHA-512 | 9B48BB306025603D03B2D48CA7402E87BC11CADB59507FD5885113F954D61294DF92883535DD8922E2B1A8AA490F3FC4A7DF07DE60995337F835FAA85BE0AA88 |
SSDEEP | 6:UTCI2WkI/JoUEg2WrF8QjNFY/uABGjjBpkeXzxGUOH:UhZJoUEeBNFY/b01pTlbM |
SpecialCode | |
TLSH | T181D0C2072528391445119E4C610300F0AE128A3E48413CC090031692DE61E99159E8BC |
db | nsrl_modern_rds |
insert-timestamp | 1728213061.7119465 |
mimetype | text/plain |
source | snap:uGPNhSRJ9EjdUR2tQlM8viGtlpGOcRpZ_52 |
tar:gname | root |
tar:uname | root |
Key | Value |
---|---|
CRC32 | 11681F31 |
FileName | ./usr/share/postgresql/12/extension/pg_stat_statements--1.1--1.2.sql |
FileSize | 1336 |
MD5 | 9B88D1B724D091B49E4C2383E295F18E |
OpSystemCode | 362 |
ProductCode | 214728 |
RDS:package_id | 222721 |
SHA-1 | 09EDCA39174495A85E15F9D3E76DB530D4BD348D |
SHA-256 | 585BCD4B958D9509A4884807895263DC408CD84DEB591422FB5088C84797A03C |
SHA-512 | 845F6B6BED84783F5ECF3B257607F7BF1D7A3C6FACAED38F0AE1CA64D69C0B1F2F6A49EEF81C9D123EBFD1DF809275ED04B1175B4433561491B9CF0628EF2FA9 |
SSDEEP | 24:YxfoNZ6qZ2H/EkheKQPvBsb3syIz40SHicqY9RB:89hCBUsyI8TlB |
SpecialCode | |
TLSH | T1EC21F85A7A223E1B781896F4DC4F53B3958089DF0D483A88E97550B40F69ECE213EA13 |
db | nsrl_modern_rds |
insert-timestamp | 1728245026.0522642 |
mimetype | text/plain |
source | snap:idVMgkvkiKaOC8BjKlJRPUH50fvibpp8_179 |
tar:gname | root |
tar:uname | root |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/9.5/lib/pg_buffercache.so |
FileSize | 9472 |
MD5 | A845C70774712FC024B3B4A9371298A1 |
SHA-1 | 0A6D6BDAE5CD7822780BFC8F11DF547FCB339369 |
SHA-256 | 5E4BECD69F603F33850229DC5296139BE0C3250101F3CB3EE2216B8352320849 |
SSDEEP | 96:OMLS4D4YMBWBPaYmEoNzOQderuQpUC4QTFmyjL9ZgFT1cHNoIJPFSnFBSy2dmvWl:OUc58pxmEkz6uQT4QTFqT1CNoyeM |
TLSH | T1AF12C65DFFA58972CEC3133844FBAA19C274C182A237B7937208C6084D52795AE37D5A |
Key | Value |
---|---|
CRC32 | EB5AA855 |
FileName | ./usr/share/postgresql/12/extension/hstore--1.2--1.3.sql |
FileSize | 525 |
MD5 | 40BDF12C0D1139A7F587039F78F357DE |
OpSystemCode | 362 |
ProductCode | 214728 |
RDS:package_id | 222721 |
SHA-1 | 0B6D48998C27136926D39D31D3A651A29F81C4C3 |
SHA-256 | 0753C346E86147CB7767F603310B774CFF6AFFB11E65C2D5CAF173CF0766AD2C |
SHA-512 | AD42734216CD42CF40B2F04E8BE5E1C010FE666F95953B192889885FDD7A1270A20A6E33B1C4A7267A39519070D1E2FC8FA6FC8A18A4D96677AAA0CBC3578C59 |
SSDEEP | 12:UUM+UEeBNFY/t0joOeU473zFxFUeeq73MF3:io8BeUo3pEeee3E3 |
SpecialCode | |
TLSH | T1ECF02B8B241535310BE57F8EF4258AA6AF40C8C58C2869F4B45BA57C9E8FC05473642E |
db | nsrl_modern_rds |
insert-timestamp | 1728245027.5396037 |
mimetype | text/plain |
source | snap:idVMgkvkiKaOC8BjKlJRPUH50fvibpp8_179 |
tar:gname | root |
tar:uname | root |