Restoring database from false update

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, November 15, 2020 7:27 AM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Sunday, November 15, 2020, Maksim Fomin <maxim(at)fomin(dot)one> wrote:
>
>>> plsql -d tsvt
>> psql (12.5)
>> Type "help" for help.
>>
>> tsvt=# \dt+
>> List of relations
>> Schema | Name | Type | Owner | Size | Description
>> --------+------+-------+----------+---------+-------------
>> public | test | table | postgres | 0 bytes |
>> (1 row)
>>
>> It should have tables 'trade', 'trade4' and some others.
>
> What about?
>
> \l+ (Letter “el”)
>
> David J.

Well, it gives something:

tsvt=# \l+
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description

-----------+----------+----------+-------------+-------------+-----------------------+---------+------------+---------------------------
-----------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 7809 kB | pg_default | default administrative con
nection database
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| 7809 kB | pg_default | unmodifiable empty databas
e
| | | | | postgres=CTc/postgres | | |
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +| 8161 kB | pg_default | default template for new d
atabases
| | | | | postgres=CTc/postgres | | |
tsvt | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | | 8089 MB | pg_default |
(4 rows)

tsvt is needed database and it has 8089 MB which sounds promising.

Best regards,
Maxim Fomin