From gibon@comexsystem.com.br Wed Oct 6 15:00:02 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id F31391337B77 for ; Wed, 6 Oct 2010 12:00:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 94707-10 for ; Wed, 6 Oct 2010 14:59:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ns3b.twi.com.br (ns3b.twi.com.br [201.87.225.54]) by mail.postgresql.org (Postfix) with ESMTP id D43731337B54 for ; Wed, 6 Oct 2010 11:59:54 -0300 (ADT) Received: (qmail 19799 invoked from network); 6 Oct 2010 11:58:07 -0300 Received: from unknown (HELO gibon) (gibon@comexsystem.com.br@[189.98.190.98]) (envelope-sender ) by ns3b.twi.com.br (qmail-ldap-1.03) with SMTP for ; 6 Oct 2010 11:58:06 -0300 Message-ID: <00cd01cb6567$1fcbfc10$62be62bd@gibon> Reply-To: =?Windows-1252?Q?F=E1bio_Gibon_-_Comex_System?= From: =?Windows-1252?Q?F=E1bio_Gibon_-_Comex_System?= To: "PostgreSQL - mailing list" Subject: Lost file Date: Wed, 6 Oct 2010 11:59:29 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CA_01CB654D.EE7C45C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201010/58 X-Sequence-Number: 35799 This is a multi-part message in MIME format. ------=_NextPart_000_00CA_01CB654D.EE7C45C0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable 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=E1bio Henrique Gibon ------=_NextPart_000_00CA_01CB654D.EE7C45C0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi everybody,
        i lost = one file=20 in my file system, it's file reference the one user table (table "x")... = Are=20 there some option to recover this table? (without any backup and = database isn't=20 archive mode).
 
thanks
F=E1bio Henrique Gibon
 
------=_NextPart_000_00CA_01CB654D.EE7C45C0-- From fabriziomello@gmail.com Wed Oct 6 15:17:41 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 880161337C8B for ; Wed, 6 Oct 2010 12:17:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 67880-04-2 for ; Wed, 6 Oct 2010 15:17:33 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qy0-f181.google.com (mail-qy0-f181.google.com [209.85.216.181]) by mail.postgresql.org (Postfix) with ESMTP id 2A9F21337C1D for ; Wed, 6 Oct 2010 12:16:40 -0300 (ADT) Received: by qyk10 with SMTP id 10so4120940qyk.19 for ; Wed, 06 Oct 2010 08:16:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:reply-to :in-reply-to:references:date:message-id:subject:from:to:cc :content-type; bh=Yfg2NR/P1D+Jdo7MsPBVckx1r//TFlGDBSCaC3s+BIE=; b=g7wtwqXXYZd6QNfnJhG5PQjTLediw7LP9Ia23GgvQ9mzDPPBLbOpEb0F6AvqKrF8TH mj7EhgSGHIliRoo6hLjGlaDMVe7CFKAadEADbrU9GAwdN9rYQR0LXz3JxgRD+Kwb/roh JnOUQoFAKzEBhVyJ7xLKG9S5ZAhPbvV5Qco5Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:reply-to:in-reply-to:references:date:message-id :subject:from:to:cc:content-type; b=k+hwdtoDmRmYmI3z9Urlpd3/u2FAhtQEFwHuZ7FuLHZF1/dxAiYXro+KPCG265P/Kj BEeF4faNFvdoY5vzXwLOj7az2PiIAPP5mwfK0fYCa6iVC6n05G+E+AebtWqMLxCDKU67 ih/uH29TQPCab2MDRJNrN142VMsJZV3TXBjl8= MIME-Version: 1.0 Received: by 10.224.53.200 with SMTP id n8mr9556918qag.190.1286378198094; Wed, 06 Oct 2010 08:16:38 -0700 (PDT) Received: by 10.224.28.65 with HTTP; Wed, 6 Oct 2010 08:16:37 -0700 (PDT) Reply-To: fabriziomello@gmail.com In-Reply-To: <00cd01cb6567$1fcbfc10$62be62bd@gibon> References: <00cd01cb6567$1fcbfc10$62be62bd@gibon> Date: Wed, 6 Oct 2010 12:16:37 -0300 Message-ID: Subject: Re: Lost file From: =?ISO-8859-1?Q?Fabr=EDzio_de_Royes_Mello?= To: =?ISO-8859-1?Q?F=E1bio_Gibon_=2D_Comex_System?= Cc: PostgreSQL - mailing list Content-Type: multipart/alternative; boundary=0015175d09ca8b5d540491f4434a X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201010/60 X-Sequence-Number: 35801 --0015175d09ca8b5d540491f4434a Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 2010/10/6 F=E1bio Gibon - Comex System > Hi everybody, > i lost one file in my file system, it's file reference the one us= er > table (table "x")... Are there some option to recover this table? (withou= t > any backup and database isn't archive mode). > > > Hi F=E1bio, 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 =3D '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 --=20 Fabr=EDzio de Royes Mello >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello --0015175d09ca8b5d540491f4434a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

2010/10/6 F=E1bio Gibon - Comex System <= span dir=3D"ltr"><gibon@come= xsystem.com.br>
Hi everybody,
=A0=A0=A0=A0=A0=A0=A0 i lost one file=20 in my file system, it's file reference the one user table (table "= x")... Are=20 there some option to recover this table? (without any backup and database i= sn't=20 archive mode).
=A0
=A0

Hi F=E1bio,

If you have no backup= I do not see how to recover it, but you can recreate the table (only struc= ture) by querying the system catalog (if it is working of course).=A0

Use a similar query do see some information about the c= olumns of table:

SELECT * FROM information_schema.columns WH= ERE table_name =3D 'x';

To more inf= ormation about system catalog see [1] and [2].

[1]= =A0http://www.postgresql.org/docs/current/interactive/catalogs.html


--
Fabr=EDzio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogs= pot.com
--0015175d09ca8b5d540491f4434a-- From gibon@comexsystem.com.br Wed Oct 6 15:28:40 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6159F1337BB0 for ; Wed, 6 Oct 2010 12:28:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 80149-09 for ; Wed, 6 Oct 2010 15:28:32 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ns3b.twi.com.br (ns3b.twi.com.br [201.87.225.54]) by mail.postgresql.org (Postfix) with ESMTP id A8EA61337BA5 for ; Wed, 6 Oct 2010 12:28:31 -0300 (ADT) Received: (qmail 2779 invoked from network); 6 Oct 2010 12:26:45 -0300 Received: from unknown (HELO gibon) (gibon@comexsystem.com.br@[189.98.190.98]) (envelope-sender ) by ns3b.twi.com.br (qmail-ldap-1.03) with SMTP for ; 6 Oct 2010 12:26:44 -0300 Message-ID: <00f701cb656b$1fa34190$62be62bd@gibon> Reply-To: =?iso-8859-1?Q?F=E1bio_Gibon_-_Comex_System?= From: =?iso-8859-1?Q?F=E1bio_Gibon_-_Comex_System?= To: Cc: "PostgreSQL - mailing list" References: <00cd01cb6567$1fcbfc10$62be62bd@gibon> Subject: Re: Lost file Date: Wed, 6 Oct 2010 12:28:16 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00F4_01CB6551.F3696C80" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=-10 required=5 tests=BAYES_20=-0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201010/61 X-Sequence-Number: 35802 This is a multi-part message in MIME format. ------=_NextPart_000_00F4_01CB6551.F3696C80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=E1bio Gibon ----- Original Message -----=20 From: Fabr=EDzio de Royes Mello=20 To: F=E1bio Gibon - Comex System=20 Cc: PostgreSQL - mailing list=20 Sent: Wednesday, October 06, 2010 12:16 PM Subject: Re: [ADMIN] Lost file 2010/10/6 F=E1bio Gibon - Comex System 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=E1bio, 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).=20 Use a similar query do see some information about the columns of = table: SELECT * FROM information_schema.columns WHERE table_name =3D '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.htm= l --=20 Fabr=EDzio de Royes Mello >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello ------=_NextPart_000_00F4_01CB6551.F3696C80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Tks=20 Fabrizio...
         I didn't = want=20 believe in this...but... :(
 
         My=20 file exists, but with 0 bytes... the table struture only... when i do = "select *=20 ..." is returned all columns but zero tuples...
 
thanks again
F=E1bio = Gibon
 
----- Original Message -----
From:=20 Fabr=EDzio de Royes Mello =
Sent: Wednesday, October 06, = 2010 12:16=20 PM
Subject: Re: [ADMIN] Lost = file



2010/10/6 F=E1bio Gibon - Comex System <gibon@comexsystem.com.br>=
Hi everybody,
        i = lost one=20 file in my file system, it's file reference the one user table = (table=20 "x")... Are there some option to recover this table? (without any = backup and=20 database isn't archive mode).
 
 

Hi F=E1bio,

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=20 working of course). 

Use a similar query do see some information about the columns of=20 table:

SELECT * FROM information_schema.columns WHERE table_name =3D = '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=EDzio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello

------=_NextPart_000_00F4_01CB6551.F3696C80--