From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Q: extract database name from directory dump |
Date: | 2016-03-12 21:05:47 |
Message-ID: | 20160312210547.GE1688@hermes.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Mar 12, 2016 at 03:55:32PM -0500, Melvin Davidson wrote:
> hmmm, let's see. You haven't specified PostgreSQL version or O/S as is
> common sense and courtesy, so I will choose one for you.
:-) Sorry. I am on 9.5.1 on Debian 8.0.
OTOH, in the wild it could be any OS and PG 9.1.0 upwards.
And thanks for investing time anyway !
> You are using PostgreSQL version 8.4 on Ubuntu 14.04
> Since pg_dump requires an output file, and the database you are dumping
> must be known, just just the db name in the path.
> eg: pg_dump unknown_db > /dumpdir/unknown_db/whatever_filename_you_want.dmp
Thanks for this suggestion. This option was already
included in the ones I figured out myself :-)
However, I had listed the assumptions about the dump and the
db name being in the dump name wasn't one of them 8-)
Thanks,
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-03-12 21:12:52 | Re: Q: extract database name from directory dump |
Previous Message | Geoff Winkless | 2016-03-12 21:00:04 | Re: index problems (again) |