Re: question on plain pg_dump file usage - Mailing list pgsql-general

From Adrian Klaver
Subject Re: question on plain pg_dump file usage
Date
Msg-id f95ec190-d282-485d-89a6-550e34ba1a03@aklaver.com
Whole thread Raw
In response to Re: question on plain pg_dump file usage  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general
On 9/17/24 05:43, Ron Johnson wrote:
> On Tue, Sep 17, 2024 at 8:22 AM Zwettler Markus (OIZ) 
> <Markus.Zwettler@zuerich.ch <mailto:Markus.Zwettler@zuerich.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.klaver@aklaver.com




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: question on plain pg_dump file usage
Next
From: Adrian Klaver
Date:
Subject: Re: load fom csv