Re: How to get single table data from backup

2025-12-19 Thread Christoph Moench-Tegeder
## Andrus ([email protected]): > This fails since tabletorecover contains lot foreign key references. Check pg_restore options "--section=pre-data" and "--section=data" - pre-data is the schema without indexes, contraints, etc. (those would be in section post-data). Regards, Christoph -- Spare

Re: How to get single table data from backup

2025-12-19 Thread Adrian Klaver
On 12/19/25 08:12, Adrian Klaver wrote: On 12/19/25 04:41, Andrus wrote: Hi! Large database backup is created using pg_dump -b -f backup.backup -F c How to restore single table in schema firma2 from it in Windows? Created database recovery and tried pg_restore --schema-only --n firma2 -d re

Re: How to get single table data from backup

2025-12-19 Thread Ray O'Donnell
On 19/12/2025 12:41, Andrus wrote: Hi! Large database backup is created using pg_dump -b -f backup.backup -F c How to restore single table in schema firma2 from it in Windows? Created database recovery and tried pg_restore --schema-only --n firma2 -d recovery backup.backup pg_restore -n fir

Re: How to get single table data from backup

2025-12-19 Thread Adrian Klaver
On 12/19/25 04:41, Andrus wrote: Hi! Large database backup is created using pg_dump -b -f backup.backup -F c How to restore single table in schema firma2 from it in Windows? Created database recovery and tried pg_restore --schema-only --n firma2 -d recovery backup.backup pg_restore -n firma2