Key | Value |
---|---|
FileSize | 363470 |
MD5 | 8C8F95272B3441CC78EBA89AD24A5118 |
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.7-0ubuntu0.9.10 |
SHA-1 | 03D63A76C12F8ECF3DFC60672EBFE53C2D03A146 |
SHA-256 | 2B2F80276E2A0B5AA01DC95B6D4002C757A0A5CD9FB68350AE876D9576045105 |
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 |
---|---|
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/fuzzystrmatch.so |
FileSize | 25924 |
MD5 | 79EC4AD63957EC8560D534A4AFD1F8FD |
SHA-1 | 07BA2F06B45F063372066259BC104F7BB2F1403C |
SHA-256 | 0F1D6AA0D808B626B4FDE88F208AEF358EB2BC4DBC546D8AEA2829D8E14D4309 |
SSDEEP | 768:ZPLvOHvfzsfYgipNjp7G4ViTSeX7Pw6u7P7t24i:ZTQ3cA3i1XMf |
TLSH | T197C2B400E994D8ABC0D69F37BB8E8B1473275E70D0EBB213965D732CE9C54F1A929254 |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/isn.so |
FileSize | 52952 |
MD5 | 110F7018353EE6940564B44EAD881A4B |
SHA-1 | 0C2085C4AA79C9A72D6950E2709C06F9E9DBD2AB |
SHA-256 | B0F2726F1F3F734C033D8D5EDE5A755599A3A28E1CF4D16EF6D43EE51AF45F3F |
SSDEEP | 768:+dOuC+FsHYpXnsn2X2OWTh4VF63COt6fOF56xfL6Z/RYxpYwC+PENvilybEBnwA:o9Xs29qh4Wjt6fOSxz6lqJVENvmy4nw |
TLSH | T1163353582B50DC90E7C20ABD7AF36BE5234523FDB75533E1B03296822F955768E088BD |
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 |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/dict_int.so |
FileSize | 5380 |
MD5 | A8979CFCB0D2991B428E6658C70944C9 |
SHA-1 | 1206E798B88B7FCE4E413FBB212D49B7D8A7FE9C |
SHA-256 | BAD3758C77366334C9049D0B4E608C77A650070F5668EB0B52EBA1EFB9796058 |
SSDEEP | 48:tOv6j37oyVnk+t5VeFtyXWsTove3Fnv2FvOHUdDlA2MujH70W:tZcyVnk+PmW3J+FvCUd1rjHoW |
TLSH | T12EB173CAF1C9CC3BC4C24635626BD7A8B3A5C9481C9A0F039B09D9783D5B6F82272E45 |
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/cube.so |
FileSize | 38204 |
MD5 | 50DAB8AB61EC8A101A283AA8A8B0E3E7 |
SHA-1 | 147507148FC792527B1CD65C86CB63AEA24A9F20 |
SHA-256 | 456AC07FD3313D0E7CE519FC7F4B043894277ADA054A6EACD6A0E706BC50F0E8 |
SSDEEP | 768:1H8tOA+y4XCC1waimYd993DZs7cjsOCXxv9nN+EdJ:1H8tEyaCQxfrB9 |
TLSH | T16903098BFF16856BC5C49732F69B57263222CB9881DA6743900817242EC65FF4F67BC4 |