Lists: | pgsql-admin |
---|
From: | Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br> |
---|---|
To: | "PostgreSQL - mailing list" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Lost file |
Date: | 2010-10-06 14:59:29 |
Message-ID: | 00cd01cb6567$1fcbfc10$62be62bd@gibon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | 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
From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
---|---|
To: | Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br> |
Cc: | PostgreSQL - mailing list <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Lost file |
Date: | 2010-10-06 15:16:37 |
Message-ID: | AANLkTimhrySn6JWSuR3AU9pf-+JdktoY8yE+BhpcbQ=w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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
From: | Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br> |
---|---|
To: | <fabriziomello(at)gmail(dot)com> |
Cc: | "PostgreSQL - mailing list" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Lost file |
Date: | 2010-10-06 15:28:16 |
Message-ID: | 00f701cb656b$1fa34190$62be62bd@gibon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | 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(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
From: | Kiswono Prayogo <kiswono(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error) |
Date: | 2010-10-07 16:58:18 |
Message-ID: | 4CADFC2A.5070100@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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
From: | "Josi Perez (3T Systems)" <josiperez3t(at)gmail(dot)com> |
---|---|
To: | Kiswono Prayogo <kiswono(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error) |
Date: | 2010-10-13 14:00:19 |
Message-ID: | AANLkTikn_vFpnxD0gRf95-5Qnq0N+YB=bNoDWT6wVoMs@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
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
>