Re: Backing up a DB excluding certain tables
On 4/26/22 12:15 PM, JORGE MALDONADO wrote:
Hi,
I am using *pg_dump* to backup a DB but I would like to exclude some
tables so I added the *-T* switch with a pattern like this: *aspnet*.**.
The backup command includes the *-s* switch to consider the schema only
because I do not need the data. However, even with the *-T* switch, the
tables with the above pattern are created and I also want to exclude
their creation. Is this possible? Or maybe I am not setting the pattern
correctly. This is the command I am issuing:pg_dump -E win1252 -f c:/temp/respaldo.backup -F p -n riopoderoso -h
localhost -p 5432 -U postgres -W -T aspnet*.* -s riopoderoso
Try:
-T 'aspnet*.*'
Per:
https://www.postgresql.org/docs/current/app-pgdump.html
"When using wildcards, be careful to quote the pattern if needed to
prevent the shell from expanding the wildcards; see Examples below."
And Examples is:
https://www.postgresql.org/docs/current/app-pgdump.html#PG-DUMP-EXAMPLES
Respectfully,
Jorge Maldonado
--
Adrian Klaver
adrian.klaver@aklaver.com
Import Notes
Reply to msg id not found: CAAY=A7-=_1xyODtD4QMhZQDek2BqP8krFZ8mAGxStDX_F6_LZA@mail.gmail.comReference msg id not found: CAAY=A7-=_1xyODtD4QMhZQDek2BqP8krFZ8mAGxStDX_F6_LZA@mail.gmail.com
JORGE MALDONADO <jorgemal1960@gmail.com> writes:
I am using *pg_dump* to backup a DB but I would like to exclude some tables
so I added the *-T* switch with a pattern like this: *aspnet*.**. The
backup command includes the *-s* switch to consider the schema only
because I do not need the data. However, even with the *-T* switch, the
tables with the above pattern are created and I also want to exclude their
creation. Is this possible? Or maybe I am not setting the pattern
correctly. This is the command I am issuing:
pg_dump -E win1252 -f c:/temp/respaldo.backup -F p -n riopoderoso -h
localhost -p 5432 -U postgres -W -T aspnet*.* -s riopoderoso
"-n riopoderoso" is already restricting the dump to objects in
schema riopoderoso, so it doesn't look to me like that -T switch
is going to change anything.
I suspect the problem is somewhere else in your process. Maybe
you are restoring the backup into a database that isn't empty,
but already contains the aspnet*.* tables?
regards, tom lane
Import Notes
Reply to msg id not found: CAAY=A7-=_1xyODtD4QMhZQDek2BqP8krFZ8mAGxStDX_F6_LZA@mail.gmail.comReference msg id not found: CAAY=A7-=_1xyODtD4QMhZQDek2BqP8krFZ8mAGxStDX_F6_LZA@mail.gmail.com | Resolved by subject fallback