Re: How to get single table data from backup
Andrus <kobruleht2@hot.ee>
From: Andrus <kobruleht2@hot.ee>
To: Christoph Moench-Tegeder <cmt@burggraben.net>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-12-19T21:08:11Z
Lists: pgsql-general
Hi! Geat answer since doesnt require manual sql editing. It worked. Thank you. Andrus. 19.12.2025 19:05 Christoph Moench-Tegeder kirjutas: > ## Andrus (kobruleht2@hot.ee): > >> 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 >