Subject: Re: Lost my tablespace
To: tel medola <tel.medola@gmail.com>
Cc: pgsql-sql@postgresql.org
References: 
 <CANRMYmgu3ddSU62-=a3QCnsbGYuMVJXZ-ydTm7vd_2TQLp-Oqg@mail.gmail.com>
 <2a418dab-d17f-9d3a-0ac4-53678c1ce16f@aklaver.com>
 <CANRMYmjbg6MFhB=3wo6tcueUL8mqmqRfysSYrgRFHUu04Mxrwg@mail.gmail.com>
 <97bd2743-46c3-32c4-7b3f-62def38aea65@aklaver.com>
 <CANRMYmhxARYp73boRCfHB5VHDFT+wM5G=kTGrCQcN0Ds=uxLWw@mail.gmail.com>
 <a9063a7d-ac70-abb8-38f4-6ef49bf401f3@aklaver.com>
 <CANRMYmjc7nc0GpxCkxApQTgAr+9YGooUvA8AEU_9SjjBJb+qqg@mail.gmail.com>
 <32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com>
 <CANRMYmgw9+vreD0+43vGK+JYyshMaea=zedwc1ufYS_cBEj5VA@mail.gmail.com>
 <a18d2b5a-255f-e5b5-0c4d-686eb182e88e@aklaver.com>
 <CANRMYmjY9V-rzygyDFrDmf2GDP_-vcsEiP-ZOXd6WvNAFUEnhA@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <b7598d9a-eef6-1ff3-7d30-19838b3add51@aklaver.com>
Date: Tue, 30 May 2017 06:22:03 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.1.1
MIME-Version: 1.0
In-Reply-To: 
 <CANRMYmjY9V-rzygyDFrDmf2GDP_-vcsEiP-ZOXd6WvNAFUEnhA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 05/30/2017 05:11 AM, tel medola wrote:
> Sorry by delay....
> 
> 
> The copy being the file system drive backups of each tablespace?
> /
> /
> /Yes/
> /
> /
> Then the below from your original post means?/
> /
> /That despite recovering the backup, I can not access my data. So I 
> posted that I lost my tablespaces./
> 
> When I run the \ d + command the involved tables are not shown. Not even 
> the one I can access via Select (only those that are in the public 
> schema are shown)

So how did you get the below?

> 
> / Esquema  |    Nome     |  Tipo  |   Dono   |  Tamanho   | Descrição/
> /----------+-------------+--------+----------+------------+-----------/
> / 01052016 | repositorio | tabela | postgres | 8192 bytes |/
> / 05122016 | repositorio | tabela | postgres | 8192 bytes |/
> / 13042017 | repositorio | tabela | postgres | 491 GB  |/
> / 22082016 | repositorio | tabela | postgres | 8192 bytes |/
> / 30122015 | repositorio | tabela | postgres | 8192 bytes |/
> 

What does:

show search_path;

return?

Did you try my previous suggestions:

You will either need to set the search_path to all the schemas involved, 
see example at bottom of page below:

https://www.postgresql.org/docs/9.6/static/sql-set.html

or schema.qualify the table name passed to \d+:

\d+ some_schema.table_name

As examples:

SET search_path TO  01052016,  05122016 , 13042017, 22082016, 30122015 
public;

or

For a single object(table, view, sequence) in a schema:

\d+ 01052016.repositorio

For all in a schema:

\d+ 01052016.*


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql