Re: question on plain pg_dump file usage

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: question on plain pg_dump file usage
Date: 2024-09-17 15:01:32
Message-ID: f95ec190-d282-485d-89a6-550e34ba1a03@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/17/24 05:43, Ron Johnson wrote:
> On Tue, Sep 17, 2024 at 8:22 AM Zwettler Markus (OIZ)
> <Markus(dot)Zwettler(at)zuerich(dot)ch <mailto:Markus(dot)Zwettler(at)zuerich(dot)ch>> wrote:

>
>
> Why must it be a plain text dump instead of a custom or directory dump?
> Restoring to a new (and differently-named( database is perfectly doable.

Because of this:

sed -i "s/old_name/new_name/g"

>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> crustacean!

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Hartman 2024-09-17 15:13:02 Re: load fom csv
Previous Message Tom Lane 2024-09-17 14:02:34 Re: question on plain pg_dump file usage