Restoring database from false update

2020-11-15 Thread Maksim Fomin
‐‐‐ Original Message ‐‐‐ On Sunday, November 15, 2020 8:23 PM, David G. Johnston wrote: > On Sunday, November 15, 2020, Maksim Fomin wrote: > >> ‐‐‐ Original Message ‐‐‐ >> On Sunday, November 15, 2020 4:32 PM, David G. Johnston >> wrote: >> &g

Restoring database from false update

2020-11-15 Thread Maksim Fomin
‐‐‐ Original Message ‐‐‐ On Sunday, November 15, 2020 4:32 PM, David G. Johnston wrote: > On Sunday, November 15, 2020, Maksim Fomin wrote: > >> ‐‐‐ Original Message ‐‐‐ >> On Sunday, November 15, 2020 7:27 AM, David G. Johnston >> wrote: >> &g

Restoring database from false update

2020-11-15 Thread Maksim Fomin
‐‐‐ Original Message ‐‐‐ On Sunday, November 15, 2020 7:27 AM, David G. Johnston wrote: > On Sunday, November 15, 2020, Maksim Fomin wrote: > >>> plsql -d tsvt >> psql (12.5) >> Type "help" for help. >> >> tsvt=# \dt+ >> L

Restoring database from false update

2020-11-14 Thread Maksim Fomin
‐‐‐ Original Message ‐‐‐ On Sunday, November 15, 2020 4:47 AM, David G. Johnston wrote: > On Fri, Nov 13, 2020 at 1:56 PM Maksim Fomin wrote: > >> Later, I stopped the service and moved backup folder to the usual place. For >> some reason psql shows that there are

Restoring database from false update

2020-11-13 Thread Maksim Fomin
Hi! Yesterday I updated the version of posgtresql from 12.0 to 12.5-1. Today I found that for some reason (*) there was bug in package update script which caused the postgresql to think that it should be updated from 12 to 13. I followed instructions to update postgresql (**). What I did: 1) co