Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Would you add a --dry-run to pg_restore? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: [GENERAL] Would you add a --dry-run to pg_restore?
Date
Msg-id 20170802183942.nryqcghj2f4trccu@hermes.hilbert.loc
Whole thread Raw
In response to Re: [GENERAL] Would you add a --dry-run to pg_restore?  (Edmundo Robles <edmundo@sw-argos.com>)
List pgsql-general
Tree view 
On Wed, Aug 02, 2017 at 12:10:37PM -0500, Edmundo Robles wrote:

> I  imagine   pg_restore can  execute  the instructions on dump but  don't
>  write on disk.   just like David said: "tell me what is going to happen
> but don't actually do it"

In fact, this already exists:

    pg_restore --file=commands.sql your-backup

Then read commands.sql.

It will tell you what is going to happen but not actually do it.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Pankaj Arora
Date:
Subject: [GENERAL] PostgreSQL 9.3 Uninstall error - Windows 2012
Next
From: John McKown
Date:
Subject: Re: [GENERAL] bidirectional mapping?