Key | Value |
---|---|
FileSize | 429420 |
MD5 | 6CB9116EA6488AA10AE635C6923E54F6 |
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-8.4. 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 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-8.4 |
PackageSection | database |
PackageVersion | 8.4.10-1~hardy1 |
SHA-1 | 3AA51C7FD3B5CF92943123EB8F450AA2F225A07F |
SHA-256 | FAE37543E149B18720152DE6EEBA87E91AA17EB21F5511EAAC621C4FD147B44A |
hashlookup:children-total | 117 |
hashlookup:trust | 50 |
The searched file hash includes 117 children files known and seen by metalookup. A sample is included below:
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/earthdistance.so |
FileSize | 6056 |
MD5 | 4B159906062677C83C94B856A7A71803 |
SHA-1 | 022F534C9B86D20FA2DDA9B498B445D4052B99C4 |
SHA-256 | A550F0058B4734C750B44BF7FD7DD5A6179819FC62E36485E7835616892CC723 |
SSDEEP | 48:RyYuT6shh9EcsELrH8Z1YJNc5MEeBtasjmAbU6EjYOSusJ:RyYuT6shXEVELrHcoeMtQ6+jYOSusJ |
TLSH | T18BC1FF57F364CE7BC82913B894AB4370B374D858072A83132BC8F6397E722D84A22695 |
Key | Value |
---|---|
CRC32 | CFD6DE14 |
FileName | uninstall_btree_gist.sql |
FileSize | 7730 |
MD5 | 26B7C3314EAE9AECD2A3FAF5893202A0 |
OpSystemCode | 362 |
ProductCode | 15109 |
RDS:package_id | 15109 |
SHA-1 | 030FCD16A47BBCA8EF265B158A622A184C111956 |
SHA-256 | 658439FBC3485B137503F84947E342299453CA4CC5A780E8CF0073A3F5B0CCAE |
SSDEEP | 96:e3gZYjuOlrHrAxCGKZgeLr24dLGM8c0c3:O9rHrAxM |
SpecialCode | |
TLSH | T1A1F1F13B20F76EEAC6B5B750CE6093423559251370E7CA5009BCBBB885E3811D7AE76C |
db | nsrl_legacy |
insert-timestamp | 1648778425.6213822 |
nsrl-sha256 | rds241-sha256.zip |
source | RDS_2022.03.1_legacy.db |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/isn.so |
FileSize | 80648 |
MD5 | 77A3A5895AF80C6FAFCD11B79F60149C |
SHA-1 | 042B4A8EBCC4C67A9B006C643E43679FF7628DEE |
SHA-256 | 8E477A8941E5D256E89481B039FE8B672D9B4FE3AD9F8E51C71268DE59934EBF |
SSDEEP | 768:4zPrC3pf2d831NjLojlteIpTn3guxvL72iWkEFBMqsiudGjH1/+G0qNDWDaPolVu:4S39JTno6IpL3gukFqIyQWUgRZxsmS |
TLSH | T19973A8A163F45EDDF2F74A7EC125A3F1A0427BB26B11368CE67286172F5509F83099C2 |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/sslinfo.so |
FileSize | 14496 |
MD5 | EAB4F9037E505DE493A2A52937655BA6 |
SHA-1 | 0AA4D63A0E859610B43696357EA272393040F3C1 |
SHA-256 | A676A61EA741EC51D938D831B07E737B60EDADEADAE01F62685762B2025F65C3 |
SSDEEP | 96:Rt9MW+Xbi9BhH38sCD7hZMPEBTkHn0YSDymZcVDSOPXm7jhkVJlQ6lDYOCu3u:Rj0bi9PH5Cn7kEBdDxgDJXm5uJy |
TLSH | T10B52720FB5844A7FC6CA437880DB87325674A4C0EBA397132618F27A5D62788971FAD9 |
Key | Value |
---|---|
CRC32 | 97773D37 |
FileName | citext.sql |
FileSize | 12720 |
MD5 | D9751EFB7538D2FA773046A9CAF38F17 |
OpSystemCode | 362 |
ProductCode | 183361 |
SHA-1 | 0DCD8491152DF7FB5BB48DE5D7BE538E1DE47B62 |
SHA-256 | 2B63F56F19863832AB7CF1DA8BB3B55B333743CEE2382C59D69AA9B9658B0C2B |
SSDEEP | 192:DSnt1K5hsCgQxj7ojKnlhLGs2MaB3mJ4LbXqj6GyA6BnmR4zbXCjyFcE7IS1RD6j:D0TvPNnm |
SpecialCode | |
TLSH | T1FF42BE5F2A6D3A03D2F2A720BF6691A154511147DC19DDE038EEA1D40FFE82CE3F5529 |
db | nsrl_modern_rds |
insert-timestamp | 1646982771.5517967 |
source | NSRL |
Key | Value |
---|---|
CRC32 | 0F67B509 |
FileName | timetravel.sql |
FileSize | 542 |
MD5 | F0A3A8477B0883BE98292928CB614CB0 |
OpSystemCode | 362 |
ProductCode | 183361 |
SHA-1 | 0ECFBFCA76C2C94BF39B1694399A029A069FF084 |
SHA-256 | 4C6C46EC5C48E3C1066755163BC5CD1A48BD76F8911799B02D905790FCC24FFC |
SSDEEP | 12:UBn2Iq9zGtCVQwDk1UunbU/GYMigdU7G4/:+htCSgL/GYMi5SM |
SpecialCode | |
TLSH | T18CF08B1E13F4732285B3EB21781386C40F60086E3A7C1EE022A0B0DD6B5E41242A7D61 |
db | nsrl_modern_rds |
insert-timestamp | 1646983179.1110597 |
nsrl-sha256 | rds241-sha256.zip |
source | NSRL |
tar:gname | wheel |
tar:uname | root |
Key | Value |
---|---|
CRC32 | 5B3D29C7 |
FileName | uninstall_earthdistancescr |
FileSize | 593 |
MD5 | 8E030229DCE4351E0ED0C6DE37EB5E9C |
OpSystemCode | 362 |
ProductCode | 15109 |
RDS:package_id | 278275 |
SHA-1 | 0F7742C127A59B9874E51491B003598B71564732 |
SHA-256 | 1F6F2CA44349DC79E53F7819276CC4A516084A3F6BD19C4330ADDAF9DE2E5958 |
SSDEEP | 12:UBn5MA49z/CVqmkkBzcK3DbzSzBcCQ7oGIS:+HQCQg9izBcC0oGIS |
SpecialCode | |
TLSH | T138F0C20C33B27B31D8B0B1B1AD266A028F028184E1581A5289ECF87641F5C5DC7F3954 |
db | nsrl_legacy |
insert-timestamp | 1662197471.8275626 |
nsrl-sha256 | rds241-sha256.zip |
source | delta.db |
tar:gname | wheel |
tar:uname | root |
Key | Value |
---|---|
CRC32 | AE068D5C |
FileName | tablefunc.sql |
FileSize | 2306 |
MD5 | 1CBF0E1AC422C41A04E57328EAFEC129 |
OpSystemCode | 362 |
ProductCode | 183361 |
SHA-1 | 11261265E0CA0621F3D1B4083684DAFFA8946D42 |
SHA-256 | 6192C12DB3C6A3696E90C7BECE334331B443FB0CCA947510A594B5FD6262FB37 |
SSDEEP | 24:+85CSgDR73keLw9M9/7mzNAOnuk9h1dVaCAHuYspeFLd7v0y:B5s549uk9SCi8el |
SpecialCode | |
TLSH | T17A41CC6F3FBD7252D2B38738765BD0518C40322B0D959CE011AFA39009BE50A9FBB8A1 |
db | nsrl_modern_rds |
insert-timestamp | 1646984186.0353575 |
nsrl-sha256 | rds241-sha256.zip |
source | NSRL |
tar:gname | wheel |
tar:uname | root |
Key | Value |
---|---|
CRC32 | D76B3D3A |
FileName | pg_buffercache.sql |
FileSize | 779 |
MD5 | 2F0070334FC60D27ADE12E1983BC4A2E |
OpSystemCode | 362 |
ProductCode | 183361 |
SHA-1 | 13FAE428F3C0ACAEB60E8565B5AAB4835A560CC5 |
SHA-256 | 31395277F8E40CEAE03D5F1BE02969D6322EDBDF5DCAD9AC118E4CD6EF729647 |
SSDEEP | 24:+V/GOlCSlmXxBYrbhEWcgkWNlWBCPpEFgfIP3FZ:g7ng5WcgZXWsxsEIL |
SpecialCode | |
TLSH | T1B6019C96EF9722A12465BD22BC0B1D39C702845D8740A0A6ED30A26C6555E62D84BD39 |
db | nsrl_modern_rds |
insert-timestamp | 1646985407.2763832 |
source | NSRL |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/pgrowlocks.so |
FileSize | 10368 |
MD5 | 5A99AEF09610424A814779F2C3930FC8 |
SHA-1 | 16C9A988FA4C764ED92A1E78E2F3B589FC363C2A |
SHA-256 | 1732CE3BF4B48CF7636BB43A587861B954036F4E0A87A468DD393A002CF3005E |
SSDEEP | 96:RPyZ4SsvazSNB5E8tuIyDQx6hFsFwiG017c/S0o6lD4uKu36:RlrlNTE1Iysm7iDDt |
TLSH | T19822B44BF851D7B2C05C433045AB423936749A044BB2DB0B5318F57C7EA7BD90A37EAA |