Re: Copy & Re-copy of DB

[Ken Tanzer <ken.tanzer@xxxxxxxxx>]

On Thu, Jan 21, 2021 at 5:52 AM sivapostgres@xxxxxxxxx <sivapostgres@xxxxxxxxx> wrote:

create database is to create a new database.  If we switch to new database, we need to change the new databasename in the program(s) that access this database.  

If you are just concerned about having the same database name, what about renaming (ALTER DATABASE ... RENAME TO) the old and/or new databases so they end up the way you want?

Cheers,
Ken

--

AGENCY Software  

A Free Software data system

By and for non-profits

http://agency-software.org/

https://demo.agency-software.org/client

ken.tanzer@xxxxxxxxxxxxxxxxxxx

(253) 245-3801

Subscribe to the mailing list to

learn more about AGENCY or

follow the discussion.