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

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

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

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