| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Backing up a DB excluding certain tables |
| Date: | 2022-05-04 17:27:06 |
| Message-ID: | CA+bJJbzcG9XfBYNcPccn3KJkeUTW3WdrMUuBYYimiW3EGzCMoA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Replying to self...
On Wed, 4 May 2022 at 19:19, Francisco Olarte <folarte(at)peoplecall(dot)com> wrote:
> An I remember pg_dump had a catalog mode, but it seems to have
> dissapeared in recent versions ( you gave it a switch, it wrote a
> commented list
> of IDs which you could edit ( normally avoiding reorders ) and feed
> back with another switch to make partial backups, it was really useful
> for selective
> backups of complex stuff ).
Got it wrong, after consulting some old notes it is pg_restore which
has the -l/-L switches, what we did, was full-dump a db for upgrading,
write TOC, edit TOC to restore only schema on some tables, restore it
faster, go live, then use rest of the TOC to restore the missing
tables ( they where huge logs, just affected reports which could wait
).
Francisco Olarte.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2022-05-04 17:44:32 | Re: Displaying chat by punished users only to themselves (db fiddle attached) |
| Previous Message | Alexander Farber | 2022-05-04 17:23:18 | Re: Displaying chat by punished users only to themselves (db fiddle attached) |