Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Sabino Mullane
Subject Re: question on plain pg_dump file usage
Date
Msg-id CAKAnmmKkQwOV=hPq3zjZia9kxkjmkvwFt6JbACq4CvSMFt7GMg@mail.gmail.com
Whole thread Raw
In response to question on plain pg_dump file usage  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
List pgsql-general
Tree view
On Tue, Sep 17, 2024 at 8:22 AM Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.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 

pgsql-general by date:

Previous
From: "Zwettler Markus (OIZ)"
Date:
Subject: WG: [Extern] Re: question on plain pg_dump file usage
Next
From: "Zwettler Markus (OIZ)"
Date:
Subject: WG: question on plain pg_dump file usage