Postgres Pro
Downloads
Home   >   mailing lists

Thread: Lost file

Lost file

From
Fábio Gibon - Comex System
Date:
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
 

Re: Lost file

From
Fabrízio de Royes Mello
Date:


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].



--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com

Re: Lost file

From
Fábio Gibon - Comex System
Date:
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 -----
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].



--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com

installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error)

From
Kiswono Prayogo
Date:
Error: Visual C++ Runtime Installation error and installation not
continued (i forgot the exact error phrase, i'm using linux right now)
PostgreSQL: 9.0.0
OS: Windows XP SP3
Notes:
1. i believe Visual C++ 2005 and 2008 Runtime already installed before
2. im using sing administrator Account
3. most folder protected as read only for guest account
4. after that i tried to install using postgre 8.4,x, somehow it's
installed successfully

Regards,
Kiswono
GB

Re: installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error)

From
"Josi Perez (3T Systems)"
Date:
I had this error and the same condition listed
and solved the problem including an extra parameter when calling the program

postgresql-8.4.2-1-windows.exe   --install_runtimes 0 
(substitute by the right exe)

I hope solve your problem too,
Josi Perez


2010/10/7 Kiswono Prayogo <kiswono@gmail.com>

Error: Visual C++ Runtime Installation error and installation not continued (i forgot the exact error phrase, i'm using linux right now)
PostgreSQL: 9.0.0
OS: Windows XP SP3
Notes:
1. i believe Visual C++ 2005 and 2008 Runtime already installed before
2. im using sing administrator Account
3. most folder protected as read only for guest account
4. after that i tried to install using postgre 8.4,x, somehow it's installed successfully

Regards,
Kiswono
GB

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 13px;}