dumping - Search results in mailing lists

2025-06-07 09:40:02 | How to use cert authentication with pg_dump in windows (Andrus)

dump" --verbose -b -f "test.backup" -F c -h localhost -p 5432 -U varukoopia mydatabase

2025-05-12 17:12:17 | Re: Index not used in certain nested views but not in others (Markus Demleitner)

dumped the minimal number of table definitions involved to https:///tabledefs.txt -- I apologise for the mess

2025-05-01 16:06:22 | Upgrading PG11 to PG17 without dump/restore (Durumdara)

Dump it in the old, restore it in the new and start the work with

2025-04-23 21:46:39 | Dump version issues (Pawel Veselov)

dump because dump version 1.16 is not supported. Both packages are latest from their respective

2025-04-18 21:49:15 | Re: Why is an error not thrown when the time exceeds the lock timeout for (Martin Gainty)

dump the client-side timeout configuration thru Node.js code Node.js client.query(sql, { timeout

2025-04-16 03:24:02 | Re: Fwd: Identify system databases (Adrian Klaver)

dump/restore: CREATE DATABASE test WITH TEMPLATE = template0 ... " It would be possible to do as you say, but then

2025-04-12 08:06:09 | Re: To take backup of Postgresql Database without large objects (sivapostgres@yahoo.com)

dump of version 17 also, with no luck.   [ Database version is 15 and the pg_dump

2025-04-07 22:25:28 | Re: Slow timestamp query after upgrading from Pg13 to Pg16 (Simon Windsor)

dump|pg_restore to migrate the data. The full explain plan is at https:///s/742M.

2025-04-04 16:13:09 | Re: Performance issues during pg_restore -j with big partitioned table (Dimitrios Apostolou)

dump has all that, and the database is brand new and empty. Trying again, pg_restore

2025-03-21 22:00:57 | Re: Experience and feedback on pg_restore --data-only (Ron Johnson)

dump to backup production databases. PgBackRest (the tool I have experience with; there are others

2025-03-21 01:48:11 | Experience and feedback on pg_restore --data-only (Dimitrios Apostolou)

dumped db. AFAICT pg_restore (without --data-only) is optimised for such case. But pg_dump

2025-03-20 19:03:51 | Re: Export operation efficiency in read replica (Laurenz Albe)

dump", right? A dump is always consistent, no matter how long it takes. But if you want

2025-03-19 11:17:06 | Re: Restoring only a subset of schemas (Sylvain Cuaz)

dumping. I make daily full backups and sometimes need to restore a specific day, but the full

2025-03-18 15:49:22 | Re: Cannot pg_dump_all anymore... (Greg Sabino Mullane)

dump and the version of Postgres being dumped. Cheers, Greg -- Crunchy Data - https://www.crunchydata

2025-03-12 23:50:25 | Re: Moving from Linux to Linux? (Ron Johnson)

dump/pg_restore of the dev and pre-prod databases happen on weekends. -- Death to , and butter