Re: question on plain pg_dump file usage

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: question on plain pg_dump file usage
Date: 2024-09-17 13:18:02
Message-ID: CAKAnmmKkQwOV=hPq3zjZia9kxkjmkvwFt6JbACq4CvSMFt7GMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 17, 2024 at 8:22 AM Zwettler Markus (OIZ) <
Markus(dot)Zwettler(at)zuerich(dot)ch> wrote:

> pg_dump -F p -f dump.sql …
>
> sed -i "s/old_name/new_name/g"
>
> psql -f dump.sql …
>

Why not rename afterwards? Just "pg_dump mydb | psql -h newhost -f -" and
rename things via ALTER. Certainly much safer than a global replace via sed.

Cheers,
Greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zwettler Markus (OIZ) 2024-09-17 13:27:42 WG: question on plain pg_dump file usage
Previous Message Zwettler Markus (OIZ) 2024-09-17 13:16:06 WG: [Extern] Re: question on plain pg_dump file usage