Re: [Freeze Break Request: ] Switch anitya backups to use --exclude-table-data rather than excluding entire tables

[Mikolaj Izdebski]

+1

On 10/10/2018 02:17 AM, kevin(a)scrye.com wrote:
>  From: Kevin Fenzi <kevin(a)scrye.com&gt;
>  
>  This allows people to use the db dump without having to manually create the missing
> tables.
>  
>  Signed-off-by: Kevin Fenzi <kevin(a)scrye.com&gt;
>  ---
>   roles/postgresql_server/files/backup-database.anitya | 2 +-
>   1 file changed, 1 insertion(+), 1 deletion(-)
>  
>  diff --git a/roles/postgresql_server/files/backup-database.anitya
> b/roles/postgresql_server/files/backup-database.anitya
>  index c28f31b..a2e05a8 100644
>  --- a/roles/postgresql_server/files/backup-database.anitya
>  +++ b/roles/postgresql_server/files/backup-database.anitya
>  @@ -10,7 +10,7 @@ DB=anitya
>   # Make it use a limited number of threads because pxz will use all the
>   # cpus which causes pg_dump to starve which causes...
>   
>  -/usr/bin/pg_dump -T users -T tokens -T 'social*' -T sessions -C $DB |
> /usr/bin/pxz -T4 > /backups/$DB-public-$(date +%F).dump.xz
>  +/usr/bin/pg_dump --exclude-table-data users --exclude-table-data tokens
> --exclude-table-data 'social*' --exclude-table-data sessions -C $DB | /usr/bin/pxz
> -T4 > /backups/$DB-public-$(date +%F).dump.xz
>   
>   # Also, delete the backup from a few days ago.
>   rm -f /backups/$DB-public-$(date --date="1 days ago" +%F).dump.xz
>   
-- 
Mikolaj Izdebski
Senior Software Engineer, Red Hat
IRC: mizdebsk