Postgres Pro
Downloads
Home   >   mailing lists

Re: Q: extract database name from directory dump - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Q: extract database name from directory dump
Date
Msg-id 20160312203813.GC1688@hermes.hilbert.loc
Whole thread Raw
In response to Q: extract database name from directory dump  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: Q: extract database name from directory dump  (Melvin Davidson <melvin6925@gmail.com>)
Re: Q: extract database name from directory dump  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
On Sat, Mar 12, 2016 at 09:33:33PM +0100, Karsten Hilbert wrote:

> Not-so-nice solutions coming to mind:
>
> - rely on the dump file name
> - use pg_restore to create an SQL dump
>   with --create and grep the SQL file
>   for "create database ..."
> - restore and compare psql -l output
>   before/after the fact

I _have_ tried

    pg_filedump toc.dat

to no avail.

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: Karsten Hilbert
Date:
Subject: Q: extract database name from directory dump
Next
From: Melvin Davidson
Date:
Subject: Re: Q: extract database name from directory dump