So the solution to the issue will be
1. Backup a DB using PGDUMP from 1st server.2. Restore the DB in 2nd
server.3. Make required changes in the 2nd server.4. Backup that DB using
PGDUMP from 2nd server.5. Delete / Rename that DB in the 1st server6. Restore
that DB in the 1st server.7. Work again in the 1st server.
Is this the best way to carry out this process?
Happiness AlwaysBKR Sivaprakash
On Friday, 22 January, 2021, 12:40:05 am IST, Ken Tanzer
<[email protected]> wrote:
On Thu, Jan 21, 2021 at 5:52 AM [email protected] <[email protected]>
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 systemBy and for
non-profitshttp://agency-software.org/https://demo.agency-software.org/client
[email protected](253) 245-3801
Subscribe to the mailing list tolearn more about AGENCY orfollow the
discussion.
