Re: Updating data: confirmation and question

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@aklaver.com