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 : 100_upgrade_scripts.t
# Check upgrade scripts use strict; use lib 't'; use TestLib; my @versions = ($MAJORS[-1]); use Test::More tests => 27; use PgCommon; # get_cluster_databases here and indirectly in run-upgrade-scripts is # incompatible with eatmydata, remove it from the environment if ($ENV{LD_PRELOAD} and $ENV{LD_PRELOAD} =~ /eatmydata/) { $ENV{LD_PRELOAD} = join (' ', grep { $_ !~ /eatmydata/ } split (/\s+/, $ENV{LD_PRELOAD})); } my $shellaction = '#!/bin/sh S=`basename $0` SQL="INSERT INTO log VALUES (\'$S $1 $2 $3\')" su -s /bin/sh -c "psql --cluster $1/$2 -c \"$SQL\" db1" postgres '; my %test_sql_scripts = ( 'all_all-sql-db_db.sql' => 'CREATE TABLE dbt(x int)', 'all_all-sql-t1_t1.sql' => 'CREATE TABLE t1t(x int)', 'all_all-sql-t0_t0.sql' => 'CREATE TABLE t0t(x int)', '1_1-sql-db_db.sql' => 'CREATE TABLE v1t(x int)', '2_2-sql-db_db.sql' => 'CREATE TABLE v2t(x int)', 'all_all-sql-cluster_cluster.sql' => 'SELECT datname from pg_databases', 'all_all-sh-db_db.sh' => $shellaction, 'all_all-sh-t1_t1.sh' => $shellaction, 'all_all-sh-t0_t0.sh' => $shellaction, '1_1-sh-db_db.sh' => $shellaction, '2_2-sh-db_db.sh' => $shellaction, 'all_all-sh-cluster_cluster.sh' => $shellaction, 'all_all-shfail-cluster_cluster.sh' => 'echo "all-shfail-cluster:fail"; exit 1', 'all_all-shnoexec-t0_t0.sh' => $shellaction ); # create clusters foreach my $v (@versions) { is ((system "pg_createcluster $v main --start >/dev/null"), 0, "pg_createcluster $v main"); is_program_out 'postgres', "createdb --cluster $v/main db1", 0, ($v < 8.3 ? "CREATE DATABASE\n" : ''); is_program_out 'postgres', "createdb --cluster $v/main db2", 0, ($v < 8.3 ? "CREATE DATABASE\n" : ''); is_program_out 'postgres', "psql -q --cluster $v/main db1 -c 'CREATE TABLE log (str varchar)'", 0, ''; my @dbs = get_cluster_databases $v, 'main'; my @expected = ('template0', 'template1', 'db1', 'db2', 'postgres'); if (eq_set \@dbs, \@expected) { pass 'get_cluster_databases() works'; } else { fail "get_cluster_databases: got '@dbs', expected '@expected'"; } } # create scripts my $scriptdir = '/usr/share/postgresql-common/upgrade-scripts'; ok_dir $scriptdir, ['SPECIFICATION'], "$scriptdir has no scripts (for the test)"; for my $n (keys %test_sql_scripts) { open F, ">$scriptdir/$n" or die "could not create $scriptdir/$n: $!"; print F $test_sql_scripts{$n}; close F; if ($n =~ /\.sh$/ && $n !~ /noexec/) { chmod 0755, "$scriptdir/$n"; } else { chmod 0644, "$scriptdir/$n"; } } # call run-upgrade-scripts my $outref; is ((exec_as 0, '/usr/share/postgresql-common/run-upgrade-scripts 2 2>&1', $outref), 0, 'run-upgrade-scripts succeeds'); is $$outref, "Executing upgrade script 2-sh-db... cluster $versions[0]/main: db1 db2 Executing upgrade script 2-sql-db... cluster $versions[0]/main: db1 db2 Executing upgrade script all-sh-cluster... cluster $versions[0]/main: template1 Executing upgrade script all-sh-db... cluster $versions[0]/main: db1 db2 Executing upgrade script all-sh-t0... cluster $versions[0]/main: db1 db2 template0 template1 Executing upgrade script all-sh-t1... cluster $versions[0]/main: db1 db2 template1 Executing upgrade script all-shfail-cluster... cluster $versions[0]/main: template1[FAIL] all-shfail-cluster:fail Executing upgrade script all-sql-cluster... cluster $versions[0]/main: template1 Executing upgrade script all-sql-db... cluster $versions[0]/main: db1 db2 Executing upgrade script all-sql-t0... cluster $versions[0]/main: db1 db2 template0 template1 Executing upgrade script all-sql-t1... cluster $versions[0]/main: db1 db2 template1 ", 'correct run-upgrade-script output'; # check tables created by SQL scripts foreach my $v (@versions) { is_program_out 'postgres', "psql --cluster $v/main db1 -Atc \"select tablename from pg_tables where schemaname = 'public' order by tablename\"", 0, "dbt\nlog\nt0t\nt1t\nv2t\n", "check SQL scripts results in $v/main db1"; is_program_out 'postgres', "psql --cluster $v/main db2 -Atc \"select tablename from pg_tables where schemaname = 'public' order by tablename\"", 0, "dbt\nt0t\nt1t\nv2t\n", "check SQL scripts results in $v/main db2"; } # check log created by shell scripts foreach my $v (@versions) { is_program_out 'postgres', "psql --cluster $v/main db1 -Atc 'select * from log order by str'", 0, "2_2-sh-db_db.sh $v main db1 2_2-sh-db_db.sh $v main db2 all_all-sh-cluster_cluster.sh $v main template1 all_all-sh-db_db.sh $v main db1 all_all-sh-db_db.sh $v main db2 all_all-sh-t0_t0.sh $v main db1 all_all-sh-t0_t0.sh $v main db2 all_all-sh-t0_t0.sh $v main template0 all_all-sh-t0_t0.sh $v main template1 all_all-sh-t1_t1.sh $v main db1 all_all-sh-t1_t1.sh $v main db2 all_all-sh-t1_t1.sh $v main template1 ", 'check shell scripts results in $v/main'; } # clean up for my $n (keys %test_sql_scripts) { unlink "$scriptdir/$n" or die "could not remove $scriptdir/$n: $!"; } ok_dir $scriptdir, ['SPECIFICATION'], "$scriptdir has no test suite scripts any more"; foreach (@versions) { is ((system "pg_dropcluster $_ main --stop"), 0, "pg_dropcluster $_ main"); } check_clean; # vim: filetype=perl
Close
