Key | Value |
---|---|
FileSize | 551318 |
MD5 | FF2F853F7BD51B932096DD5E92F269E1 |
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 | 1D81AFE846628359680C099DE3BB4AB7B1D51029 |
SHA-256 | 011738B8F0529A61DDA39D0FD680502E2A748CA1D82FB079D18F34F64C750EE3 |
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 |
---|---|
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/auto_explain.so |
FileSize | 12904 |
MD5 | EE19F2C6CBB3B484378082F8898CB091 |
SHA-1 | 14827F2A37FCB979BDA3F3A96179735EE885A64C |
SHA-256 | CE5DF179CBA0EC6B2E69B26AE497A3237B87C0A68C77C43BCAAB34BE1DD0E1FA |
SSDEEP | 96:4iEAyMAlcFglPETEGEzEk+soiNcqcCn4Hz/xwTRAbfLUCuMoT8qpDAtHrs98O2TP:HyM7sEDr0f4T50OLuMQUHrGITU4 |
TLSH | T1AA426266A7420973C42E137286D703AD27BFE98643735B2B635865243DE374E1F163C1 |
Key | Value |
---|---|
CRC32 | 880BC8E2 |
FileName | btree_gist.sql |
FileSize | 31627 |
MD5 | E968CE6165C32CEE0502EC7ED315B231 |
OpSystemCode | 362 |
ProductCode | 183361 |
SHA-1 | 18AD5C02859028D3CCAB47E9D923ABC6AFD414FE |
SHA-256 | 5BF6D091DDF0D0CC6BB93441CB24DCB98D3FE9BFC08B6481FC40E7923F7F9E70 |
SSDEEP | 192:eWMmucE4DtBjstaVnkuHSkpiGJx0urZj6h/OTk8xSjp2AlLdNkJz2AlLdNrrF9:qsk8xSjpdlLdN+zdlLdNX |
SpecialCode | |
TLSH | T1F3E27B3B55B72FC391F68F006E1943612C11211318FA8E941DBAB7B88EDB825C7AD76D |
db | nsrl_modern_rds |
insert-timestamp | 1646987497.6825767 |
source | NSRL |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/sslinfo.so |
FileSize | 15904 |
MD5 | FE75333DCBE09F673C7F58881246D9B1 |
SHA-1 | 190237CC8A01333526141803525E74D997BA92F5 |
SHA-256 | BDA5FF59D59C93C68D4FBD85805843DF15F990DA52F5785CF9A43BC63A71BAFB |
SSDEEP | 192:KNaZoMDvTEqGkG4BMiU7FpC4OX7s1bX49w6AEnwZ/:KGHwfkdButOX7sevFM |
TLSH | T1F7620FB3B252447BC46F237983D75B6C237FE252D3A3531BA32181766DA675A0F162C0 |
Key | Value |
---|---|
FileName | ./usr/lib/postgresql/8.4/lib/lo.so |
FileSize | 8032 |
MD5 | F4CA3918EE1876CCC7C98E29F40423D6 |
SHA-1 | 195655DC2EF419A022EF3A100F9C869554DEB8B4 |
SHA-256 | E386E3A87F55DB64A4BA52C3FBBB9DB8B5FB46F42EF8366E0C2951F3B5969950 |
SSDEEP | 96:sexgnmDEMmEPqcCpj9yDrPgRFaXitaoj9+jwAmTbVkrDoy:9oMmEqpEXPgRFXEO |
TLSH | T19CF10C9AB742DE3BC469233642D76B68337BD660A79B4323536492783F237582F112C6 |