Re: [GENERAL] Read recover rows

2012-12-14 Thread Alvaro Herrera
Alejandro Carrillo escribió: > But pg_dirty_read only runs in Linux. It doesnt run in windows. So port it. There's no fundamental reason for it not to work. -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgs

Re: [GENERAL] Read recover rows

2012-12-14 Thread Alejandro Carrillo
But pg_dirty_read only runs in Linux. It doesnt run in windows. > > De: Alvaro Herrera >Para: Alejandro Carrillo >CC: "pgsql-general@postgresql.org" >Enviado: Jueves 13 de diciembre de 2012 21:51 >Asunto: Re: [GENERAL] Rea

Re: [GENERAL] Read recover rows

2012-12-14 Thread Adrian Klaver
On 12/14/2012 07:30 AM, Tom Lane wrote: Adrian Klaver writes: On 12/13/2012 06:51 PM, Alvaro Herrera wrote: Make sure the server is down and replace a table's file with the file you have. You can just create a dummy empty table with exactly the same row type as the one that had the table the

Re: [GENERAL] Read recover rows

2012-12-14 Thread Tom Lane
Adrian Klaver writes: > On 12/13/2012 06:51 PM, Alvaro Herrera wrote: >> Make sure the server is down and replace a table's file with the file >> you have. You can just create a dummy empty table with exactly the same >> row type as the one that had the table the file was for; you need to >> recr

Re: [GENERAL] Read recover rows

2012-12-14 Thread Adrian Klaver
On 12/13/2012 06:51 PM, Alvaro Herrera wrote: Alejandro Carrillo escribió: Hi, 1) Anybody knows how to create a table using a table file? It isn't a fdw, is a file that compose the table in postgresql and get with the pg_relation_filepath function. Ex: select pg_relation_filepath('pg_proc'

Re: [GENERAL] Read recover rows

2012-12-13 Thread Alvaro Herrera
Alejandro Carrillo escribió: > Hi, > > 1) Anybody knows how to create a table using a table > file? It isn't a fdw, is a file that compose the table in postgresql and > get with the pg_relation_filepath function. Ex: >   >  select pg_relation_filepath('pg_proc'); Make sure the server is down an

Re: [GENERAL] Read recover rows

2012-12-13 Thread Adrian Klaver
On 12/13/2012 03:41 PM, Alejandro Carrillo wrote: Are you trying to recover a table by copying in a table from somewhere else? Yes because I can't modify the original file You will not be able to work with the disk file directly, you will need to go through the database. Have you tried pg_du

Re: [GENERAL] Read recover rows

2012-12-13 Thread Alejandro Carrillo
13 de diciembre de 2012 18:39 >Asunto: Re: [GENERAL] Read recover rows > >On 12/13/2012 03:30 PM, Alejandro Carrillo wrote: >> I have a file CALLED 11649 in the path: %PG_DATA%\base\11912 >> This file is a table data in postgresql. Ex: pg_proc. >> Now I copied this file, ren

Re: [GENERAL] Read recover rows

2012-12-13 Thread Adrian Klaver
On 12/13/2012 03:30 PM, Alejandro Carrillo wrote: I have a file CALLED 11649 in the path: %PG_DATA%\base\11912 This file is a table data in postgresql. Ex: pg_proc. Now I copied this file, renamed it and I want to connect this file to another new table with the same structure and data. How I can

Re: [GENERAL] Read recover rows

2012-12-13 Thread Alejandro Carrillo
? > > De: Adrian Klaver >Para: Alejandro Carrillo >CC: "pgsql-general@postgresql.org" >Enviado: Jueves 13 de diciembre de 2012 18:23 >Asunto: Re: [GENERAL] Read recover rows > >On 12/13/2012 03:14 PM, Alejandro Carrillo wrote: >> Hi, >> >> 1) Is

Re: [GENERAL] Read recover rows

2012-12-13 Thread Adrian Klaver
On 12/13/2012 03:14 PM, Alejandro Carrillo wrote: Hi, 1) Isn't a script. The file is a table file get using the function pg_relation_filepath: select pg_relation_filepath('pg_proc'); The above does NOT return a file it just returns the file path name. Postgres stores it tables(relations) with

Re: [GENERAL] Read recover rows

2012-12-13 Thread Alejandro Carrillo
ql.org" >Enviado: Jueves 13 de diciembre de 2012 17:59 >Asunto: Re: [GENERAL] Read recover rows > >On 12/13/2012 02:23 PM, Alejandro Carrillo wrote: >> Hi, >> >> 1) Anybody knows how to create a table using a table file? It isn't a >> fdw, is a file

Re: [GENERAL] Read recover rows

2012-12-13 Thread Adrian Klaver
On 12/13/2012 02:23 PM, Alejandro Carrillo wrote: Hi, 1) Anybody knows how to create a table using a table file? It isn't a fdw, is a file that compose the table in postgresql and get with the pg_relation_filepath function. Ex: select pg_relation_filepath('pg_proc'); Not sure what you are a

[GENERAL] Read recover rows

2012-12-13 Thread Alejandro Carrillo
Hi, 1) Anybody knows how to create a table using a table file? It isn't a fdw, is a file that compose the table in postgresql and get with the pg_relation_filepath function. Ex:    select pg_relation_filepath('pg_proc');   2) Anybody knows a JDBC or a multiplatform code that let read the delete