Re: Q: extract database name from directory dump

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Q: extract database name from directory dump
Date: 2016-03-12 20:55:32
Message-ID: CANu8FizFs954oSf1xUdTu_94EwBreXH7esUkJDFY=5eHx_cRcQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

Then you can get the db name by lookiing at the directory you dumped to! At
least that is what most dba's would do.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2016-03-12 20:59:08 Re: Q: extract database name from directory dump
Previous Message Karsten Hilbert 2016-03-12 20:38:13 Re: Q: extract database name from directory dump