Restoring database from false update

Поиск
Список
Период
Сортировка
От Maksim Fomin
Тема Restoring database from false update
Дата
Msg-id QXWO2yIQr-clEIYM-VIlY8yRd_amb0fcxNdcjlRc4BhpSyMAUDpBTbbw1H40PpOIcGRTP4FdGKD82CM1cS3v_hYwl0AQ-4D6IUuSGFzzQGo=@fomin.one
обсуждение исходный текст
Ответ на Re: Restoring database from false update  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Restoring database from false update
Список pgsql-general
Дерево обсуждения
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, November 15, 2020 7:27 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:

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

В списке pgsql-general по дате отправления: