Postgres Pro
Downloads
Home   >   mailing lists

Re: Updating data: confirmation and question - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Updating data: confirmation and question
Date
Msg-id 795309ed-927b-80dd-2db5-2e51c0433934@aklaver.com
Whole thread Raw
In response to Re: Updating data: confirmation and question  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Updating data: confirmation and question
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL - unrecognized win32 error code: 38
Next
From: Yessica Brinkmann
Date:
Subject: Re: I think that my data is saved correctly, but when printing again,other data appears