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: >> >>> On Sunday, November 15, 2020, M

Re: Restoring database from false update

2020-11-15 Thread David G. Johnston
On Sunday, November 15, 2020, Maksim Fomin wrote: > > > ‐‐‐ Original Message ‐‐‐ > On Sunday, November 15, 2020 4:32 PM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > > On Sunday, November 15, 2020, Maksim Fomin wrote: > >> ‐‐‐ Original Message ‐‐‐ >> On Sunday, Nove

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: >> >>> On Sunday, November 15, 2020, M

Re: Restoring database from false update

2020-11-15 Thread David G. Johnston
On Sunday, November 15, 2020, Maksim Fomin wrote: > ‐‐‐ Original Message ‐‐‐ > On Sunday, November 15, 2020 7:27 AM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > > On Sunday, November 15, 2020, Maksim Fomin wrote: > >> >> > plsql -d tsvt >> psql (12.5) >> Type "help" for he

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+ >> List of relations >> Schema | Name | Type | Owner | Size | Descrip

Re: Restoring database from false update

2020-11-14 Thread David G. Johnston
On Sunday, November 15, 2020, Maksim Fomin wrote: > > > plsql -d tsvt > psql (12.5) > Type "help" for help. > > tsvt=# \dt+ > List of relations > Schema | Name | Type | Owner | Size | Description > +--+---+--+-+- > public | te

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 no relations found in

Re: Restoring database from false update

2020-11-14 Thread David G. Johnston
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 no relations found in the > database, although the database is listed. My next step was to copy data > from file-system level

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