Re: [GENERAL] Schemas and serials

Depends. When you create your tables in new schema, the script was the same from "qa"? Sequences, tables, etc.. belong to the schema where was created. Roberto. Em sáb, 29 de jul de 2017 às 16:17, marcelo escreveu: > Some days ago I asked regarding tables located in

[GENERAL] Redo the filenode link in tablespace

Hi. I have a rather serious problem in my database. I'll try to summarize what happened and how far I've gotten with the help of friends from the pgsql-sql list. First of all I apologize for the size of the question. But I do not see any other way to do it. Windows 2008 R2 - 64 bits PostgreSQL

Re: [GENERAL] Redo the filenode link in tablespace

Sorry. I got sick these days and could not read my emails. Thanks for your help. I'll try to point to the direct node and see what happens. 2017-06-01 10:29 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/01/2017 03:47 AM, tel medola wrote: > >> Di

Re: [GENERAL] Redo the filenode link in tablespace

6; VACUUM ANALYZE pg_toast_9277966 VACUUM ANALYZE "05122016".repositorio; REINDEX TABLE pg_statistic; I read in the forum to run the command: Delete from pg_statistic; Reindex table pg_statistic; Vacuum analyze; Is it okay to delete the pg_statistic table? 2017-06-05 9:24 GMT-03:00 tel med

Re: [GENERAL] Redo the filenode link in tablespace

Holy shit! (sorry) Thanks, thanks!!! It worked! My goodness After I point to the filnode, I did a reindex on the toast and some records have already been located. 2017-06-07 17:58 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/07/2017 07:53 AM, tel med

Re: [GENERAL] Redo the filenode link in tablespace

filenode is pointing to another reference. The table is empty, just because the filenode does not point to the correct ID.* 2017-05-31 20:22 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 05/31/2017 06:05 AM, tel medola wrote: > >> Hi. >> I have a rather serious prob

Re: [GENERAL] Redo the filenode link in tablespace

. Thank you very much the people who maintains Postgres (I could even help in some, because I'm a programmer too). And Thanks also to the people who dedicate their time to helping unknow people with problems, especially to Adrian. Thanks Roberto. 2017-06-07 22:05 GMT-03:00 tel medola <tel.

Re: [GENERAL] Redo the filenode link in tablespace

Sure! It's going to be a little long, but I write with great pleasure. 2017-06-08 8:04 GMT-03:00 Karsten Hilbert <karsten.hilb...@gmx.net>: > On Thu, Jun 08, 2017 at 07:53:01AM -0300, tel medola wrote: > > > I would like to thank Adrian very much for his great help and patience

Re: [GENERAL] Redo the filenode link in tablespace

tps://www.postgresql.org/docs/9.1/static/release-7-4-2.html>) and I ended up doing it. Now I'm running a vacuum analyze across the base.* 2017-06-05 15:41 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/05/2017 07:17 AM, tel medola wrote: > >> Done. >> I

Re: [GENERAL] Redo the filenode link in tablespace

:08 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/06/2017 02:07 PM, tel medola wrote: > >> rai=# select oid, * from pg_class where oid = 5214493; >> >> result: >> >> >> oid | relname | relnamespace | reltype | reloftype

Re: [GENERAL] Redo the filenode link in tablespace

| f | t | 9360288 | 1 || (1 registro) Ok? 2017-06-05 20:13 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/05/2017 04:07 PM, tel medola wrote: > >> Hi, >> attachment. >> >> select: >> select *

Re: [GENERAL] Redo the filenode link in tablespace

I will send as soon as possible. He's running the vacuum yet. 2017-06-05 16:02 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/05/2017 11:55 AM, tel medola wrote: > >> show? >> /Yes/ >> > > Yes, what? > > Please run the command as shown: &g

Re: [GENERAL] Redo the filenode link in tablespace

Hi, attachment. select: select * from pg_class where relfilenode = 5214489 Thanks 2017-06-05 16:02 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/05/2017 11:55 AM, tel medola wrote: > >> show? >> /Yes/ >> > > Yes, what? > > Please r

Re: [GENERAL] Redo the filenode link in tablespace

I will not be able to recover my information any more, right? 2017-06-06 10:37 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/06/2017 04:40 AM, tel medola wrote: > >> Lets go: >> In my plsql: >> rai=# select oid, * from pg_class where relfilenode =

Re: [GENERAL] Redo the filenode link in tablespace

2 Dir(s) 198.487.891.968 bytes free 2017-06-06 16:37 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 06/06/2017 11:09 AM, tel medola wrote: > >> I will not be able to recover my information any more, right? >> > > That is what I am trying to figure out. >