| Key | Value |
|---|---|
| FileSize | 572792 |
| MD5 | CF8FD4DA8FDD283B08C8CDC2E01F8664 |
| 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.3. 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 intarray - Index support for arrays of int4, using GiST 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.3 |
| PackageSection | misc |
| PackageVersion | 8.3.3-1~gutsy1 |
| SHA-1 | BC9169E8F2905FBE5AE3C82E0E0402BAD39D084D |
| SHA-256 | D5A367527779866BCC1DAD5679AC8D771CE73E6A6941E37F3B12AAE3346B1EA8 |
| hashlookup:children-total | 109 |
| hashlookup:trust | 50 |
The searched file hash includes 109 children files known and seen by metalookup. A sample is included below:
| Key | Value |
|---|---|
| FileName | ./usr/lib/postgresql/8.3/lib/fuzzystrmatch.so |
| FileSize | 23408 |
| MD5 | 69B10987DC6E57FC52F4237E181142DD |
| SHA-1 | 00C3DA2499763B2CCF6B05B3F2FD05F3C2D15018 |
| SHA-256 | 0471531CF51639F3DB0CA13C6C91F04B4D698D70759E3D1CA97B0A4C4CBAF53A |
| SSDEEP | 384:0kL7e8phZ1F1rLfcRPa862pn8Ynwns/1o++DnKatJgaDpgY:jSotkRP962p8Ynes/XatKUgY |
| TLSH | T1A8B2D779FB4414BDC8768631C9FF22232AF0F825052676BF2210AF39BF26544965BC97 |
| Key | Value |
|---|---|
| FileName | ./usr/share/pgsql/contrib/pg_freespacemap.sql |
| FileSize | 1267 |
| MD5 | 8AF027F146D26AF2ABC82C81C9CE1EE7 |
| SHA-1 | 03A9032C654350AC1A52926641C77C20043FF7EE |
| SHA-256 | 08853C33386FD67F5A5971AD3E7A5E5D2C5AB74417AC05A07650F0D006275BA9 |
| SSDEEP | 24:+c1btCSNmXM1GpcHNpvOcgHcXFmwa9c7gF0zXwBu0fX6H:d/gMZ7OcgHcXFmwa9c7gFOmX6H |
| TLSH | T151219DA61DBC164E2936FD53BD0B2938D631849D4C21E8B52E30E538809ED018B1B82B |
| nsrl-sha256 | rds241-sha256.zip |
| tar:gname | wheel |
| tar:uname | root |
| Key | Value |
|---|---|
| FileName | uninstall__btree_gistscr |
| FileSize | 7474 |
| MD5 | 945A75914FF6759769BCA9E464510176 |
| RDS:package_id | 278275 |
| SHA-1 | 07CBAAD999371F18DF8D5DE605B169AA98AB88F9 |
| SHA-256 | D87DAD69BD3EFA3308BBBB2FE4370D08192811B8BA5FBF537B87B3686CD5E58B |
| SSDEEP | 96:e1gZZjuOlrHrAx3rvZiTkE743L8t9dFde:59rHrAxL |
| TLSH | T165F1023B20F76EAAC6B5B790CF6492023555241370F7CA5009BCBABC85D3815D7BA76C |
| insert-timestamp | 1662197471.254384 |
| nsrl-sha256 | rds241-sha256.zip |
| source | delta.db |
| tar:gname | wheel |
| tar:uname | root |
| Key | Value |
|---|---|
| FileName | ./usr/lib/postgresql/8.3/lib/earthdistance.so |
| FileSize | 5232 |
| MD5 | E2E2623ADF3A60FC0EFF1D8ECAFDE695 |
| SHA-1 | 0984B1F248F7A56532A5BB4AF61731E6184AECB9 |
| SHA-256 | 2E91F2898CE8D0EB2CD4E922092E97DF688F264AFD24451AC37F054C5D320FF5 |
| SSDEEP | 48:RgsKdEcGhqgevBx8iYZkqM9UGxuKZAOasjmAbgY+zI+auMa:RgsKdE3hqdHv9Af6WzI+auMa |
| TLSH | T1BBB1115AFFA4DB3AD83C033824A7437576B0A889461993273388F2793D677D40A13196 |
| Key | Value |
|---|---|
| FileName | uninstall_pg_trgmscr |
| FileSize | 1033 |
| MD5 | 2080863AEA67BD18CFCD2E58B9142B6C |
| RDS:package_id | 278275 |
| SHA-1 | 0C4797C7E845645EE8B9850FA522FFF81B7424E6 |
| SHA-256 | 81596B2BAE113CDA83C6714FF26CE0AB9E6776B2BCFEE9AF09FEE928AA272258 |
| SSDEEP | 24:+/TtCQggoRgRvP4H36VZvLvFGpRpuIAdhlCtnv:655gj536V1TMmhle |
| TLSH | T1DE11E93E20F76AB5C974F230EE3525011E12109BB05BC651049E7AF660D79C9C3AFB18 |
| insert-timestamp | 1662197472.2608736 |
| nsrl-sha256 | rds241-sha256.zip |
| source | delta.db |
| tar:gname | wheel |
| tar:uname | root |
| Key | Value |
|---|---|
| FileName | uninstall__intscr |
| FileSize | 2767 |
| MD5 | D7F7C391C85768901CC2466DD3A732FA |
| RDS:package_id | 278275 |
| SHA-1 | 0CF323F48A810DBD28C9D93A97B46A14A759C481 |
| SHA-256 | 0065E624A9B9933CA4B2DAEB581030A75BCA44C3C58620BE03AD2B9832D5CDC5 |
| SSDEEP | 48:fE2sV5tQVyjRjXjPjqjOj/jr/b36Qw6HXPqO/BbYOsWMOdOsmOsWWJxO8Osck2ov:M2syVyjRjXjPjqjOj/jreQNXPqO/RxsJ |
| TLSH | T1C251213EA0B32DBBC4B8F9208F356211255518A3F4DEAE540B9CBA7C55D2C19C3B6E16 |
| insert-timestamp | 1662197471.676447 |
| nsrl-sha256 | rds241-sha256.zip |
| source | delta.db |
| tar:gname | wheel |
| tar:uname | root |
| 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.3/lib/seg.so |
| FileSize | 27592 |
| MD5 | 34AEA00506E59558FD53158FF90177D3 |
| SHA-1 | 1D4FAF429261B6E7813AB180907D07C226F93776 |
| SHA-256 | F3DE0545862D88F800EAB64838FBE0CDD6F7237B9EEBAE2BE7DB19981A94DCCC |
| SSDEEP | 384:qi8EBaRXNGP4DgSbMLEYCUtbtfZ6EUI3W1QMU2WMI:qi8EBQ4P4xbMI3UgNI3W1Ql |
| TLSH | T169C2F743F346D53BC08A433149DBE36512B0F4446B39AB2F3044F6BCBEA1A97CA5A5D6 |