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

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

2010/10/6 Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)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

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(at)comexsystem(dot)com(dot)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

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

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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>