Re: Postgresql 17 incremental backup - Mailing list pgsql-admin
| From | Mauricio Fernandez |
|---|---|
| Subject | Re: Postgresql 17 incremental backup |
| Date | |
| Msg-id | CAMdfv4Ut6o=BBMCz=B8D_oUai9rFhurBxfKrDccG+Dp_zDAe_A@mail.gmail.com Whole thread Raw |
| In response to | Re: Postgresql 17 incremental backup (Guillaume Lelarge <guillaume@lelarge.info>) |
| Responses |
Re: Postgresql 17 incremental backup
|
| List | pgsql-admin |
I really did what you implied, but I tried copy/paste your example and it's show me another error, about an directory not empty.
Then I remember some troubles trying to make a base backup because I have two extra tablespace, and this works fine
[postgres@buda viernes]$ pg_basebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes --incremental /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest \
> --tablespace-mapping=/var/lib/pgsql/datos/17/tbs_laboratorio_02=$PGBKP/fisicos/viernes/tbs_laboratorio_02 \
> --tablespace-mapping=/var/lib/pgsql/datos/17/tbs_recetas=$PGBKP/fisicos/viernes/tbs_recetas
13685/3975886 kB (0%), 3/3 tablespaces
[postgres@buda viernes]$
> --tablespace-mapping=/var/lib/pgsql/datos/17/tbs_laboratorio_02=$PGBKP/fisicos/viernes/tbs_laboratorio_02 \
> --tablespace-mapping=/var/lib/pgsql/datos/17/tbs_recetas=$PGBKP/fisicos/viernes/tbs_recetas
13685/3975886 kB (0%), 3/3 tablespaces
[postgres@buda viernes]$
Always the problem was a misleading character in the "--" like you said. Too much copy/paste I think
Thank you very much for your help
Kind regards
MF
El lun, 6 ene 2025 a las 17:10, Guillaume Lelarge (<guillaume@lelarge.info>) escribió:
Have you read what I said inline? Doesn't look like you did, so I'll copy it here:I've tried your command line, and I have the same error. The minus sign is not the good one. Try (by copy/paste):pg_basebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes --incremental /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifestLe lun. 6 janv. 2025 à 21:07, Mauricio Fernandez <mmauricio.fernandez@gmail.com> a écrit :Ups, thanks for the warningHi Guillaume, thanks for the answer.I've tried with -i and --incremental , and the results are the same. In both cases without "="[postgres@buda viernes]$ pg_basebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes –-incremental /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifestpg_basebackup: error: demasiados argumentos en la línea de órdenes (el primero es «–-incremental»)
pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor información.
[postgres@buda viernes]$ pg_basebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes –i /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
pg_basebackup: error: demasiados argumentos en la línea de órdenes (el primero es «–i»)
pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor información.regardsMFEl lun, 6 ene 2025 a las 17:01, Guillaume Lelarge (<guillaume@lelarge.info>) escribió:Hi,Reply to the list, not only to me.Le lun. 6 janv. 2025 à 20:52, Mauricio Fernandez <mmauricio.fernandez@gmail.com> a écrit :Hi Guillaume, thanks for the answer.I've tried with -i and --incremental , and the results are the same. In both cases without "="[postgres@buda viernes]$ pg_basebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes –-incremental /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifestpg_basebackup: error: demasiados argumentos en la línea de órdenes (el primero es «–-incremental»)
pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor información.
[postgres@buda viernes]$ pg_basebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes –i /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
pg_basebackup: error: demasiados argumentos en la línea de órdenes (el primero es «–i»)
pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor información.I've tried your command line, and I have the same error. The minus sign is not the good one. Try:pg_basebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes --incremental /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifestregardsMFEl lun, 6 ene 2025 a las 16:42, Guillaume Lelarge (<guillaume@lelarge.info>) escribió:Hi,Le lun. 6 janv. 2025 à 20:23, Mauricio Fernandez <mmauricio.fernandez@gmail.com> a écrit :Hi admins, I'm trying to execute an incremental backup and I'm getting the following error[postgres@buda ~]$ pg_basebackup -c fast -P -D $PGBKP/fisicos/viernes –-incremental=$PGBKP/fisicos/base_plano/backup_manifestpg_basebackup: error: demasiados argumentos en la línea de órdenes (el primero es «–-incremental=/var/lib/pgsql/17/backups/devadv01/fisicos/base_tar/backup_manifest»)
pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor información.The literal translation of the error message is: pg_basebackup: error: too many arguments in the command line (the first is «–-incremental=/var/lib/pgsql/17/backups/devadv01/fisicos/base_tar/backup_manifest»)It looks like it thinks that "--incremental=/var/lib/pgsql/17/backups/devadv01/fisicos/base_tar/backup_manifest" is one argument rather than an argument and its value. Try getting rid of the equal value. Maybe it will help.--Guillaume.
--Guillaume.
--Guillaume.
pgsql-admin by date: