search

mkabilov / logical_backup

[WIP] Continuous backup of the tables using PostgreSQL logical replication
MIT License
9 stars 3 forks source link

temp tables #32

Closed mkabilov closed 5 years ago

mkabilov commented 6 years ago

Looks like sometimes we're trying to backup temp tables:

2018/11/07 09:42:10 could not basebackup "public"."pg_temp_180104": could not lock table: could not lock the table: ERROR: relation "public.pg_temp_180104" does not exist (SQLSTATE 42P01)
alexeyklyukin commented 5 years ago

The issue is that we may attempt to backup the table that has been dropped in the database (the actual table here is not a temp one, as it resides in the public namespace); to resolve the issue we can check if the table exists before moving forward with the backup.

alexeyklyukin commented 5 years ago

Solved with https://github.com/ikitiki/logical_backup/commit/c65989a5ccc461722e9e57a962721df5bbb84132