Key | Value |
---|---|
FileSize | 414626 |
MD5 | 6DFAF6A3D3B77F97F0C10D57D9E75C10 |
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.3-1 |
SHA-1 | 214FD2C49529B1E9E471613FD0150F96DD05435F |
SHA-256 | 0AF0FC96A47FB2A0093928E543C027639A2270D62FDD842E90AF3C0DB6FE153B |
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/btree_gist.so |
FileSize | 63520 |
MD5 | A95C07AC3E208D99C1BD2084CEAF7C78 |
SHA-1 | 0144DB94AAC9FEA22A98C927EC9D4D487BD5DB40 |
SHA-256 | A44E2114D692EAA502395EDC366713C92DA10E593447A105360A9FCFFA00E946 |
SSDEEP | 768:QeLLr80vN7S40q2QGpV7muoVUG0mKTgdXyH0AqRlAYtPyQrNy4f7mraEM81tR+fT:Qu8ueIRlpVyQrN57mrPXR |
TLSH | T14653D737B05AE5BEC5EBA374C48FD3726769B44127018E363910D3BC7E2259A468F6C2 |
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/citext.so |
FileSize | 10096 |
MD5 | 6604F790FEFF2E172AD6A1B01D420946 |
SHA-1 | 063AF34C5C5E06E7D3D4711786F727E66F023FB8 |
SHA-256 | 999AC118751A18A456038F8BECE68DDFD38CAEE5FB318462D996A86AB05F9546 |
SSDEEP | 96:RF3/kdhRs2WEEz3MNw46wOM7LDLZfF5wioFwMEqe0j0MDCUx+KMsSu9eZO:RF8d4BEEz3MJPdoOf024 |
TLSH | T19D223197B7D19A3FC8AC5334C0C74334B768A052AA61573B321993787E937A84F962C3 |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/btree_gin.so |
FileSize | 42872 |
MD5 | 0AAFC3083846C093E879CF507FC70780 |
SHA-1 | 0D11C534371041E837649035AA4E4D8143836777 |
SHA-256 | 459DE7549E5C74A219E0A5E6CBD7130C638F6EA3DA59FF18391F6669DFD85408 |
SSDEEP | 768:qjbEgYvoU6Pfj3Gwn65ItazEyJL9WwUKf:+pi+ |
TLSH | T1F9135463759BC23DC1FAC034E6EF56642628BC0836114F3B7A08B37C7F71E54964AAA5 |
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 |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/pg_buffercache.so |
FileSize | 10104 |
MD5 | 9D85E705FA98EB1FFDA572F1AD762081 |
SHA-1 | 102B67E6BF0D5FB0CB0622ACE515FF03670BBC32 |
SHA-256 | 2698F455F7F324734950F03239E20DD45CBA8E12593892BD1E620D3F1A25BA08 |
SSDEEP | 96:RAIjVeo/T4sj9EtkUalaElzgjcIUCh2Vx2v4Npl2OfaXgwI+KUgscmI4sSu9eRm:RAIJVtj9EKTl16zh2Li4Nv2xfxg2I3 |
TLSH | T10222410BB9A4EB3EC46C9734888BC335BAB4A5109511133B3644F63D3ED37986E6359B |
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 |