Key | Value |
---|---|
FileSize | 385384 |
MD5 | C78C4BD0D7F99D45C3609AC46FBB03A9 |
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.1. 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. seg - Confidence-interval datatype (GiST indexing example) 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 | Martin Pitt <martin.pitt@ubuntu.com> |
PackageName | postgresql-contrib-9.1 |
PackageSection | database |
PackageVersion | 9.1.1-1 |
SHA-1 | 28AF1DB7F9BE70DB092E22582E5BC954A3908A30 |
SHA-256 | 04E8056DAC152D1D37D63CFDCA6FE876C32DD4F4924606EB0589F9C8C35F9143 |
hashlookup:children-total | 167 |
hashlookup:trust | 50 |
The searched file hash includes 167 children files known and seen by metalookup. A sample is included below:
Key | Value |
---|---|
FileName | ./usr/share/pgsql/extension/moddatetime--unpackaged--1.0.sql |
FileSize | 108 |
MD5 | 4D12F7F1A22A14C7F2F8615FD0A8094B |
SHA-1 | 00A5C866910051BA32EA3586D75DC844B07B9781 |
SHA-256 | 7AA0B04F35EFF3B3812FA89935F438E164DA1E3B0A38E8CFC390730310235F8E |
SSDEEP | 3:Uv7CIK3DnzWkII0Jd/9moDqkeoHEmiMw:UTCI2WkI/JDxGUOH |
TLSH | T1DAB0120A74703D189C025B0C940645E49E43C62E56003C90C1056EC38F35D7D626F4BC |
Key | Value |
---|---|
CRC32 | 8A6B3E06 |
FileName | usr/share/postgresql/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 | 0DB7DC45 |
FileName | usr/share/postgresql/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 |
---|---|
FileName | ./usr/share/pgsql/extension/dict_int--1.0.sql |
FileSize | 572 |
MD5 | 57DA3919B21224F91BA935DF2E9959BB |
SHA-1 | 08A6F6272317FC2223D87297BB7D462E67411916 |
SHA-256 | 3D380DCE45AB0EB891C3A37BA0A1FD8CCF937A267A7F410606FAC0E6570F5F5A |
SSDEEP | 12:UiGNJ+evy6xJJBWeEANM2v2v2vxJJBWqabGAJ0zsLntW:INJ+e6iPWeEAbOOPPJAJHs |
TLSH | T141F0F6BBD4E6E50727B3AE35397241B084915037A9E9DBE430AD13744FEE4A0837A72C |
Key | Value |
---|---|
FileName | ./usr/share/pgsql/extension/pgstattuple--unpackaged--1.0.sql |
FileSize | 299 |
MD5 | 67B5F6E3794280A8562E46090B9998C0 |
SHA-1 | 0B0BB1D84F8B2A60F665E20B4D22AA58617F6A1F |
SHA-256 | 9278E47CB4B42337CCFB75E484C0A680CFFA398B78AB977114CAEE43203E5FEA |
SSDEEP | 3:Uv7eUAQhvWkII0Jd/9m/83FMoelbpmq9m/83FMoe+vpmq9m/83FMoerpmq9m/83t:UTeHQ1WkI/JDYcGjIGFGtKwH |
TLSH | T18BE02D4C34C4348378221B589A0E46F99F61C7488801FCA8510EB6C18A51A95C78E92F |
Key | Value |
---|---|
CRC32 | AAF0AF68 |
FileName | usr/share/postgresql/extension/fuzzystrmatch.control |
FileSize | 175 |
MD5 | 1685FACDE79D7982EC1A8BA6A5E236E1 |
OpSystemCode | 362 |
ProductCode | 227528 |
RDS:package_id | 222721 |
SHA-1 | 0C02424D7BD4280A58E790616F5C70662DEEE602 |
SHA-256 | D6EA45DAE72DE4E997696933892B8605520666D00C06A528EDA3BCC89D0ECF83 |
SHA-512 | 824F3F9BEA71947E2F676B46CFB57E77E7C0512258122C58D39DE3451C2E1A5AB6BA70F7492FE6C785B0EAB6F60A053E1E4F2EECACDBE3A1E5511CD679AD7E5B |
SSDEEP | 3:SeJXIENd8BTtxLA65XpF2MDygHZV5B4AGN6KB8VERNwoCEHBRQhXIEnXSpdFR1n:SeZ5Nd8BTtNAKXrZjINhBEErwoXHB2BA |
SpecialCode | |
TLSH | T13BC0803103F55462886C5E45C4212442EFB72AF823113437EEDCCC9417D5B4F91B156C |
db | nsrl_modern_rds |
insert-timestamp | 1728213063.1358984 |
mimetype | text/plain |
source | snap:uGPNhSRJ9EjdUR2tQlM8viGtlpGOcRpZ_52 |
tar:gname | root |
tar:uname | root |
Key | Value |
---|---|
CRC32 | A467E611 |
FileName | usr/share/postgresql/extension/cube.control |
FileSize | 142 |
MD5 | C0FA1DA69329FF0E7DF27B3C3668CC4F |
OpSystemCode | 362 |
ProductCode | 227528 |
RDS:package_id | 222721 |
SHA-1 | 0C7BCB6EDAA499386F925CF7AC00023AFC037235 |
SHA-256 | C82DF99F95DCC37B0F4CC9C2B7255967673D481C127712887D59865DD8EEC74B |
SHA-512 | 04F8E76F425D88BAF8961F4AE41D01A9CF03364E36083602A918E8FD02CEA7E22FB8FB4C9FD9151E0D52721CDB1EF1910A7BE41E699768E5028B6B7C5132933C |
SSDEEP | 3:SgATcTVodLMju+88B2F4AGN6KB8VERNwoCEHBUSACvcKGpdFR1n:SmTVodLmu+88B2GNhBEErwoXHBUS4vn |
SpecialCode | |
TLSH | T18DC0220820FA80A3283CAA00CC000000EFF23CB8320238A322CFC0C020C0BCAA288B2C |
db | nsrl_modern_rds |
insert-timestamp | 1728213061.5797694 |
mimetype | text/plain |
source | snap:uGPNhSRJ9EjdUR2tQlM8viGtlpGOcRpZ_52 |
tar:gname | root |
tar:uname | root |
Key | Value |
---|---|
FileName | ./usr/share/pgsql/extension/file_fdw--1.0.sql |
FileSize | 336 |
MD5 | 02554444BE7542FEA66AD3B251D5FC6B |
SHA-1 | 0D1E95AE7B83E9228DD7FE9FB962532946FB85C9 |
SHA-256 | 82426B92FC74937BC579E10B3FF35FA61BED7C0DA60085D87B717D6F5BA7D9D4 |
SSDEEP | 6:UTQpG+UNJ+eCuzSMREEheCuzwsSr/KEh/9quyrJuz7SsiMMzwsA:UfJ+eCuOk7eCuksaN/XyrJufKMMksA |
TLSH | T191E0803E5C5EA28547A3FD7D3744C4B6D545033A5508DBD010C9721C5CCE85543EABBD |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/9.1/lib/pgxml.so |
FileSize | 13584 |
MD5 | 5073BB7B9BCEE00493D8C1EEB9EF842F |
SHA-1 | 0D91B46B75CFD373AE282394FB36DE29ADBA5EC3 |
SHA-256 | 0E30BA87F35FB5EB00E301264833FEDAF2E7A5DF1C29AC8B73B8C63432D41300 |
SSDEEP | 192:+UX5dkJDjZeixh/NKtd6uyxu2Vyd14vkJQ5WHOk:+UpoheiZuSu+LvkKsHOk |
TLSH | T18752A69BFB8B6833C4B21A36C8472F45B528A6C9565B9F23854C046538766AC8377FA0 |
Key | Value |
---|---|
FileName | ./usr/share/pgsql/extension/tablefunc--1.0.sql |
FileSize | 2013 |
MD5 | 71674E357506E5CD12B91B00D40B105B |
SHA-1 | 13731B3DC2F3A574F1B7F27611B6683CA3729E9D |
SHA-256 | D02631AE74AF9B74A74C20612B06A4AAEC5B71DD5BAF503DC6B6C98EA277BB4B |
SSDEEP | 24:+J+eNORmeSkeLw9M9/7mzYeeeT4ePC9hweMOeXCXeXe3mspeF2emme4Cy:1fUz4sLM4AC9GeqCXet8egM5 |
TLSH | T1D0419BAF7A7D721243E36A3D245ED0A1885232031DDCDED020AF526159EE80AAF779A4 |