Debian Codegraph @

src/test/recovery/t/034_create_database.pl

raw
1
2 # Copyright (c) 2023-2025, PostgreSQL Global Development Group
3
4 # Test WAL replay for CREATE DATABASE .. STRATEGY WAL_LOG.
5
6 use strict;
7 use warnings FATAL => 'all';
8 use PostgreSQL::Test::Cluster;
9 use PostgreSQL::Test::Utils;
10 use Test::More;
11
12 my $node = PostgreSQL::Test::Cluster->new('node');
13 $node->init;
14 $node->start;
15
16 # This checks that any DDLs run on the template database that modify pg_class
17 # are persisted after creating a database from it using the WAL_LOG strategy,
18 # as a direct copy of the template database's pg_class is used in this case.
19 my $db_template = "template1";
20 my $db_new = "test_db_1";
21
22 # Create table. It should persist on the template database.
23 $node->safe_psql("postgres",
24 "CREATE DATABASE $db_new STRATEGY WAL_LOG TEMPLATE $db_template;");
25
26 $node->safe_psql($db_template, "CREATE TABLE tab_db_after_create_1 (a INT);");
27
28 # Flush the changes affecting the template database, then replay them.
29 $node->safe_psql("postgres", "CHECKPOINT;");
30
31 $node->stop('immediate');
32 $node->start;
33 my $result = $node->safe_psql($db_template,
34 "SELECT count(*) FROM pg_class WHERE relname LIKE 'tab_db_%';");
35 is($result, "1",
36 "check that table exists on template after crash, with checkpoint");
37
38 # The new database should have no tables.
39 $result = $node->safe_psql($db_new,
40 "SELECT count(*) FROM pg_class WHERE relname LIKE 'tab_db_%';");
41 is($result, "0",
42 "check that there are no tables from template on new database after crash"
43 );
44
45 done_testing();