Re: Restoring database from false update - Mailing list pgsql-general

From David G. Johnston
Subject Re: Restoring database from false update
Date
Msg-id CAKFQuwZ0MC7iotpfz8-1DG-htPRTRpkN9wNFjjoO4nZ=mHkNEg@mail.gmail.com
Whole thread Raw
In response to Restoring database from false update  (Maksim Fomin <maxim@fomin.one>)
Responses Restoring database from false update  (Maksim Fomin <maxim@fomin.one>)
List pgsql-general
On Sunday, November 15, 2020, Maksim Fomin <maxim@fomin.one> wrote:


‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, November 15, 2020 4:32 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

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

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. 

pgsql-general by date:

Previous
From: Maksim Fomin
Date:
Subject: Restoring database from false update
Next
From: Maksim Fomin
Date:
Subject: Restoring database from false update