Skip site navigation (1) Skip section navigation (2)

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

From: "Ing(dot) Jhon Carrillo - Caracas, Venezuela" <jdigital(at)cantv(dot)net>
To: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: <msotocl(at)gmail(dot)com>, <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: existe conexion pero no veo las db/schemas en el pgadmin
Date: 2005-09-19 17:50:03
Message-ID: 017201c5bd42$90d53430$1400a8c0@tgusta2 (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
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)
>


In response to

Responses

pgsql-es-ayuda by date

Next:From: Edwin QuijadaDate: 2005-09-19 17:53:43
Subject: RE: zeos y postgres 8.0
Previous:From: Marlene CarhuaricraDate: 2005-09-19 17:16:04
Subject: hacer uso del index en un select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group