pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Fábio Gibon - Comex System <gibon@comexsystem.com.br>
To: fabriziomello@gmail.com
Cc: PostgreSQL - mailing list <pgsql-admin@postgresql.org>
Subject: Re: Lost file
Date: Wed, 6 Oct 2010 12:28:16 -0300
Message-ID: <00f701cb656b$1fa34190$62be62bd@gibon> (raw)
References: <00cd01cb6567$1fcbfc10$62be62bd@gibon>
	<AANLkTimhrySn6JWSuR3AU9pf-+JdktoY8yE+BhpcbQ=w@mail.gmail.com>

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

view thread (3+ messages)

Message-ID: <00f701cb656b$1fa34190$62be62bd@gibon>
Permalink:  ../00f701cb656b$1fa34190$62be62bd@gibon/
Also on:    postgresql.org/message-id/00f701cb656b$1fa34190$62be62bd@gibon

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gibon@comexsystem.com.br, fabriziomello@gmail.com
  Subject: Re: Lost file
  In-Reply-To: <00f701cb656b$1fa34190$62be62bd@gibon>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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