Key | Value |
---|---|
FileSize | 398144 |
MD5 | F105EF49F202A6D34AAD47C17C22FE2C |
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.4-2 |
SHA-1 | 067881A40A026C66268C782CED5C00253C919E27 |
SHA-256 | A14D564AE12E9549AECD13C972D5A41B9D385A7BFD159D1BFBF9B56F03FBF26A |
hashlookup:children-total | 115 |
hashlookup:trust | 50 |
The searched file hash includes 115 children files known and seen by metalookup. A sample is included below:
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/pg_stat_statements.so |
FileSize | 17792 |
MD5 | D27CC7B8C19FB8D854192A796D49DC85 |
SHA-1 | 000AC41027E0ADBB4C367E8E40B0FFF71EDF49C5 |
SHA-256 | 40BF950304855759B1DC8368E002382B5F555F25006B5827A99DFF30EF567299 |
SSDEEP | 192:VvISsdaGnQogHsfEa6fmmlHG7PgczMSblxbxImYdwLBnTlJKO1mdHHhM/XF4g9:VvjHs8TubLgczMSZudwLBnpYOkdnGb9 |
TLSH | T1DD828342F70F4C17CB1A2B38546FA381634EDAD184F8857F120B420A3BF56749966EEE |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/pgstattuple.so |
FileSize | 17732 |
MD5 | D009FFAF989F092EB48806C4AC5D4138 |
SHA-1 | 017417412EB6EA2D62258FA29E250C9A541B11C2 |
SHA-256 | B5DD01CBA536B1E6802BA1929BEBB6508053AD8504218E6FAC3CCBED011F96C6 |
SSDEEP | 384:3/5G9Fa05sLPiVTn682c7y+Nbc+wLdKvpkw:3/aNF2L1dK3 |
TLSH | T1E182C548F30F8923CA271E34056F93C8A71AED5491F885AF130A370B76E5A346927F9C |
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/bin/vacuumlo |
FileSize | 22004 |
MD5 | 1C432CD728A28173DF868F9753CE2796 |
SHA-1 | 0A28604DFD7082E1FDC5D1B38FF68A58A1214E40 |
SHA-256 | 3A54E6D04CDCE471E056AAE721DEACD6CDC1D34760BC5D02AA8B0729492216A3 |
SSDEEP | 384:ekTdf+cVG8a5M9lyRlE10mhEs/HlJHW2v+SwuWqCL+0CkoobgkoJYkNcLlNLT7aG:7R3VGu90bFm2s/P2WdCTeA5 |
TLSH | T133A2A495731A4C07D2657FB812BB8381972CAD868628D1DF324EB34727F063A185BB9D |
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 |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/chkpass.so |
FileSize | 9536 |
MD5 | 29EE92625BF884DF3A38A7BD6E405585 |
SHA-1 | 0E9E852EE2125951F133CCB21B5FA3398D8DB5C4 |
SHA-256 | 02D6A910070F739A5CE66908043B38DED73FE2AFA8F168CCF379E3D61215E17D |
SSDEEP | 96:q/B4gsVVEwYj6K/q0KOimK13F55Z0+WSwagk+bvlllMHzKzHHTn0D:841bEwsP/Y155Z0DdzS0Q |
TLSH | T117129796F30A9847C6593B3445FB97046319CE428469D3AF339B619B7AE21700C11FDE |
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 |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/cube.so |
FileSize | 46544 |
MD5 | 18E0DF07E787832BE05E274758979915 |
SHA-1 | 133139A9FA68532F79C6CFF71F0E62351D111524 |
SHA-256 | 76B080F68AD9DDAF7B8CD7DA74D8EDEDBCFC194F69AE93633548F5FAE1A2426F |
SSDEEP | 768:aLNkCA+yUFED1Bglo+kQCsY6sl+3c9wQcBLXgLzyGYs+o+TXX9BJ8:ay4yMIF+fCg4KiaGzhNr |
TLSH | T18323C645B71E048BD2662E34157FA3C4634EEF8290BCC5AE231E65472FA59A36807FDC |