#9 Can pg_rman use on EnterpriseDB Postgres Plus Standard Server/Postgres Plus Advnaced Server?

[Anonymous]

Originally created by: xiao.sha...@gmail.com

What steps will reproduce the problem?
1. PATH=$PATH:/opt/PostgresPlus/8.3R2/dbserver/bin
2. cd pg_rman
3. make USE_PGXS=1

What is the expected output? What do you see instead?
[enterprisedb@scott-nb pg_rman]$ make USE_PGXS=1
/usr/local/gcc41/bin/gcc -fPIC -O2 -Wall -Wmissing-prototypes
-Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing -fwrapv -I/opt/PostgresPlus/8.3R2AS/dbserver/include
-I. -I/opt/PostgresPlus/8.3R2AS/dbserver/include/server
-I/opt/PostgresPlus/8.3R2AS/dbserver/include/internal -D_GNU_SOURCE
-I/usr/include/libxml2  -I/usr/include/libxml2  -c -o data.o data.c
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:50,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/elog.h:30:1:
warning: "LOG" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:139:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:50,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/elog.h:35:1:
warning: "INFO" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:140:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:50,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/elog.h:41:1:
warning: "NOTICE" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:141:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:50,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/elog.h:44:1:
warning: "WARNING" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:142:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:50,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/elog.h:47:1:
warning: "ERROR" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:144:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:50,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/elog.h:56:1:
warning: "FATAL" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:145:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:50,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/elog.h:57:1:
warning: "PANIC" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:146:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:51,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/palloc.h:36: error:
redefinition of typedef ‘MemoryContext’
pgut/pgut.h:227: error: previous declaration of ‘MemoryContext’ was here
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:317: error:
redefinition of typedef ‘Datum’
pgut/pgut.h:226: error: previous declaration of ‘Datum’ was here
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:697:1:
warning: "Assert" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:172:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:698:1:
warning: "AssertMacro" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:174:1: warning: this is the location of the previous definition
In file included from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/access/dblinkam.h:14,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/nodes/parsenodes.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/utils/rel.h:27,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufmgr.h:18,
                 from
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/storage/bufpage.h:17,
                 from data.c:19:
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:699:1:
warning: "AssertArg" redefined
In file included from pg_rman.h:17,
                 from data.c:10:
pgut/pgut.h:173:1: warning: this is the location of the previous definition
/opt/PostgresPlus/8.3R2AS/dbserver/include/server/postgres.h:733: error:
redefinition of typedef ‘aclitem’
pgut/pgut.h:236: error: previous declaration of ‘aclitem’ was here
data.c: In function ‘parse_page’:
data.c:238: warning: implicit declaration of function ‘XLogRecPtrIsInvalid’
make: *** [data.o] Error 1

What version of the product are you using? On what operating system?
pg_rman v1.1.2
Postgres Plus Advanced Server 8.3 [r2]
Red Hat Enterprise Linux 5.4

Please provide any additional information below.

[Anonymous]

Originally posted by: itagaki....@gmail.com

I can build pg_rman in PostgreSQL 8.3, so Postgres Plus Advanced Server 8.3 might
be incompatible with PostgreSQL 8.3.

As far as your error message, the errors could be adjustable with just a few
adding some headers or additional version check, but I don't have PPAS environment.
Sorry, I cannot fix it, but patches welcome :)

Labels: Portability
Status: Accepted

[Anonymous]

Originally posted by: ragavend...@gmail.com

Hi,

Its very nice that pg_rman do has the same capability as in Oracle 10g. I have few
points want to clarify, please suggest me

1. In which catalog file the pg_rman information found. Which i can view in psql
prompt.

2. Why cannot we stop the running pg_rman service.(I have stopped the cluster, but
still pg_rman show, will display status as running)

3. What are files generated when the pg_rman command issued for full/incremental

4. Correct procedure to initialize the pg_rman catalog with init option

Thanks in advance

Regards
Raghavendra

[Anonymous]

Originally posted by: itagaki....@gmail.com

Please use a dedicated thread to ask different questions.

> 1. In which catalog file the pg_rman information found.
> Which i can view in psql prompt.
pg_rman doesn't use any RDBMS, but use text-based catalog.
So, you cannot view the catalog with SQL-based client (including psql).
I have a plan to store the catalog in DBMS, that might be another Postgres or SQLite.

> 2. Why cannot we stop the running pg_rman service.
> (I have stopped the cluster, but still pg_rman show, will display status as running)
The reason is same as 1. pg_rman doesn't access postgres to show the catalog.

> 3. What are files generated when the pg_rman command issued for full/incremental
Both of them are stored in $BACKUP_PATH/YYYY-MM-DD/HHMISS as separated files.

> 4. Correct procedure to initialize the pg_rman catalog with init option
It is "pg_rman init". It makes a directory. but doesn't create any tables.

As mentioned in 1, the catalog issue might be improved in the future release of
pg_rman (v2.0?).