Re: Estructura de una página Postgresql

Alvaro,

En primer lugar, gracias por la ayuda.

He hecho el make install-all-headers, como el usuario
postgres, y me da el error [1]

He ejecutado el make indicado como root, y lo ejecuta
sin problemas (tengo mis dudas acerca de que esto sea
correcto :-S ). Ahora bien, cuando después intento
compilar el pg_filedump, obtengo el error [2].

Ahí van las preguntas:

a) Es correcto que tenga que ejecutar make
install-all-headers como root???? No tiene demasiado
sentido, pero no entiendo porqué como postgres me da
el error indicado
b) Si es correcto, ¿porqué continúa sin encontrar las
librerias correctas?

Tengo postgresql 7.4.2 sobre 9.0

Gracias por adelantado,

Sílvia

(Una mujer desesperada)

[1]:
postgres(at)a5s111pc35:/usr/local/src/postgresql-7.4.2>
make install-all-headers
make -C src install-all-headers
make[1]: Entering directory
`/usr/local/src/postgresql-7.4.2/src'
make -C include install-all-headers
make[2]: Entering directory
`/usr/local/src/postgresql-7.4.2/src/include'
/bin/sh ../../config/mkinstalldirs
/usr/local/pgsql/include/server/access
/usr/local/pgsql/include/server/bootstrap
/usr/local/pgsql/include/server/catalog
/usr/local/pgsql/include/server/commands
/usr/local/pgsql/include/server/executor
/usr/local/pgsql/include/server/lib
/usr/local/pgsql/include/server/libpq
/usr/local/pgsql/include/server/mb
/usr/local/pgsql/include/server/nodes
/usr/local/pgsql/include/server/optimizer
/usr/local/pgsql/include/server/parser
/usr/local/pgsql/include/server/port
/usr/local/pgsql/include/server/regex
/usr/local/pgsql/include/server/rewrite
/usr/local/pgsql/include/server/storage
/usr/local/pgsql/include/server/tcop
/usr/local/pgsql/include/server/utils
/bin/sh ../../config/install-sh -c -m 644 pg_config.h
/usr/local/pgsql/include/server
cp: no se puede crear el fichero regular
`/usr/local/pgsql/include/server/#inst.15524#':
Permiso denegado
make[2]: *** [install-all-headers] Error 1
make[2]: Leaving directory
`/usr/local/src/postgresql-7.4.2/src/include'
make[1]: *** [install-all-headers] Error 2
make[1]: Leaving directory
`/usr/local/src/postgresql-7.4.2/src'
make: *** [install-all-headers] Error 2

[2]

a5s111pc35:/usr/local/src/postgresql-7.4.2/contrib/pg_filedump-3.0
# make
gcc -g -Wall -Wmissing-prototypes
-Wmissing-declarations -I/usr/local/pgsql/incl
ude pg_filedump.c -c
In file included from pg_filedump.c:28:
pg_filedump.h:31:22: postgres.h: No such file or
directory
pg_filedump.h:32:29: storage/bufpage.h: No such file
or directory
pg_filedump.h:33:25: access/hash.h: No such file or
directory
pg_filedump.h:34:25: access/gist.h: No such file or
directory
pg_filedump.h:35:27: access/nbtree.h: No such file or
directory
pg_filedump.h:36:26: access/rtree.h: No such file or
directory
pg_filedump.h:37:25: access/itup.h: No such file or
directory
pg_filedump.h:38:25: access/htup.h: No such file or
directory
pg_filedump.h:39:32: catalog/pg_control.h: No such
file or directory
pg_filedump.c:46: error: parse error before "page"
pg_filedump.c:48: error: parse error before "page"
pg_filedump.c:49: error: parse error before "page"
pg_filedump.c: In function `ConsumeOptions':
pg_filedump.c:112: warning: implicit declaration of
function `strlen'
pg_filedump.c:116: warning: implicit declaration of
function `strcmp'
pg_filedump.c: In function `GetOptionValue':
pg_filedump.c:384: warning: implicit declaration of
function `atoi'
pg_filedump.c: In function `GetBlockSize':
pg_filedump.c:395: error: `PageHeaderData' undeclared
(first use in this functio
n)
pg_filedump.c:395: error: (Each undeclared identifier
is reported only once
pg_filedump.c:395: error: for each function it appears
in.)
pg_filedump.c:405: warning: implicit declaration of
function `PageGetPageSize'
pg_filedump.c: At top level:
pg_filedump.c:415: error: parse error before "page"
pg_filedump.c: In function `GetSpecialSectionType':
pg_filedump.c:421: error: `PageHeader' undeclared
(first use in this function)
pg_filedump.c:421: error: parse error before
"pageHeader"
pg_filedump.c:425: error: `PageHeaderData' undeclared
(first use in this functio
n)
pg_filedump.c:427: error: `pageHeader' undeclared
(first use in this function)
pg_filedump.c:442: warning: implicit declaration of
function `MAXALIGN'
pg_filedump.c:442: error: `uint32' undeclared (first
use in this function)
pg_filedump.c:455: error: `HashPageOpaqueData'
undeclared (first use in this fun
ction)
pg_filedump.c:457: error: `HashPageOpaque' undeclared
(first use in this functio
n)
pg_filedump.c:457: error: parse error before "hpo"
pg_filedump.c:458: error: `hpo' undeclared (first use
in this function)
pg_filedump.c:458: error: `HASHO_FILL' undeclared
(first use in this function)
pg_filedump.c: In function `CreateDumpFileHeader':
pg_filedump.c:488: warning: implicit declaration of
function `strcat'
pg_filedump.c: At top level:
pg_filedump.c:505: error: parse error before "page"
pg_filedump.c: In function `FormatHeader':
pg_filedump.c:509: error: `PageHeader' undeclared
(first use in this function)
pg_filedump.c:509: error: parse error before
"pageHeader"
pg_filedump.c:515: error: `PageHeaderData' undeclared
(first use in this functio
n)
pg_filedump.c:522: error: `XLogRecPtr' undeclared
(first use in this function)
pg_filedump.c:522: error: parse error before "pageLSN"
pg_filedump.c:523: warning: implicit declaration of
function `PageGetMaxOffsetNu
mber'
pg_filedump.c:523: error: `page' undeclared (first use
in this function)
pg_filedump.c:525: warning: implicit declaration of
function `PageGetPageLayoutV
ersion'
pg_filedump.c:531: error: `ItemIdData' undeclared
(first use in this function)
pg_filedump.c:548: error: `pageHeader' undeclared
(first use in this function)
pg_filedump.c:551: error: `pageLSN' undeclared (first
use in this function)
pg_filedump.c:557: warning: implicit declaration of
function `PageGetSpecialSize
'
pg_filedump.c:558: error: `BTPageOpaqueData'
undeclared (first use in this funct
ion)
pg_filedump.c:563: error: `BTPageOpaque' undeclared
(first use in this function)
pg_filedump.c:563: error: parse error before "btpo"
pg_filedump.c:566: error: `HashPageOpaque' undeclared
(first use in this functio
n)
pg_filedump.c:566: error: `btpo' undeclared (first use
in this function)
pg_filedump.c:566: error: `HASHO_FILL' undeclared
(first use in this function)
pg_filedump.c:567: error: `BTP_META' undeclared (first
use in this function)
pg_filedump.c:569: error: `BTMetaPageData' undeclared
(first use in this functio
n)
pg_filedump.c:569: error: `btpMeta' undeclared (first
use in this function)
pg_filedump.c:569: warning: implicit declaration of
function `BTPageGetMeta'
pg_filedump.c: At top level:
pg_filedump.c:613: error: parse error before "page"
pg_filedump.c: In function `FormatItemBlock':
pg_filedump.c:619: error: `ItemId' undeclared (first
use in this function)
pg_filedump.c:619: error: parse error before "itemId"
pg_filedump.c:620: error: `page' undeclared (first use
in this function)
pg_filedump.c:650: error: `itemId' undeclared (first
use in this function)
pg_filedump.c:650: warning: implicit declaration of
function `PageGetItemId'
pg_filedump.c:651: warning: implicit declaration of
function `ItemIdGetFlags'
pg_filedump.c:652: warning: implicit declaration of
function `ItemIdGetLength'
pg_filedump.c:653: warning: implicit declaration of
function `ItemIdGetOffset'
pg_filedump.c:656: warning: implicit declaration of
function `strcpy'
pg_filedump.c:656: error: `LP_USED' undeclared (first
use in this function)
pg_filedump.c: In function `FormatItem':
pg_filedump.c:698: error: `SizeOfIptrData' undeclared
(first use in this functio
n)
pg_filedump.c:705: error: `IndexTuple' undeclared
(first use in this function)
pg_filedump.c:705: error: parse error before "itup"
pg_filedump.c:708: error: `uint32' undeclared (first
use in this function)
pg_filedump.c:708: error: `itup' undeclared (first use
in this function)
pg_filedump.c:709: error: `uint16' undeclared (first
use in this function)
pg_filedump.c:709: error: parse error before "itup"
pg_filedump.c:709: warning: too few arguments for
format
pg_filedump.c:710: warning: implicit declaration of
function `IndexTupleSize'
pg_filedump.c:711: warning: implicit declaration of
function `IndexTupleHasNulls
'
pg_filedump.c:711: warning: implicit declaration of
function `IndexTupleHasVarwi
dths'
pg_filedump.c:711: warning: left-hand operand of comma
expression has no effect
pg_filedump.c:711: error: parse error before ')' token
pg_filedump.c:721: error: `HeapTupleHeaderData'
undeclared (first use in this fu
nction)
pg_filedump.c:738: error: `bits8' undeclared (first
use in this function)
pg_filedump.c:738: error: `localBits' undeclared
(first use in this function)
pg_filedump.c:741: error: `HeapTupleHeader' undeclared
(first use in this functi
on)
pg_filedump.c:741: error: parse error before "htup"
pg_filedump.c:745: error: `htup' undeclared (first use
in this function)
pg_filedump.c:748: error: parse error before "htup"
pg_filedump.c:749: warning: too few arguments for
format
pg_filedump.c:750: warning: left-hand operand of comma
expression has no effect
pg_filedump.c:750: warning: left-hand operand of comma
expression has no effect
pg_filedump.c:750: error: parse error before ')' token
pg_filedump.c:756: warning: implicit declaration of
function `offsetof'
pg_filedump.c:756: error: `t_bits' undeclared (first
use in this function)
pg_filedump.c:761: error: `HEAP_HASNULL' undeclared
(first use in this function)
pg_filedump.c:763: error: `HEAP_HASVARWIDTH'
undeclared (first use in this funct
ion)
pg_filedump.c:765: error: `HEAP_HASEXTERNAL'
undeclared (first use in this funct
ion)
pg_filedump.c:767: error: `HEAP_HASCOMPRESSED'
undeclared (first use in this fun
ction)
pg_filedump.c:769: error: `HEAP_HASOID' undeclared
(first use in this function)
pg_filedump.c:771: error: `HEAP_XMAX_IS_XMIN'
undeclared (first use in this func
tion)
pg_filedump.c:773: error: `HEAP_XMAX_UNLOGGED'
undeclared (first use in this fun
ction)
pg_filedump.c:775: error: `HEAP_XMIN_COMMITTED'
undeclared (first use in this fu
nction)
pg_filedump.c:777: error: `HEAP_XMIN_INVALID'
undeclared (first use in this func
tion)
pg_filedump.c:779: error: `HEAP_XMAX_COMMITTED'
undeclared (first use in this fu
nction)
pg_filedump.c:781: error: `HEAP_XMAX_INVALID'
undeclared (first use in this func
tion)
pg_filedump.c:783: error: `HEAP_MARKED_FOR_UPDATE'
undeclared (first use in this
function)
pg_filedump.c:785: error: `HEAP_UPDATED' undeclared
(first use in this function)
pg_filedump.c:787: error: `HEAP_MOVED_OFF' undeclared
(first use in this functio
n)
pg_filedump.c:789: error: `HEAP_MOVED_IN' undeclared
(first use in this function
)
pg_filedump.c:799: warning: implicit declaration of
function `BITMAPLEN'
pg_filedump.c:804: error: `Oid' undeclared (first use
in this function)
pg_filedump.c: In function `FormatSpecial':
pg_filedump.c:838: error: `PageHeader' undeclared
(first use in this function)
pg_filedump.c:838: error: parse error before
"pageHeader"
pg_filedump.c:840: error: `pageHeader' undeclared
(first use in this function)
pg_filedump.c:864: error: `F_LEAF' undeclared (first
use in this function)
pg_filedump.c:871: error: `BTPageOpaque' undeclared
(first use in this function)
pg_filedump.c:871: error: parse error before
"btreeSection"
pg_filedump.c:872: error: `btreeSection' undeclared
(first use in this function)
pg_filedump.c:872: error: `BTP_LEAF' undeclared (first
use in this function)
pg_filedump.c:874: error: `BTP_ROOT' undeclared (first
use in this function)
pg_filedump.c:876: error: `BTP_DELETED' undeclared
(first use in this function)
pg_filedump.c:878: error: `BTP_META' undeclared (first
use in this function)
pg_filedump.c:880: error: `BTP_HALF_DEAD' undeclared
(first use in this function
)
pg_filedump.c:899: error: `HashPageOpaque' undeclared
(first use in this functio
n)
pg_filedump.c:899: error: parse error before
"hashSection"
pg_filedump.c:901: error: `hashSection' undeclared
(first use in this function)
pg_filedump.c:901: error: `LH_UNUSED_PAGE' undeclared
(first use in this functio
n)
pg_filedump.c:903: error: `LH_OVERFLOW_PAGE'
undeclared (first use in this funct
ion)
pg_filedump.c:905: error: `LH_BUCKET_PAGE' undeclared
(first use in this functio
n)
pg_filedump.c:907: error: `LH_BITMAP_PAGE' undeclared
(first use in this functio
n)
pg_filedump.c:909: error: `LH_META_PAGE' undeclared
(first use in this function)
pg_filedump.c: In function `FormatBlock':
pg_filedump.c:944: error: `Page' undeclared (first use
in this function)
pg_filedump.c:944: error: parse error before "page"
pg_filedump.c:946: error: `page' undeclared (first use
in this function)
pg_filedump.c: In function `FormatControl':
pg_filedump.c:986: error: `ControlFileData' undeclared
(first use in this functi
on)
pg_filedump.c:986: error: `catalog_version_no'
undeclared (first use in this fun
ction)
pg_filedump.c:987: error: parse error before ')' token
pg_filedump.c:1000: error: `controlData' undeclared
(first use in this function)
pg_filedump.c:1000: error: parse error before ')'
token
pg_filedump.c:1001: error: `crc64' undeclared (first
use in this function)
pg_filedump.c:1002: error: `CheckPoint' undeclared
(first use in this function)
pg_filedump.c:1002: error: `checkPoint' undeclared
(first use in this function)
pg_filedump.c:1006: warning: implicit declaration of
function `INIT_CRC64'
pg_filedump.c:1006: error: `crcLocal' undeclared
(first use in this function)
pg_filedump.c:1007: warning: implicit declaration of
function `COMP_CRC64'
pg_filedump.c:1009: warning: implicit declaration of
function `FIN_CRC64'
pg_filedump.c:1014: error: `DB_STARTUP' undeclared
(first use in this function)
pg_filedump.c:1017: error: `DB_SHUTDOWNED' undeclared
(first use in this functio
n)
pg_filedump.c:1020: error: `DB_SHUTDOWNING' undeclared
(first use in this functi
on)
pg_filedump.c:1023: error: `DB_IN_RECOVERY' undeclared
(first use in this functi
on)
pg_filedump.c:1026: error: `DB_IN_PRODUCTION'
undeclared (first use in this func

tion)
pg_filedump.c:1057: warning: implicit declaration of
function `EQ_CRC64'
pg_filedump.c: In function `DumpFileContents':
pg_filedump.c:1205: error: `false' undeclared (first
use in this function)
pg_filedump.c: In function `main':
pg_filedump.c:1253: error: `ControlFileData'
undeclared (first use in this funct

ion)
pg_filedump.c:1262: warning: implicit declaration of
function `malloc'
pg_filedump.c:1276: warning: implicit declaration of
function `free'
pg_filedump.c:1278: warning: implicit declaration of
function `exit'
make: *** [pg_filedump.o] Error 1
a5s111pc35:/usr/local/src/postgresql-7.4.2/contrib/pg_filedump-3.0
#

______________________________________________
Renovamos el Correo Yahoo!: ¡100 MB GRATIS!
Nuevos servicios, más seguridad
http://correo.yahoo.es