Linux websever 5.15.0-153-generic #163-Ubuntu SMP Thu Aug 7 16:37:18 UTC 2025 x86_64
Apache/2.4.52 (Ubuntu)
: 192.168.3.70 | : 192.168.1.99
Cant Read [ /etc/named.conf ]
8.1.2-1ubuntu2.23
urlab
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
usr /
share /
postgresql-common /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
foo
[ DIR ]
drwxr-xr-x
001_packages.t
3.21
KB
-rw-r--r--
002_existing_clusters.t
178
B
-rw-r--r--
005_PgCommon.t
8.13
KB
-rw-r--r--
006_next_free_port.t
1.42
KB
-rw-r--r--
007_pg_conftool.t
2.62
KB
-rw-r--r--
010_defaultport_cluster.t
2.01
KB
-rw-r--r--
012_maintscripts.t
1.08
KB
-rw-r--r--
015_start_stop.t
5.23
KB
-rw-r--r--
020_create_sql_remove.t
21.41
KB
-rw-r--r--
021_pg_renamecluster.t
1.69
KB
-rw-r--r--
022_recovery.t
1.38
KB
-rw-r--r--
025_logging.t
4.64
KB
-rw-r--r--
030_errors.t
15.46
KB
-rw-r--r--
031_errors_disk_full.t
2.42
KB
-rw-r--r--
032_ssl_key_permissions.t
2.19
KB
-rw-r--r--
040_upgrade.t
12.88
KB
-rw-r--r--
041_upgrade_custompaths.t
2.53
KB
-rw-r--r--
043_upgrade_ssl_cert.t
2.84
KB
-rw-r--r--
045_backup.t
6.61
KB
-rw-r--r--
050_encodings.t
5.31
KB
-rw-r--r--
052_upgrade_encodings.t
4.02
KB
-rw-r--r--
060_obsolete_confparams.t
3.2
KB
-rw-r--r--
070_non_postgres_clusters.t
4.2
KB
-rw-r--r--
080_start.conf.t
5.45
KB
-rw-r--r--
085_pg_ctl.conf.t
1.85
KB
-rw-r--r--
090_multicluster.t
13.15
KB
-rw-r--r--
100_upgrade_scripts.t
5.17
KB
-rw-r--r--
110_integrate_cluster.t
1.37
KB
-rw-r--r--
120_pg_upgradecluster_scripts....
4.06
KB
-rw-r--r--
130_nonroot_admin.t
1.75
KB
-rw-r--r--
135_pg_virtualenv.t
1.43
KB
-rw-r--r--
140_pg_config.t
4.36
KB
-rw-r--r--
150_tsearch_stemming.t
4.61
KB
-rw-r--r--
160_alternate_confroot.t
2.03
KB
-rw-r--r--
170_extensions.t
2.95
KB
-rw-r--r--
180_ecpg.t
1.29
KB
-rw-r--r--
190_pg_buildext.t
2.7
KB
-rw-r--r--
TestLib.pm
7.9
KB
-rw-r--r--
template
495
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : 150_tsearch_stemming.t
# Check tsearch, and stemming with dynamic creation of .affix/.dict files use strict; use lib 't'; use TestLib; use PgCommon; my $version = $MAJORS[-1]; use Test::More tests => ($MAJORS[-1] < 8.3 or $PgCommon::rpm) ? 1 : 37; if ($version < 8.3) { pass 'tsearch dictionaries not tested before 8.3'; exit; } if ($PgCommon::rpm) { pass 'tsearch dictionaries not handled by postgresql-common on RedHat'; exit; } # test pg_updatedicts unlink '/var/cache/postgresql/dicts/en_us.affix'; unlink '/var/cache/postgresql/dicts/en_us.dict'; unlink "/usr/share/postgresql/$version/tsearch_data/en_us.affix"; unlink "/usr/share/postgresql/$version/tsearch_data/en_us.dict"; is ((exec_as 0, 'pg_updatedicts'), 0, 'pg_updatedicts succeeded'); ok -f '/var/cache/postgresql/dicts/en_us.affix', 'pg_updatedicts created en_us.affix'; ok -f '/var/cache/postgresql/dicts/en_us.dict', 'pg_updatedicts created en_us.dict'; ok -l "/usr/share/postgresql/$version/tsearch_data/en_us.affix", "pg_updatedicts created $version en_us.affix symlink"; ok -l "/usr/share/postgresql/$version/tsearch_data/en_us.dict", "pg_updatedicts created $version en_us.dict symlink"; # create cluster is ((system "pg_createcluster $version main --start >/dev/null"), 0, "pg_createcluster $version main"); # create DB with en_US text search configuration is_program_out 'postgres', 'createdb fts', 0, ''; my $outref; is ((exec_as 'postgres', 'psql -qd fts -c " CREATE TEXT SEARCH CONFIGURATION public.sc_english ( COPY = pg_catalog.english ); CREATE TEXT SEARCH DICTIONARY english_ispell (TEMPLATE = ispell, DictFile = en_US, AffFile = en_US, StopWords = english); SET default_text_search_config = \'public.sc_english\'; ALTER TEXT SEARCH CONFIGURATION public.sc_english ALTER MAPPING FOR asciiword WITH english_ispell, english_stem;"', $outref), 0, 'creating en_US full text search configuration ' . $$outref); # create test table and index my $outref; is ((exec_as 'postgres', 'psql -qd fts -c " CREATE TABLE stuff (id SERIAL PRIMARY KEY, text TEXT, textsearch tsvector); UPDATE stuff SET textsearch = to_tsvector(\'public.sc_english\', coalesce(text, \'\')); CREATE INDEX textsearch_idx ON stuff USING gin(textsearch); CREATE TRIGGER textsearch_update_trigger BEFORE INSERT OR UPDATE ON stuff FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(textsearch, \'public.sc_english\', text); INSERT INTO stuff (text) VALUES (\'PostgreSQL rocks\'); INSERT INTO stuff (text) VALUES (\'Linux rocks\'); INSERT INTO stuff (text) VALUES (\'I am your father\'\'s nephew\'\'s former roommate\'); INSERT INTO stuff (text) VALUES (\'3 cafés\'); "'), 0, 'creating data table and search index'); # test stemming is_program_out 'postgres', 'psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug(\'public.sc_english\', \'friendliest\')"', 0, "english_ispell|{friendly}\n", 'stem search of correct word'; is_program_out 'postgres', 'psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug(\'public.sc_english\', \'father\'\'s\')"', 0, "english_ispell|{father}\n|\nenglish_ispell|{}\n", 'stem search of correct word'; is_program_out 'postgres', 'psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug(\'public.sc_english\', \'duffles\')"', 0, "english_stem|{duffl}\n", 'stem search of unknown word'; # test searching is_program_out 'postgres', 'psql -Atd fts -c "SELECT text FROM stuff, to_tsquery(\'rocks\') query WHERE query @@ to_tsvector(text)"', 0, "PostgreSQL rocks\nLinux rocks\n", 'full text search, exact word'; is_program_out 'postgres', 'psql -Atd fts -c "SELECT text FROM stuff, to_tsquery(\'rock\') query WHERE query @@ to_tsvector(text)"', 0, "PostgreSQL rocks\nLinux rocks\n", 'full text search for word stem'; is_program_out 'postgres', 'psql -Atd fts -c "SELECT text FROM stuff, to_tsquery(\'roc\') query WHERE query @@ to_tsvector(text)"', 0, '', 'full text search for word substring fails'; is_program_out 'postgres', 'psql -Atd fts -c "SELECT text FROM stuff, to_tsquery(\'cafés\') query WHERE query @@ to_tsvector(text)"', 0, "3 cafés\n", 'full text search, exact unicode word'; is_program_out 'postgres', 'psql -Atd fts -c "SELECT text FROM stuff, to_tsquery(\'café\') query WHERE query @@ to_tsvector(text)"', 0, "3 cafés\n", 'full text search for unicode word stem'; is_program_out 'postgres', 'psql -Atd fts -c "SELECT text FROM stuff, to_tsquery(\'afé\') query WHERE query @@ to_tsvector(text)"', 0, '', 'full text search for unicode word substring fails'; # clean up is ((system "pg_dropcluster $version main --stop"), 0); check_clean; # vim: filetype=perl
Close
