In the following, the file name is coded: e.g., 06262019h10, where the 06 stands for June, 26 is the day of the month, 2019 is the year, h designates a specific run on that day and 10 indicates the server number. In all my tests I use pgAdmin 4 GUI, selecting YES on options pre-data, data, post-data and verbose messages, all others have NO selected.
One test that I did was using version 11 of the database server but it selected 10. The top line of the message output said “Process Watcher – Restoring backup on the server ‘PostgreSQL 11 (localhost:5433)”, then:
Running command:
/Library/PostgreSQL/10/bin/pg_restore –host “localhost” –port ”5433” –username “postgres” –no-password –dbname “pg2” –section=pre-data –section=data –section=post-data –verbose “/Users/davidelllisrogers/06262019h10”.
Then it gives the start time followed by a one-line message “pg_restore: [archiver]
input file is too short (read 0, expected 5)”
I have checked: there
is a pg_restore in /Library/PostgreSQL/10/bin
and also in /Library/PostgreSQL/11/bin.
How do I force it to use 11? I would like to be up-to-date. Also, on this run, I looked at “/Users/davidellisrogers/06262019h10” and find that it is empty (probably the reason for the
input file is too short).
- Bad news, so a new approach.
I did a little testing on what happens by adding something in a relation and then seeing what effect the addition had on the same database in the other servers.
Note: the database, pg1 exists (is accessible) on all 3 servers.
values in work.wid | | abc | def | ghi |
added that value in database under server | | 9.4 | 10 | 11 |
shows in version number | 9.4 | | YES | NO |
shows in version number | 10 | YES | | NO |
shows in version number | 11 | NO | NO |
Conclusion: the pg_restore on servers 9.4 and 10 are the same (at least for contents of a relation); the one on 11 is not working. – The same holds for deleting a tuple.
I would like to move to server 11 version. I downloaded version 11 again before the above table of tests, thinking I might have had a bad download of 11.
Any suggestions? I am willing to delete 9.4 and 11, remain with 10. I have just backed everything up to an external hard drive.