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 : 045_backup.t
use strict; use lib 't'; use TestLib; use PgCommon; use Test::More; use Time::HiRes qw/usleep/; my ($pg_uid, $pg_gid) = (getpwnam 'postgres')[2,3]; my $systemd = (-d "/run/systemd/system" and not $ENV{_SYSTEMCTL_SKIP_REDIRECT}); note $systemd ? "We are running systemd" : "We are not running systemd"; foreach my $v (@MAJORS) { if ($v < 9.1) { ok 1, "pg_backupcluster not supported on $v"; next; } note "PostgreSQL $v"; note "create cluster"; program_ok 0, "pg_createcluster --locale en_US.UTF-8 $v main --start"; like_program_out 0, "pg_lsclusters -h", 0, qr/$v main 5432 online/; program_ok 0, "pg_conftool $v main set work_mem 11MB"; if ($v <= 9.6) { open my $hba, ">>", "/etc/postgresql/$v/main/pg_hba.conf"; print $hba "local replication all peer\n"; close $hba; program_ok 0, "pg_conftool $v main set max_wal_senders 10"; program_ok 0, "pg_conftool $v main set wal_level archive"; program_ok 0, "pg_conftool $v main set max_replication_slots 10" if ($v >= 9.4); program_ok 0, "pg_conftool $v main set ssl off" if ($v <= 9.1); # cert symlinks not backed up in 9.1 program_ok 0, "pg_ctlcluster $v main restart"; } program_ok $pg_uid, "createdb -E SQL_ASCII -T template0 mydb"; program_ok $pg_uid, "psql -c 'alter database mydb set search_path=public'"; program_ok $pg_uid, "psql -c 'create table foo (t text)' mydb"; program_ok $pg_uid, "psql -c \"insert into foo values ('important data')\" mydb"; program_ok $pg_uid, "psql -c 'CREATE USER myuser'"; program_ok $pg_uid, "psql -c 'alter role myuser set search_path=public, myschema'"; SKIP: { # in PG 10, ARID is part of globals.sql which we try to restore before databases.sql skip "alter role in database handling in PG <= 10 not supported", 1 if ($v <= 10); program_ok $pg_uid, "psql -c 'alter role myuser in database mydb set search_path=public, myotherschema'"; } note "create directory"; program_ok 0, "pg_backupcluster $v main createdirectory"; my $dir = "/var/backups/postgresql/$v-main"; my @stat = stat $dir; is $stat[4], $pg_uid, "$dir owned by uid postgres"; is $stat[5], $pg_gid, "$dir owned by gid postgres"; my @backups = (); my $dump = ''; SKIP: { skip "dump not supported before 9.3", 1 if ($v < 9.3); note "dump"; if ($systemd) { program_ok 0, "systemctl start pg_dump\@$v-main"; } else { program_ok 0, "pg_backupcluster $v main dump"; } ($dump) = glob "$dir/*.dump"; ok -d $dump, "dump created in $dump"; @stat = stat $dump; is $stat[4], $pg_uid, "$dump owned by uid postgres"; is $stat[5], $pg_gid, "$dump owned by gid postgres"; push @backups, $dump; } note "basebackup"; my $receivewal_pid; if ($v >= 9.5) { if ($systemd) { program_ok 0, "systemctl start pg_receivewal\@$v-main"; } else { $receivewal_pid = fork; if ($receivewal_pid == 0) { exec "pg_backupcluster $v main receivewal"; } } } if ($systemd) { program_ok 0, "systemctl start pg_basebackup\@$v-main"; } else { program_ok 0, "pg_backupcluster $v main basebackup"; } my ($basebackup) = glob "$dir/*.backup"; ok -d $basebackup, "dump created in $basebackup"; @stat = stat $basebackup; is $stat[4], $pg_uid, "$basebackup owned by uid postgres"; is $stat[5], $pg_gid, "$basebackup owned by gid postgres"; push @backups, $basebackup; note "list"; like_program_out 0, "pg_backupcluster $v main list", 0, qr/$dump.*$basebackup/s; note "more database changes"; program_ok $pg_uid, "psql -c \"insert into foo values ('some other data')\" mydb"; program_ok $pg_uid, "psql -c \"insert into foo values ('yet more data')\" mydb"; my $timestamp = `su -c "psql -XAtc 'select now()'" postgres`; ok $timestamp, "retrieve recovery timestamp"; program_ok $pg_uid, "psql -c \"delete from foo where t = 'some other data'\" mydb"; usleep($delay); if ($v >= 9.5) { if ($systemd) { program_ok 0, "systemctl stop pg_receivewal\@$v-main"; } else { is kill('TERM', $receivewal_pid), 1, "stop receivewal"; } } for my $backup (@backups) { note "restore $backup"; program_ok 0, "pg_dropcluster $v main --stop"; program_ok 0, "pg_restorecluster $v main $backup --start --datadir /var/lib/postgresql/$v/snowflake"; like_program_out 0, "pg_lsclusters -h", 0, qr/$v main 5432 online postgres .var.lib.postgresql.$v.snowflake/; is_program_out $pg_uid, "psql -XAtl", 0, "mydb|postgres|SQL_ASCII|en_US.UTF-8|en_US.UTF-8| postgres|postgres|UTF8|en_US.UTF-8|en_US.UTF-8| template0|postgres|UTF8|en_US.UTF-8|en_US.UTF-8|=c/postgres postgres=CTc/postgres template1|postgres|UTF8|en_US.UTF-8|en_US.UTF-8|=c/postgres postgres=CTc/postgres\n"; is_program_out $pg_uid, "psql -XAtc 'show work_mem'", 0, "11MB\n"; is_program_out $pg_uid, "psql -XAtc 'select * from foo' mydb", 0, "important data\n"; is_program_out $pg_uid, "psql -XAtc \"select analyze_count from pg_stat_user_tables where relname = 'foo'\" mydb", 0, ($v >= 9.4 ? "3\n" : "1\n"); # --analyze-in-stages does 3 passes SKIP: { skip "alter role in database handling in PG <= 10 not supported", 1 if ($v <= 10); is_program_out $pg_uid, "psql -XAtc '\\drds'", 0, "myuser|mydb|search_path=public, myotherschema myuser||search_path=public, myschema |mydb|search_path=public\n"; } } if ($v >= 9.5) { note "restore $basebackup with WAL archive"; program_ok 0, "pg_dropcluster $v main --stop"; program_ok 0, "pg_restorecluster $v main $basebackup --start --archive --port 5430"; like_program_out 0, "pg_lsclusters -h", 0, qr/$v main 5430 online postgres .var.lib.postgresql.$v.main/; is_program_out $pg_uid, "psql -XAtc 'select * from foo order by t' mydb", 0, "important data\nyet more data\n"; note "restore $basebackup with PITR"; program_ok 0, "pg_dropcluster $v main --stop"; program_ok 0, "pg_restorecluster $v main $basebackup --start --pitr '$timestamp'"; like_program_out 0, "pg_lsclusters -h", 0, qr/$v main 5432 online postgres .var.lib.postgresql.$v.main/; is_program_out $pg_uid, "psql -XAtc 'select * from foo order by t' mydb", 0, "important data\nsome other data\nyet more data\n"; } program_ok 0, "pg_dropcluster $v main --stop"; check_clean; } # foreach version done_testing(); # vim: filetype=perl
Close
