pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLost file
3+ messages / 2 participants
[nested] [flat]
* Lost file
@ 2010-10-06 14:59 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2010-10-06 15:16 ` Re: Lost file Fabrízio de Royes Mello <fabriziomello@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Fábio Gibon - Comex System @ 2010-10-06 14:59 UTC (permalink / raw)
To: pgsql-admin
Hi everybody,
i lost one file in my file system, it's file reference the one user table (table "x")... Are there some option to recover this table? (without any backup and database isn't archive mode).
thanks
Fábio Henrique Gibon
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Lost file
2010-10-06 14:59 Lost file Fábio Gibon - Comex System <gibon@comexsystem.com.br>
@ 2010-10-06 15:16 ` Fabrízio de Royes Mello <fabriziomello@gmail.com>
2010-10-06 15:28 ` Re: Lost file Fábio Gibon - Comex System <gibon@comexsystem.com.br>
0 siblings, 1 reply; 3+ messages in thread
From: Fabrízio de Royes Mello @ 2010-10-06 15:16 UTC (permalink / raw)
To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; +Cc: pgsql-admin
2010/10/6 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
> Hi everybody,
> i lost one file in my file system, it's file reference the one user
> table (table "x")... Are there some option to recover this table? (without
> any backup and database isn't archive mode).
>
>
>
Hi Fábio,
If you have no backup I do not see how to recover it, but you can recreate
the table (only structure) by querying the system catalog (if it is working
of course).
Use a similar query do see some information about the columns of table:
SELECT * FROM information_schema.columns WHERE table_name = 'x';
To more information about system catalog see [1] and [2].
[1] http://www.postgresql.org/docs/current/interactive/catalogs.html
[2]
http://www.postgresql.org/docs/current/interactive/information-schema.html
--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Lost file
2010-10-06 14:59 Lost file Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2010-10-06 15:16 ` Re: Lost file Fabrízio de Royes Mello <fabriziomello@gmail.com>
@ 2010-10-06 15:28 ` Fábio Gibon - Comex System <gibon@comexsystem.com.br>
0 siblings, 0 replies; 3+ messages in thread
From: Fábio Gibon - Comex System @ 2010-10-06 15:28 UTC (permalink / raw)
To: fabriziomello@gmail.com; +Cc: pgsql-admin
Tks Fabrizio...
I didn't want believe in this...but... :(
My file exists, but with 0 bytes... the table struture only... when i do "select * ..." is returned all columns but zero tuples...
thanks again
Fábio Gibon
----- Original Message -----
From: Fabrízio de Royes Mello
To: Fábio Gibon - Comex System
Cc: PostgreSQL - mailing list
Sent: Wednesday, October 06, 2010 12:16 PM
Subject: Re: [ADMIN] Lost file
2010/10/6 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
Hi everybody,
i lost one file in my file system, it's file reference the one user table (table "x")... Are there some option to recover this table? (without any backup and database isn't archive mode).
Hi Fábio,
If you have no backup I do not see how to recover it, but you can recreate the table (only structure) by querying the system catalog (if it is working of course).
Use a similar query do see some information about the columns of table:
SELECT * FROM information_schema.columns WHERE table_name = 'x';
To more information about system catalog see [1] and [2].
[1] http://www.postgresql.org/docs/current/interactive/catalogs.html
[2] http://www.postgresql.org/docs/current/interactive/information-schema.html
--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-10-06 15:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-06 14:59 Lost file Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2010-10-06 15:16 ` Fabrízio de Royes Mello <fabriziomello@gmail.com>
2010-10-06 15:28 ` Fábio Gibon - Comex System <gibon@comexsystem.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox