Restoring database from false update

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, November 15, 2020 4:32 PM, 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:
>
>> ‐‐‐‐‐‐‐ 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.
>
> Show search_path;
>
> ?
>
> David J.

It has:
tsvt=# Show search_path;
search_path
-----------------
"$user", public
(1 row)

'user' is literally the name of the current linux user.

Best regards,
Maxim Fomin