Re: Updating data: confirmation and question

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 10/26/19 10:39 AM, Rich Shepard wrote:
> On Sat, 26 Oct 2019, Adrian Klaver wrote:
>
> > That depends on how you ran pg_dumpall. For instance did you use -c?:
>
> Adrian,
>
> Yes. Always.

Then the question is, do you really want to overwrite the new database?

> > https://www.postgresql.org/docs/11/sql-alterdatabase.html
> > ALTER DATABASE name RENAME TO new_name
>
> Ah, I should have looked. I apologize.
>
> Rich


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx