Re: existe conexion pero no veo las db/schemas en el pgadmin

hola

ejecute pg_filedump -i 1262 y resulto esto, agradezco la ayuda:

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility - Version 4.0
*
* File: /var/lib/pgsql/data/global/1262
* Options used: -i
*
* Dump created on: Tue Sep 20 13:44:28 2005
*******************************************************************

Block 0 ********************************************************
<Header> -----
Block Offset: 0x00000000 Offsets: Lower 108 (0x006c)
Block: Size 8192 Version 2 Upper 4004 (0x0fa4)
LSN: logid 0 recoff 0x0e250e4c Special 8192 (0x2000)
Items: 22 Free Space: 3896
Length (including item array): 112

<Data> ------
Item 1 -- Length: 128 Offset: 7736 (0x1e38) Flags: USED
XMIN: 567 CMIN: 0 XMAX: 568 CMAX|XVAC: 0
Block Id: 0 linp Index: 2 Attributes: 11 Size: 36
infomask: 0x0511 (HASNULL|HASOID|XMIN_COMMITTED|XMAX_COMMITTED)
t_bits: [0]: 0xff [1]: 0x01

Item 2 -- Length: 164 Offset: 7572 (0x1d94) Flags: USED
XMIN: 568 CMIN: 0 XMAX: 569 CMAX|XVAC: 0
Block Id: 0 linp Index: 3 Attributes: 11 Size: 36
infomask: 0x2513
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)
t_bits: [0]: 0xff [1]: 0x05

Item 3 -- Length: 152 Offset: 7420 (0x1cfc) Flags: USED
XMIN: 569 CMIN: 0 XMAX: 570 CMAX|XVAC: 0
Block Id: 0 linp Index: 4 Attributes: 11 Size: 36
infomask: 0x2513
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)
t_bits: [0]: 0xff [1]: 0x05

Item 4 -- Length: 164 Offset: 7256 (0x1c58) Flags: USED
XMIN: 570 CMIN: 0 XMAX: 571 CMAX|XVAC: 0
Block Id: 0 linp Index: 5 Attributes: 11 Size: 36
infomask: 0x2513
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)
t_bits: [0]: 0xff [1]: 0x05

Item 5 -- Length: 176 Offset: 7080 (0x1ba8) Flags: USED
XMIN: 571 CMIN: 0 XMAX: 572 CMAX|XVAC: 0
Block Id: 0 linp Index: 8 Attributes: 11 Size: 36
infomask: 0x2513
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)
t_bits: [0]: 0xff [1]: 0x05

Item 6 -- Length: 164 Offset: 8028 (0x1f5c) Flags: USED
XMIN: 538 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 6 Attributes: 11 Size: 36
infomask: 0x2913
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0x05

Item 7 -- Length: 164 Offset: 7864 (0x1eb8) Flags: USED
XMIN: 539 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 7 Attributes: 11 Size: 36
infomask: 0x2913
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0x05

Item 8 -- Length: 224 Offset: 6856 (0x1ac8) Flags: USED
XMIN: 572 CMIN: 0 XMAX: 573 CMAX|XVAC: 0
Block Id: 0 linp Index: 9 Attributes: 11 Size: 32
infomask: 0x2512
(HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)

Item 9 -- Length: 272 Offset: 6584 (0x19b8) Flags: USED
XMIN: 573 CMIN: 0 XMAX: 691100 CMAX|XVAC: 0
Block Id: 0 linp Index: 16 Attributes: 11 Size: 32
infomask: 0x2512
(HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)

Item 10 -- Length: 128 Offset: 6456 (0x1938) Flags: USED
XMIN: 574 CMIN: 0 XMAX: 575 CMAX|XVAC: 0
Block Id: 0 linp Index: 11 Attributes: 11 Size: 36
infomask: 0x0511 (HASNULL|HASOID|XMIN_COMMITTED|XMAX_COMMITTED)
t_bits: [0]: 0xff [1]: 0x01

Item 11 -- Length: 184 Offset: 6272 (0x1880) Flags: USED
XMIN: 575 CMIN: 0 XMAX: 576 CMAX|XVAC: 0
Block Id: 0 linp Index: 12 Attributes: 11 Size: 36
infomask: 0x2513
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)
t_bits: [0]: 0xff [1]: 0x03

Item 12 -- Length: 212 Offset: 6060 (0x17ac) Flags: USED
XMIN: 576 CMIN: 0 XMAX: 703718 CMAX|XVAC: 0
Block Id: 0 linp Index: 17 Attributes: 11 Size: 36
infomask: 0x2513
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)
t_bits: [0]: 0xff [1]: 0x03

Item 13 -- Length: 128 Offset: 5932 (0x172c) Flags: USED
XMIN: 577 CMIN: 0 XMAX: 578 CMAX|XVAC: 0
Block Id: 0 linp Index: 14 Attributes: 11 Size: 36
infomask: 0x0511 (HASNULL|HASOID|XMIN_COMMITTED|XMAX_COMMITTED)
t_bits: [0]: 0xff [1]: 0x01

Item 14 -- Length: 184 Offset: 5748 (0x1674) Flags: USED
XMIN: 578 CMIN: 0 XMAX: 579 CMAX|XVAC: 0
Block Id: 0 linp Index: 15 Attributes: 11 Size: 36
infomask: 0x2513
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_COMMITTED|UPDATED)
t_bits: [0]: 0xff [1]: 0x03

Item 15 -- Length: 212 Offset: 5536 (0x15a0) Flags: USED
XMIN: 579 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 15 Attributes: 11 Size: 36
infomask: 0x2913
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0x03

Item 16 -- Length: 284 Offset: 5252 (0x1484) Flags: USED
XMIN: 691100 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 16 Attributes: 11 Size: 32
infomask: 0x2912 (HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)

Item 17 -- Length: 224 Offset: 5028 (0x13a4) Flags: USED
XMIN: 703718 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 17 Attributes: 11 Size: 36
infomask: 0x2913
(HASNULL|HASVARWIDTH|HASOID|XMIN_COMMITTED|XMAX_INVALID|UPDATED)
t_bits: [0]: 0xff [1]: 0x03

Item 18 -- Length: 164 Offset: 4864 (0x1300) Flags: USED
XMIN: 2151222142 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 18 Attributes: 11 Size: 36
infomask: 0x0a13 (HASNULL|HASVARWIDTH|HASOID|XMIN_INVALID|XMAX_INVALID)
t_bits: [0]: 0xff [1]: 0x05

Item 19 -- Length: 164 Offset: 4700 (0x125c) Flags: USED
XMIN: 2151222143 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 19 Attributes: 11 Size: 36
infomask: 0x0a13 (HASNULL|HASVARWIDTH|HASOID|XMIN_INVALID|XMAX_INVALID)
t_bits: [0]: 0xff [1]: 0x05

Item 20 -- Length: 272 Offset: 4428 (0x114c) Flags: USED
XMIN: 2151222144 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 20 Attributes: 11 Size: 32
infomask: 0x0a12 (HASVARWIDTH|HASOID|XMIN_INVALID|XMAX_INVALID)

Item 21 -- Length: 212 Offset: 4216 (0x1078) Flags: USED
XMIN: 2151222145 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 21 Attributes: 11 Size: 36
infomask: 0x0a13 (HASNULL|HASVARWIDTH|HASOID|XMIN_INVALID|XMAX_INVALID)
t_bits: [0]: 0xff [1]: 0x03

Item 22 -- Length: 212 Offset: 4004 (0x0fa4) Flags: USED
XMIN: 2151222146 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 22 Attributes: 11 Size: 36
infomask: 0x0a13 (HASNULL|HASVARWIDTH|HASOID|XMIN_INVALID|XMAX_INVALID)
t_bits: [0]: 0xff [1]: 0x03

*** End of File Encountered. Last Block Read: 0 ***

----- Original Message -----
From: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>
To: "Ing. Jhon Carrillo - Caracas, Venezuela" <jdigital(at)cantv(dot)net>
Cc: <msotocl(at)gmail(dot)com>; <pgsql-es-ayuda(at)postgresql(dot)org>
Sent: Tuesday, September 20, 2005 12:50 PM
Subject: Re: [pgsql-es-ayuda] existe conexion pero no veo las db/schemas en
el pgadmin

> On Mon, Sep 19, 2005 at 12:41:58PM -0400, Ing. Jhon Carrillo - Caracas,
Venezuela wrote:
> > es posible recuperar la estructura de los objetos existentes, el
pg_dumpall
> > no me devuelve mucho ya que asume que no hay bases de datos en
pg_database,
> > pero yo consulto mis tablas sin ningun problema.
> >
> > O de alguna forma, recargar las tablas de sistemas, llamese pg_database,
> > pg_user, etc
>
> Hum. Es posible. Primero que nada, haz una copia de todo $PGDATA y
> guardala en algun lugar seguro -- solo por si pasa algo inesperado.
>
> Luego, consigue pg_filedump (http://sources.redhat.com/rhdb) y echa una
> mirada al archivo de pg_database. El archivo de pg_database deberia
> llamarse 1262, en el directorio data/base/global. Publica la salida de
> pg_filedump -i de ese archivo.
>
> Si hay evidencia de wraparound, tendras que seguir las instrucciones
> para "volver atras" el contador de transacciones, con cuidado. Adjunto
> un mail donde Tom Lane las pone.
>
> Si no, vuelve aca y vemos que podemos hacer.
>
> --
> Alvaro Herrera
http://www.advogato.org/person/alvherre
> "And as an added bonus, now my computer goes to the toilet for me, leaving
me
> free to spend time on more useful activities! yay slug codefests!" (C.
Parker)
>

----------------------------------------------------------------------------
----

>
> ---------------------------(fin del mensaje)---------------------------
> TIP 2: puedes desuscribirte de todas las listas simultáneamente
> (envíe "unregister TuDirecciónDeCorreo" a majordomo(at)postgresql(dot)org)
>