diff options
| author | Michael Paquier <michael@paquier.xyz> | 2023-01-26 09:13:39 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2023-01-26 09:13:39 +0900 |
| commit | 9aeff092c05820d6a9252d7a3f8db86f71f2205f (patch) | |
| tree | 4a43fc073329e117f5e2391575202b3633ab5cad /contrib/basic_archive/sql | |
| parent | 1a8e72bff781e869e5b5dc76fa18e3ae08181656 (diff) | |
| download | postgresql-9aeff092c05820d6a9252d7a3f8db86f71f2205f.tar.gz | |
Revert "Rename contrib module basic_archive to basic_wal_module"
This reverts commit 0ad3c60, as per feedback from Tom Lane, Robert Haas
and Andres Freund. The new name used for the module had little
support.
This moves back to basic_archive as module name, and we will likely use
that as template for recovery modules, as well.
Discussion: https://postgr.es/m/CA+TgmoYG5uGOp7DGFT5gzC1kKFWGjkLSj_wOQxGhfMcvVEiKGA@mail.gmail.com
Diffstat (limited to 'contrib/basic_archive/sql')
| -rw-r--r-- | contrib/basic_archive/sql/basic_archive.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/contrib/basic_archive/sql/basic_archive.sql b/contrib/basic_archive/sql/basic_archive.sql new file mode 100644 index 0000000000..14e236d57a --- /dev/null +++ b/contrib/basic_archive/sql/basic_archive.sql @@ -0,0 +1,22 @@ +CREATE TABLE test (a INT); +SELECT 1 FROM pg_switch_wal(); + +DO $$ +DECLARE + archived bool; + loops int := 0; +BEGIN + LOOP + archived := count(*) > 0 FROM pg_ls_dir('.', false, false) a + WHERE a ~ '^[0-9A-F]{24}$'; + IF archived OR loops > 120 * 10 THEN EXIT; END IF; + PERFORM pg_sleep(0.1); + loops := loops + 1; + END LOOP; +END +$$; + +SELECT count(*) > 0 FROM pg_ls_dir('.', false, false) a + WHERE a ~ '^[0-9A-F]{24}$'; + +DROP TABLE test; |