Re: Restoring database from false update

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Sunday, November 15, 2020, Maksim Fomin <maxim@xxxxxxxxx> wrote:

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Sunday, November 15, 2020 4:32 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Sunday, November 15, 2020, Maksim Fomin <maxim@xxxxxxxxx> wrote:

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Sunday, November 15, 2020 7:27 AM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Sunday, November 15, 2020, Maksim Fomin <maxim@xxxxxxxxx> 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.

How about

\dn

David J.