Re: Upgrading to v12

On 11/11/22 18:41, Brad White wrote:
>  > From your original post, what did "Not the half dozen restored copies"
> mean?
> Over time, we've restored multiple copies for testing and reproducing 
> various issues.
> 
> I'm only trying to set up replication one one of those copies.
> 
>  > In other words define the restore process.
> 
> Command to back up the database:
> "C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe" --host localhost 
> --port 5432 --username "postgres" --no-password  --format custom --blobs 
> --verbose --file "DB_"%datestr%"\DB_"%datestr%.backup "DB"
> 
> Restore:
> $pgdir\pg_restore.exe -h localhost -p 5433 -U postgres --no-password 
> --clean --if-exists --format=custom --dbname="DB_test" 
> "C:\Temp\DB_20220922_2300\DB_20220922_2300.backup"

Alright I am confused. You said you had multiple copies of the database 
on one cluster. The above though shows you restoring to different 
cluster(5433) then the cluster(5432) you dumped from.

Also why

"C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe

vs

$pgdir\pg_restore.exe
?

Is pgdir different from "C:\Program Files\PostgreSQL\9.4\bin\ ?


-- 
Adrian Klaver
adrian.klaver@aklaver.com