[Pgcluster-general] pgcluster 1.7.0rc5, load balancer and pgreplicate
Monde Hans
mhans at fnb.co.za
Mon Jun 18 12:16:02 UTC 2007
Thanx sir,
here is the log.
On Mon, 2007-06-18 at 14:24 +0200, a.mitani at sra-europe.com wrote:
> Hi Hans,
> 2007-06-18 11:36:40 [4705] DEBUG:sem_lock [1] got it
2007-06-18 11:36:40 [4705] DEBUG:source host
2007-06-18 11:36:40 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:36:40 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 11:36:40 [4705] DEBUG:end thread_send_source()
2007-06-18 11:36:40 [4705] DEBUG:sem_unlock[1]
2007-06-18 11:39:13 [6602] DEBUG:PGRdo_replicate():query :: CREATE
DATABASE testdb TEMPLATE template0
2007-06-18 11:39:13 [6602] DEBUG:cmdSts=Q
2007-06-18 11:39:13 [6602] DEBUG:cmdType=O
2007-06-18 11:39:13 [6602] DEBUG:rlog=0
2007-06-18 11:39:13 [6602] DEBUG:port=5432
2007-06-18 11:39:13 [6602] DEBUG:pid=6601
2007-06-18 11:39:13 [6602] DEBUG:from_host=10.203.44.89
2007-06-18 11:39:13 [6602] DEBUG:dbName=postgres
2007-06-18 11:39:13 [6602] DEBUG:userName=postgres
2007-06-18 11:39:13 [6602] DEBUG:recieve sec=1182159553
2007-06-18 11:39:13 [6602] DEBUG:recieve usec=131765
2007-06-18 11:39:13 [6602] DEBUG:query_size=41
2007-06-18 11:39:13 [6602] DEBUG:request_id=1
2007-06-18 11:39:13 [6602] DEBUG:replicate_id=0
2007-06-18 11:39:13 [6602] DEBUG:recovery_status=0
2007-06-18 11:39:13 [6602] DEBUG:query=CREATE DATABASE testdb TEMPLATE
template0
2007-06-18 11:39:13 [6602] DEBUG:sem_lock [1] req
2007-06-18 11:39:13 [6602] DEBUG:sem_lock [1] got it
2007-06-18 11:39:13 [6602] DEBUG:source host
2007-06-18 11:39:13 [6602] DEBUG:end thread_send_source()
2007-06-18 11:39:13 [6602] DEBUG:sem_unlock[1]
2007-06-18 11:39:20 [6602] DEBUG:PGRdo_replicate():query ::
PGR_CLOSE_CONNECTION
2007-06-18 11:39:20 [6602] DEBUG:cmdSts=O
2007-06-18 11:39:20 [6602] DEBUG:cmdType=x
2007-06-18 11:39:20 [6602] DEBUG:rlog=0
2007-06-18 11:39:20 [6602] DEBUG:port=5432
2007-06-18 11:39:20 [6602] DEBUG:pid=6601
2007-06-18 11:39:20 [6602] DEBUG:from_host=10.203.44.89
2007-06-18 11:39:20 [6602] DEBUG:dbName=postgres
2007-06-18 11:39:20 [6602] DEBUG:userName=postgres
2007-06-18 11:39:20 [6602] DEBUG:recieve sec=1182159560
2007-06-18 11:39:20 [6602] DEBUG:recieve usec=106252
2007-06-18 11:39:20 [6602] DEBUG:query_size=21
2007-06-18 11:39:20 [6602] DEBUG:request_id=1
2007-06-18 11:39:20 [6602] DEBUG:replicate_id=0
2007-06-18 11:39:20 [6602] DEBUG:recovery_status=0
2007-06-18 11:39:20 [6602] DEBUG:query=PGR_CLOSE_CONNECTION
2007-06-18 11:39:20 [6602] DEBUG:sem_lock [1] req
2007-06-18 11:39:20 [6602] DEBUG:sem_lock [1] got it
2007-06-18 11:39:20 [6602] DEBUG:source host
2007-06-18 11:39:20 [6602] DEBUG:sem_unlock[1]
2007-06-18 11:39:57 [4705] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:39:57 [4705] DEBUG:cmdSts=Q
2007-06-18 11:39:57 [4705] DEBUG:cmdType=S
2007-06-18 11:39:57 [4705] DEBUG:rlog=0
2007-06-18 11:39:57 [4705] DEBUG:port=5432
2007-06-18 11:39:57 [4705] DEBUG:pid=4704
2007-06-18 11:39:57 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 11:39:57 [4705] DEBUG:dbName=postgres
2007-06-18 11:39:57 [4705] DEBUG:userName=postgres
2007-06-18 11:39:57 [4705] DEBUG:recieve sec=1182159597
2007-06-18 11:39:57 [4705] DEBUG:recieve usec=354211
2007-06-18 11:39:57 [4705] DEBUG:query_size=306
2007-06-18 11:39:57 [4705] DEBUG:request_id=45
2007-06-18 11:39:57 [4705] DEBUG:replicate_id=0
2007-06-18 11:39:57 [4705] DEBUG:recovery_status=0
2007-06-18 11:39:57 [4705] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:39:57 [4705] DEBUG:sem_lock [1] req
2007-06-18 11:39:57 [4705] DEBUG:sem_lock [1] got it
2007-06-18 11:39:57 [4705] DEBUG:source host
2007-06-18 11:39:57 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:39:57 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 11:39:57 [4705] DEBUG:end thread_send_source()
2007-06-18 11:39:57 [4705] DEBUG:sem_unlock[1]
2007-06-18 11:39:59 [6621] DEBUG:PGRdo_replicate():query :: SET
DateStyle=ISO
2007-06-18 11:39:59 [6621] DEBUG:cmdSts=Q
2007-06-18 11:39:59 [6621] DEBUG:cmdType=T
2007-06-18 11:39:59 [6621] DEBUG:rlog=0
2007-06-18 11:39:59 [6621] DEBUG:port=5432
2007-06-18 11:39:59 [6621] DEBUG:pid=6620
2007-06-18 11:39:59 [6621] DEBUG:from_host=10.203.44.89
2007-06-18 11:39:59 [6621] DEBUG:dbName=testdb
2007-06-18 11:39:59 [6621] DEBUG:userName=postgres
2007-06-18 11:39:59 [6621] DEBUG:recieve sec=1182159599
2007-06-18 11:39:59 [6621] DEBUG:recieve usec=143258
2007-06-18 11:39:59 [6621] DEBUG:query_size=17
2007-06-18 11:39:59 [6621] DEBUG:request_id=1
2007-06-18 11:39:59 [6621] DEBUG:replicate_id=0
2007-06-18 11:39:59 [6621] DEBUG:recovery_status=0
2007-06-18 11:39:59 [6621] DEBUG:query=SET DateStyle=ISO
2007-06-18 11:39:59 [6621] DEBUG:sem_lock [1] req
2007-06-18 11:39:59 [6621] DEBUG:sem_lock [1] got it
2007-06-18 11:39:59 [6621] DEBUG:source host
2007-06-18 11:39:59 [6621] DEBUG:end thread_send_source()
2007-06-18 11:39:59 [6621] DEBUG:sem_unlock[1]
2007-06-18 11:39:59 [6621] DEBUG:PGRdo_replicate():query :: set
client_encoding to 'UNICODE'
2007-06-18 11:39:59 [6621] DEBUG:cmdSts=Q
2007-06-18 11:39:59 [6621] DEBUG:cmdType=T
2007-06-18 11:39:59 [6621] DEBUG:rlog=0
2007-06-18 11:39:59 [6621] DEBUG:port=5432
2007-06-18 11:39:59 [6621] DEBUG:pid=6620
2007-06-18 11:39:59 [6621] DEBUG:from_host=10.203.44.89
2007-06-18 11:39:59 [6621] DEBUG:dbName=testdb
2007-06-18 11:39:59 [6621] DEBUG:userName=postgres
2007-06-18 11:39:59 [6621] DEBUG:recieve sec=1182159599
2007-06-18 11:39:59 [6621] DEBUG:recieve usec=151030
2007-06-18 11:39:59 [6621] DEBUG:query_size=32
2007-06-18 11:39:59 [6621] DEBUG:request_id=2
2007-06-18 11:39:59 [6621] DEBUG:replicate_id=0
2007-06-18 11:39:59 [6621] DEBUG:recovery_status=0
2007-06-18 11:39:59 [6621] DEBUG:query=set client_encoding to 'UNICODE'
2007-06-18 11:39:59 [6621] DEBUG:sem_lock [1] req
2007-06-18 11:39:59 [6621] DEBUG:sem_lock [1] got it
2007-06-18 11:39:59 [6621] DEBUG:source host
2007-06-18 11:39:59 [6621] DEBUG:end thread_send_source()
2007-06-18 11:39:59 [6621] DEBUG:sem_unlock[1]
2007-06-18 11:39:59 [6621] DEBUG:PGRdo_replicate():query :: SELECT CASE
WHEN nspname LIKE E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 11:39:59 [6621] DEBUG:cmdSts=Q
2007-06-18 11:39:59 [6621] DEBUG:cmdType=S
2007-06-18 11:39:59 [6621] DEBUG:rlog=0
2007-06-18 11:39:59 [6621] DEBUG:port=5432
2007-06-18 11:39:59 [6621] DEBUG:pid=6620
2007-06-18 11:39:59 [6621] DEBUG:from_host=10.203.44.89
2007-06-18 11:39:59 [6621] DEBUG:dbName=testdb
2007-06-18 11:39:59 [6621] DEBUG:userName=postgres
2007-06-18 11:39:59 [6621] DEBUG:recieve sec=1182159599
2007-06-18 11:39:59 [6621] DEBUG:recieve usec=178991
2007-06-18 11:39:59 [6621] DEBUG:query_size=426
2007-06-18 11:39:59 [6621] DEBUG:request_id=3
2007-06-18 11:39:59 [6621] DEBUG:replicate_id=0
2007-06-18 11:39:59 [6621] DEBUG:recovery_status=0
2007-06-18 11:39:59 [6621] DEBUG:query=SELECT CASE WHEN nspname LIKE
E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 11:39:59 [6621] DEBUG:sem_lock [1] req
2007-06-18 11:39:59 [6621] DEBUG:sem_lock [1] got it
2007-06-18 11:39:59 [6621] DEBUG:source host
2007-06-18 11:39:59 [6621]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:39:59 [6621] DEBUG:read_answer():QUERY DONE
2007-06-18 11:39:59 [6621] DEBUG:end thread_send_source()
2007-06-18 11:39:59 [6621] DEBUG:sem_unlock[1]
2007-06-18 11:40:06 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:06 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:06 [5507] DEBUG:cmdType=S
2007-06-18 11:40:06 [5507] DEBUG:rlog=0
2007-06-18 11:40:06 [5507] DEBUG:port=5432
2007-06-18 11:40:06 [5507] DEBUG:pid=21167
2007-06-18 11:40:06 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:06 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:06 [5507] DEBUG:userName=postgres
2007-06-18 11:40:06 [5507] DEBUG:recieve sec=1182159606
2007-06-18 11:40:06 [5507] DEBUG:recieve usec=88170
2007-06-18 11:40:06 [5507] DEBUG:query_size=306
2007-06-18 11:40:06 [5507] DEBUG:request_id=9
2007-06-18 11:40:06 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:06 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:06 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:06 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:06 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:06 [5507] DEBUG:source host
2007-06-18 11:40:06 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:06 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:06 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:06 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:06 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:06 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:06 [5507] DEBUG:cmdType=S
2007-06-18 11:40:06 [5507] DEBUG:rlog=0
2007-06-18 11:40:06 [5507] DEBUG:port=5432
2007-06-18 11:40:06 [5507] DEBUG:pid=21167
2007-06-18 11:40:06 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:06 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:06 [5507] DEBUG:userName=postgres
2007-06-18 11:40:06 [5507] DEBUG:recieve sec=1182159606
2007-06-18 11:40:06 [5507] DEBUG:recieve usec=662371
2007-06-18 11:40:06 [5507] DEBUG:query_size=306
2007-06-18 11:40:06 [5507] DEBUG:request_id=10
2007-06-18 11:40:06 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:06 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:06 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:06 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:06 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:06 [5507] DEBUG:source host
2007-06-18 11:40:06 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:06 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:06 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:06 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:06 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:06 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:06 [5507] DEBUG:cmdType=S
2007-06-18 11:40:06 [5507] DEBUG:rlog=0
2007-06-18 11:40:06 [5507] DEBUG:port=5432
2007-06-18 11:40:06 [5507] DEBUG:pid=21167
2007-06-18 11:40:06 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:06 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:06 [5507] DEBUG:userName=postgres
2007-06-18 11:40:06 [5507] DEBUG:recieve sec=1182159606
2007-06-18 11:40:06 [5507] DEBUG:recieve usec=982705
2007-06-18 11:40:06 [5507] DEBUG:query_size=306
2007-06-18 11:40:06 [5507] DEBUG:request_id=11
2007-06-18 11:40:06 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:06 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:06 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:06 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:06 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:06 [5507] DEBUG:source host
2007-06-18 11:40:06 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:06 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:06 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:06 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:07 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:07 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:07 [5507] DEBUG:cmdType=S
2007-06-18 11:40:07 [5507] DEBUG:rlog=0
2007-06-18 11:40:07 [5507] DEBUG:port=5432
2007-06-18 11:40:07 [5507] DEBUG:pid=21167
2007-06-18 11:40:07 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:07 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:07 [5507] DEBUG:userName=postgres
2007-06-18 11:40:07 [5507] DEBUG:recieve sec=1182159607
2007-06-18 11:40:07 [5507] DEBUG:recieve usec=158612
2007-06-18 11:40:07 [5507] DEBUG:query_size=306
2007-06-18 11:40:07 [5507] DEBUG:request_id=12
2007-06-18 11:40:07 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:07 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:07 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:07 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:07 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:07 [5507] DEBUG:source host
2007-06-18 11:40:07 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:07 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:07 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:07 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:07 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:07 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:07 [5507] DEBUG:cmdType=S
2007-06-18 11:40:07 [5507] DEBUG:rlog=0
2007-06-18 11:40:07 [5507] DEBUG:port=5432
2007-06-18 11:40:07 [5507] DEBUG:pid=21167
2007-06-18 11:40:07 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:07 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:07 [5507] DEBUG:userName=postgres
2007-06-18 11:40:07 [5507] DEBUG:recieve sec=1182159607
2007-06-18 11:40:07 [5507] DEBUG:recieve usec=334525
2007-06-18 11:40:07 [5507] DEBUG:query_size=306
2007-06-18 11:40:07 [5507] DEBUG:request_id=13
2007-06-18 11:40:07 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:07 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:07 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:07 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:07 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:07 [5507] DEBUG:source host
2007-06-18 11:40:07 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:07 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:07 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:07 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:07 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:07 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:07 [5507] DEBUG:cmdType=S
2007-06-18 11:40:07 [5507] DEBUG:rlog=0
2007-06-18 11:40:07 [5507] DEBUG:port=5432
2007-06-18 11:40:07 [5507] DEBUG:pid=21167
2007-06-18 11:40:07 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:07 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:07 [5507] DEBUG:userName=postgres
2007-06-18 11:40:07 [5507] DEBUG:recieve sec=1182159607
2007-06-18 11:40:07 [5507] DEBUG:recieve usec=518924
2007-06-18 11:40:07 [5507] DEBUG:query_size=306
2007-06-18 11:40:07 [5507] DEBUG:request_id=14
2007-06-18 11:40:07 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:07 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:07 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:07 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:07 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:07 [5507] DEBUG:source host
2007-06-18 11:40:07 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:07 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:07 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:07 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:07 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:07 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:07 [5507] DEBUG:cmdType=S
2007-06-18 11:40:07 [5507] DEBUG:rlog=0
2007-06-18 11:40:07 [5507] DEBUG:port=5432
2007-06-18 11:40:07 [5507] DEBUG:pid=21167
2007-06-18 11:40:07 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:07 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:07 [5507] DEBUG:userName=postgres
2007-06-18 11:40:07 [5507] DEBUG:recieve sec=1182159607
2007-06-18 11:40:07 [5507] DEBUG:recieve usec=702829
2007-06-18 11:40:07 [5507] DEBUG:query_size=306
2007-06-18 11:40:07 [5507] DEBUG:request_id=15
2007-06-18 11:40:07 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:07 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:07 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:07 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:07 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:07 [5507] DEBUG:source host
2007-06-18 11:40:07 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:07 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:07 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:07 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:10 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:10 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:10 [5507] DEBUG:cmdType=S
2007-06-18 11:40:10 [5507] DEBUG:rlog=0
2007-06-18 11:40:10 [5507] DEBUG:port=5432
2007-06-18 11:40:10 [5507] DEBUG:pid=21167
2007-06-18 11:40:10 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:10 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:10 [5507] DEBUG:userName=postgres
2007-06-18 11:40:10 [5507] DEBUG:recieve sec=1182159610
2007-06-18 11:40:10 [5507] DEBUG:recieve usec=602829
2007-06-18 11:40:10 [5507] DEBUG:query_size=306
2007-06-18 11:40:10 [5507] DEBUG:request_id=16
2007-06-18 11:40:10 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:10 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:10 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:10 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:10 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:10 [5507] DEBUG:source host
2007-06-18 11:40:10 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:10 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:10 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:10 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:11 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:11 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:11 [5507] DEBUG:cmdType=S
2007-06-18 11:40:11 [5507] DEBUG:rlog=0
2007-06-18 11:40:11 [5507] DEBUG:port=5432
2007-06-18 11:40:11 [5507] DEBUG:pid=21167
2007-06-18 11:40:11 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:11 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:11 [5507] DEBUG:userName=postgres
2007-06-18 11:40:11 [5507] DEBUG:recieve sec=1182159611
2007-06-18 11:40:11 [5507] DEBUG:recieve usec=71588
2007-06-18 11:40:11 [5507] DEBUG:query_size=306
2007-06-18 11:40:11 [5507] DEBUG:request_id=17
2007-06-18 11:40:11 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:11 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:11 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:11 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:11 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:11 [5507] DEBUG:source host
2007-06-18 11:40:11 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:11 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:11 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:11 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:12 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:12 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:12 [5507] DEBUG:cmdType=S
2007-06-18 11:40:12 [5507] DEBUG:rlog=0
2007-06-18 11:40:12 [5507] DEBUG:port=5432
2007-06-18 11:40:12 [5507] DEBUG:pid=21167
2007-06-18 11:40:12 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:12 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:12 [5507] DEBUG:userName=postgres
2007-06-18 11:40:12 [5507] DEBUG:recieve sec=1182159612
2007-06-18 11:40:12 [5507] DEBUG:recieve usec=583300
2007-06-18 11:40:12 [5507] DEBUG:query_size=306
2007-06-18 11:40:12 [5507] DEBUG:request_id=18
2007-06-18 11:40:12 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:12 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:12 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:12 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:12 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:12 [5507] DEBUG:source host
2007-06-18 11:40:12 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:12 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:12 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:12 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:12 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:12 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:12 [5507] DEBUG:cmdType=S
2007-06-18 11:40:12 [5507] DEBUG:rlog=0
2007-06-18 11:40:12 [5507] DEBUG:port=5432
2007-06-18 11:40:12 [5507] DEBUG:pid=21167
2007-06-18 11:40:12 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:12 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:12 [5507] DEBUG:userName=postgres
2007-06-18 11:40:12 [5507] DEBUG:recieve sec=1182159612
2007-06-18 11:40:12 [5507] DEBUG:recieve usec=871153
2007-06-18 11:40:12 [5507] DEBUG:query_size=306
2007-06-18 11:40:12 [5507] DEBUG:request_id=19
2007-06-18 11:40:12 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:12 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:12 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:12 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:12 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:12 [5507] DEBUG:source host
2007-06-18 11:40:12 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:12 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:12 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:12 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:44 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:44 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:44 [5507] DEBUG:cmdType=S
2007-06-18 11:40:44 [5507] DEBUG:rlog=0
2007-06-18 11:40:44 [5507] DEBUG:port=5432
2007-06-18 11:40:44 [5507] DEBUG:pid=21167
2007-06-18 11:40:44 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:44 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:44 [5507] DEBUG:userName=postgres
2007-06-18 11:40:44 [5507] DEBUG:recieve sec=1182159644
2007-06-18 11:40:44 [5507] DEBUG:recieve usec=113471
2007-06-18 11:40:44 [5507] DEBUG:query_size=306
2007-06-18 11:40:44 [5507] DEBUG:request_id=20
2007-06-18 11:40:44 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:44 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:44 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:44 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:44 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:44 [5507] DEBUG:source host
2007-06-18 11:40:44 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:44 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:44 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:44 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:40:44 [5507] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:44 [5507] DEBUG:cmdSts=Q
2007-06-18 11:40:44 [5507] DEBUG:cmdType=S
2007-06-18 11:40:44 [5507] DEBUG:rlog=0
2007-06-18 11:40:44 [5507] DEBUG:port=5432
2007-06-18 11:40:44 [5507] DEBUG:pid=21167
2007-06-18 11:40:44 [5507] DEBUG:from_host=10.203.44.89
2007-06-18 11:40:44 [5507] DEBUG:dbName=postgres
2007-06-18 11:40:44 [5507] DEBUG:userName=postgres
2007-06-18 11:40:44 [5507] DEBUG:recieve sec=1182159644
2007-06-18 11:40:44 [5507] DEBUG:recieve usec=649192
2007-06-18 11:40:44 [5507] DEBUG:query_size=306
2007-06-18 11:40:44 [5507] DEBUG:request_id=21
2007-06-18 11:40:44 [5507] DEBUG:replicate_id=0
2007-06-18 11:40:44 [5507] DEBUG:recovery_status=0
2007-06-18 11:40:44 [5507] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 11:40:44 [5507] DEBUG:sem_lock [1] req
2007-06-18 11:40:44 [5507] DEBUG:sem_lock [1] got it
2007-06-18 11:40:44 [5507] DEBUG:source host
2007-06-18 11:40:44 [5507]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 11:40:44 [5507] DEBUG:read_answer():QUERY DONE
2007-06-18 11:40:44 [5507] DEBUG:end thread_send_source()
2007-06-18 11:40:44 [5507] DEBUG:sem_unlock[1]
2007-06-18 11:58:46 [6621] DEBUG:PGRdo_replicate():query :: CREATE TABLE
"testTB"
(
) WITHOUT OIDS
2007-06-18 11:58:46 [6621] DEBUG:cmdSts=Q
2007-06-18 11:58:46 [6621] DEBUG:cmdType=O
2007-06-18 11:58:46 [6621] DEBUG:rlog=0
2007-06-18 11:58:46 [6621] DEBUG:port=5432
2007-06-18 11:58:46 [6621] DEBUG:pid=6620
2007-06-18 11:58:46 [6621] DEBUG:from_host=10.203.44.89
2007-06-18 11:58:46 [6621] DEBUG:dbName=testdb
2007-06-18 11:58:46 [6621] DEBUG:userName=postgres
2007-06-18 11:58:46 [6621] DEBUG:recieve sec=1182160726
2007-06-18 11:58:46 [6621] DEBUG:recieve usec=195500
2007-06-18 11:58:46 [6621] DEBUG:query_size=38
2007-06-18 11:58:46 [6621] DEBUG:request_id=4
2007-06-18 11:58:46 [6621] DEBUG:replicate_id=0
2007-06-18 11:58:46 [6621] DEBUG:recovery_status=0
2007-06-18 11:58:46 [6621] DEBUG:query=CREATE TABLE "testTB"
(
) WITHOUT OIDS
2007-06-18 11:58:46 [6621] DEBUG:sem_lock [1] req
2007-06-18 11:58:46 [6621] DEBUG:sem_lock [1] got it
2007-06-18 11:58:46 [6621] DEBUG:source host
2007-06-18 11:58:46 [6621] DEBUG:end thread_send_source()
2007-06-18 11:58:46 [6621] DEBUG:sem_unlock[1]
2007-06-18 11:59:01 [6621] DEBUG:PGRdo_replicate():query :: ALTER TABLE
"testTB"
ADD COLUMN testc "char"
2007-06-18 11:59:01 [6621] DEBUG:cmdSts=Q
2007-06-18 11:59:01 [6621] DEBUG:cmdType=O
2007-06-18 11:59:01 [6621] DEBUG:rlog=0
2007-06-18 11:59:01 [6621] DEBUG:port=5432
2007-06-18 11:59:01 [6621] DEBUG:pid=6620
2007-06-18 11:59:01 [6621] DEBUG:from_host=10.203.44.89
2007-06-18 11:59:01 [6621] DEBUG:dbName=testdb
2007-06-18 11:59:01 [6621] DEBUG:userName=postgres
2007-06-18 11:59:01 [6621] DEBUG:recieve sec=1182160741
2007-06-18 11:59:01 [6621] DEBUG:recieve usec=580310
2007-06-18 11:59:01 [6621] DEBUG:query_size=47
2007-06-18 11:59:01 [6621] DEBUG:request_id=5
2007-06-18 11:59:01 [6621] DEBUG:replicate_id=0
2007-06-18 11:59:01 [6621] DEBUG:recovery_status=0
2007-06-18 11:59:01 [6621] DEBUG:query=ALTER TABLE "testTB"
ADD COLUMN testc "char"
2007-06-18 11:59:01 [6621] DEBUG:sem_lock [1] req
2007-06-18 11:59:01 [6621] DEBUG:sem_lock [1] got it
2007-06-18 11:59:01 [6621] DEBUG:source host
2007-06-18 11:59:01 [6621] DEBUG:end thread_send_source()
2007-06-18 11:59:01 [6621] DEBUG:sem_unlock[1]
2007-06-18 13:11:01 [4705] DEBUG:PGRdo_replicate():query :: SELECT CASE
WHEN nspname LIKE E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:11:01 [4705] DEBUG:cmdSts=Q
2007-06-18 13:11:01 [4705] DEBUG:cmdType=S
2007-06-18 13:11:01 [4705] DEBUG:rlog=0
2007-06-18 13:11:01 [4705] DEBUG:port=5432
2007-06-18 13:11:01 [4705] DEBUG:pid=4704
2007-06-18 13:11:01 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:11:01 [4705] DEBUG:dbName=postgres
2007-06-18 13:11:01 [4705] DEBUG:userName=postgres
2007-06-18 13:11:01 [4705] DEBUG:recieve sec=1182165061
2007-06-18 13:11:01 [4705] DEBUG:recieve usec=348836
2007-06-18 13:11:01 [4705] DEBUG:query_size=426
2007-06-18 13:11:01 [4705] DEBUG:request_id=46
2007-06-18 13:11:01 [4705] DEBUG:replicate_id=0
2007-06-18 13:11:01 [4705] DEBUG:recovery_status=0
2007-06-18 13:11:01 [4705] DEBUG:query=SELECT CASE WHEN nspname LIKE
E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:11:01 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:11:01 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:11:01 [4705] DEBUG:source host
2007-06-18 13:11:01 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:11:01 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:11:01 [4705] DEBUG:end thread_send_source()
2007-06-18 13:11:01 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:14:30 [4705] DEBUG:PGRdo_replicate():query :: DROP
DATABASE testdb
2007-06-18 13:14:30 [4705] DEBUG:cmdSts=Q
2007-06-18 13:14:30 [4705] DEBUG:cmdType=O
2007-06-18 13:14:30 [4705] DEBUG:rlog=0
2007-06-18 13:14:30 [4705] DEBUG:port=5432
2007-06-18 13:14:30 [4705] DEBUG:pid=4704
2007-06-18 13:14:30 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:14:30 [4705] DEBUG:dbName=postgres
2007-06-18 13:14:30 [4705] DEBUG:userName=postgres
2007-06-18 13:14:30 [4705] DEBUG:recieve sec=1182165270
2007-06-18 13:14:30 [4705] DEBUG:recieve usec=225046
2007-06-18 13:14:30 [4705] DEBUG:query_size=20
2007-06-18 13:14:30 [4705] DEBUG:request_id=47
2007-06-18 13:14:30 [4705] DEBUG:replicate_id=0
2007-06-18 13:14:30 [4705] DEBUG:recovery_status=0
2007-06-18 13:14:30 [4705] DEBUG:query=DROP DATABASE testdb
2007-06-18 13:14:30 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:14:30 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:14:30 [4705] DEBUG:source host
2007-06-18 13:14:30 [4705] DEBUG:end thread_send_source()
2007-06-18 13:14:30 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:14:30 [6621] DEBUG:PGRdo_replicate():query ::
PGR_CLOSE_CONNECTION
2007-06-18 13:14:30 [6621] DEBUG:cmdSts=O
2007-06-18 13:14:30 [6621] DEBUG:cmdType=x
2007-06-18 13:14:30 [6621] DEBUG:rlog=0
2007-06-18 13:14:30 [6621] DEBUG:port=5432
2007-06-18 13:14:30 [6621] DEBUG:pid=6620
2007-06-18 13:14:30 [6621] DEBUG:from_host=10.203.44.89
2007-06-18 13:14:30 [6621] DEBUG:dbName=testdb
2007-06-18 13:14:30 [6621] DEBUG:userName=postgres
2007-06-18 13:14:30 [6621] DEBUG:recieve sec=1182165270
2007-06-18 13:14:30 [6621] DEBUG:recieve usec=228790
2007-06-18 13:14:30 [6621] DEBUG:query_size=21
2007-06-18 13:14:30 [6621] DEBUG:request_id=1
2007-06-18 13:14:30 [6621] DEBUG:replicate_id=0
2007-06-18 13:14:30 [6621] DEBUG:recovery_status=0
2007-06-18 13:14:30 [6621] DEBUG:query=PGR_CLOSE_CONNECTION
2007-06-18 13:14:30 [6621] DEBUG:sem_lock [1] req
2007-06-18 13:14:30 [6621] DEBUG:sem_lock [1] got it
2007-06-18 13:14:30 [6621] DEBUG:source host
2007-06-18 13:14:30 [6621] DEBUG:sem_unlock[1]
2007-06-18 13:14:33 [4705] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 13:14:33 [4705] DEBUG:cmdSts=Q
2007-06-18 13:14:33 [4705] DEBUG:cmdType=S
2007-06-18 13:14:33 [4705] DEBUG:rlog=0
2007-06-18 13:14:33 [4705] DEBUG:port=5432
2007-06-18 13:14:33 [4705] DEBUG:pid=4704
2007-06-18 13:14:33 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:14:33 [4705] DEBUG:dbName=postgres
2007-06-18 13:14:33 [4705] DEBUG:userName=postgres
2007-06-18 13:14:33 [4705] DEBUG:recieve sec=1182165273
2007-06-18 13:14:33 [4705] DEBUG:recieve usec=668729
2007-06-18 13:14:33 [4705] DEBUG:query_size=306
2007-06-18 13:14:33 [4705] DEBUG:request_id=48
2007-06-18 13:14:33 [4705] DEBUG:replicate_id=0
2007-06-18 13:14:33 [4705] DEBUG:recovery_status=0
2007-06-18 13:14:33 [4705] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 13:14:33 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:14:33 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:14:33 [4705] DEBUG:source host
2007-06-18 13:14:33 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:14:33 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:14:33 [4705] DEBUG:end thread_send_source()
2007-06-18 13:14:33 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:14:35 [4705] DEBUG:PGRdo_replicate():query :: SELECT CASE
WHEN nspname LIKE E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:14:35 [4705] DEBUG:cmdSts=Q
2007-06-18 13:14:35 [4705] DEBUG:cmdType=S
2007-06-18 13:14:35 [4705] DEBUG:rlog=0
2007-06-18 13:14:35 [4705] DEBUG:port=5432
2007-06-18 13:14:35 [4705] DEBUG:pid=4704
2007-06-18 13:14:35 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:14:35 [4705] DEBUG:dbName=postgres
2007-06-18 13:14:35 [4705] DEBUG:userName=postgres
2007-06-18 13:14:35 [4705] DEBUG:recieve sec=1182165275
2007-06-18 13:14:35 [4705] DEBUG:recieve usec=233298
2007-06-18 13:14:35 [4705] DEBUG:query_size=426
2007-06-18 13:14:35 [4705] DEBUG:request_id=49
2007-06-18 13:14:35 [4705] DEBUG:replicate_id=0
2007-06-18 13:14:35 [4705] DEBUG:recovery_status=0
2007-06-18 13:14:35 [4705] DEBUG:query=SELECT CASE WHEN nspname LIKE
E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:14:35 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:14:35 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:14:35 [4705] DEBUG:source host
2007-06-18 13:14:35 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:14:35 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:14:35 [4705] DEBUG:end thread_send_source()
2007-06-18 13:14:35 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:14:37 [4705] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
WHERE db.oid=10819::oid
ORDER BY datname
2007-06-18 13:14:37 [4705] DEBUG:cmdSts=Q
2007-06-18 13:14:37 [4705] DEBUG:cmdType=S
2007-06-18 13:14:37 [4705] DEBUG:rlog=0
2007-06-18 13:14:37 [4705] DEBUG:port=5432
2007-06-18 13:14:37 [4705] DEBUG:pid=4704
2007-06-18 13:14:37 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:14:37 [4705] DEBUG:dbName=postgres
2007-06-18 13:14:37 [4705] DEBUG:userName=postgres
2007-06-18 13:14:37 [4705] DEBUG:recieve sec=1182165277
2007-06-18 13:14:37 [4705] DEBUG:recieve usec=740015
2007-06-18 13:14:37 [4705] DEBUG:query_size=331
2007-06-18 13:14:37 [4705] DEBUG:request_id=50
2007-06-18 13:14:37 [4705] DEBUG:replicate_id=0
2007-06-18 13:14:37 [4705] DEBUG:recovery_status=0
2007-06-18 13:14:37 [4705] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
WHERE db.oid=10819::oid
ORDER BY datname
2007-06-18 13:14:37 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:14:37 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:14:37 [4705] DEBUG:source host
2007-06-18 13:14:37 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:14:37 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:14:37 [4705] DEBUG:end thread_send_source()
2007-06-18 13:14:37 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:14:37 [4705] DEBUG:PGRdo_replicate():query :: SELECT CASE
WHEN nspname LIKE E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:14:37 [4705] DEBUG:cmdSts=Q
2007-06-18 13:14:37 [4705] DEBUG:cmdType=S
2007-06-18 13:14:37 [4705] DEBUG:rlog=0
2007-06-18 13:14:37 [4705] DEBUG:port=5432
2007-06-18 13:14:37 [4705] DEBUG:pid=4704
2007-06-18 13:14:37 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:14:37 [4705] DEBUG:dbName=postgres
2007-06-18 13:14:37 [4705] DEBUG:userName=postgres
2007-06-18 13:14:37 [4705] DEBUG:recieve sec=1182165277
2007-06-18 13:14:37 [4705] DEBUG:recieve usec=765717
2007-06-18 13:14:37 [4705] DEBUG:query_size=426
2007-06-18 13:14:37 [4705] DEBUG:request_id=51
2007-06-18 13:14:37 [4705] DEBUG:replicate_id=0
2007-06-18 13:14:37 [4705] DEBUG:recovery_status=0
2007-06-18 13:14:37 [4705] DEBUG:query=SELECT CASE WHEN nspname LIKE
E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:14:37 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:14:37 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:14:37 [4705] DEBUG:source host
2007-06-18 13:14:37 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:14:37 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:14:37 [4705] DEBUG:end thread_send_source()
2007-06-18 13:14:37 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:14:45 [4705] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 13:14:45 [4705] DEBUG:cmdSts=Q
2007-06-18 13:14:45 [4705] DEBUG:cmdType=S
2007-06-18 13:14:45 [4705] DEBUG:rlog=0
2007-06-18 13:14:45 [4705] DEBUG:port=5432
2007-06-18 13:14:45 [4705] DEBUG:pid=4704
2007-06-18 13:14:45 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:14:45 [4705] DEBUG:dbName=postgres
2007-06-18 13:14:45 [4705] DEBUG:userName=postgres
2007-06-18 13:14:45 [4705] DEBUG:recieve sec=1182165285
2007-06-18 13:14:45 [4705] DEBUG:recieve usec=605886
2007-06-18 13:14:45 [4705] DEBUG:query_size=306
2007-06-18 13:14:45 [4705] DEBUG:request_id=52
2007-06-18 13:14:45 [4705] DEBUG:replicate_id=0
2007-06-18 13:14:45 [4705] DEBUG:recovery_status=0
2007-06-18 13:14:45 [4705] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2007-06-18 13:14:45 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:14:45 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:14:45 [4705] DEBUG:source host
2007-06-18 13:14:45 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:14:45 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:14:45 [4705] DEBUG:end thread_send_source()
2007-06-18 13:14:45 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:16:40 [4705] DEBUG:PGRdo_replicate():query :: SELECT CASE
WHEN nspname LIKE E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:16:40 [4705] DEBUG:cmdSts=Q
2007-06-18 13:16:40 [4705] DEBUG:cmdType=S
2007-06-18 13:16:40 [4705] DEBUG:rlog=0
2007-06-18 13:16:40 [4705] DEBUG:port=5432
2007-06-18 13:16:40 [4705] DEBUG:pid=4704
2007-06-18 13:16:40 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:16:40 [4705] DEBUG:dbName=postgres
2007-06-18 13:16:40 [4705] DEBUG:userName=postgres
2007-06-18 13:16:40 [4705] DEBUG:recieve sec=1182165400
2007-06-18 13:16:40 [4705] DEBUG:recieve usec=124323
2007-06-18 13:16:40 [4705] DEBUG:query_size=426
2007-06-18 13:16:40 [4705] DEBUG:request_id=53
2007-06-18 13:16:40 [4705] DEBUG:replicate_id=0
2007-06-18 13:16:40 [4705] DEBUG:recovery_status=0
2007-06-18 13:16:40 [4705] DEBUG:query=SELECT CASE WHEN nspname LIKE
E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:16:40 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:16:40 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:16:40 [4705] DEBUG:source host
2007-06-18 13:16:40 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:16:40 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:16:40 [4705] DEBUG:end thread_send_source()
2007-06-18 13:16:40 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:36:12 [4705] DEBUG:PGRdo_replicate():query :: SELECT
db.oid, datname, spcname, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
WHERE db.oid=10819::oid
ORDER BY datname
2007-06-18 13:36:12 [4705] DEBUG:cmdSts=Q
2007-06-18 13:36:12 [4705] DEBUG:cmdType=S
2007-06-18 13:36:12 [4705] DEBUG:rlog=0
2007-06-18 13:36:12 [4705] DEBUG:port=5432
2007-06-18 13:36:12 [4705] DEBUG:pid=4704
2007-06-18 13:36:12 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:36:12 [4705] DEBUG:dbName=postgres
2007-06-18 13:36:12 [4705] DEBUG:userName=postgres
2007-06-18 13:36:12 [4705] DEBUG:recieve sec=1182166572
2007-06-18 13:36:12 [4705] DEBUG:recieve usec=415286
2007-06-18 13:36:12 [4705] DEBUG:query_size=331
2007-06-18 13:36:12 [4705] DEBUG:request_id=54
2007-06-18 13:36:12 [4705] DEBUG:replicate_id=0
2007-06-18 13:36:12 [4705] DEBUG:recovery_status=0
2007-06-18 13:36:12 [4705] DEBUG:query=SELECT db.oid, datname, spcname,
datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate
FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
WHERE db.oid=10819::oid
ORDER BY datname
2007-06-18 13:36:12 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:36:12 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:36:12 [4705] DEBUG:source host
2007-06-18 13:36:12 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:36:12 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:36:12 [4705] DEBUG:end thread_send_source()
2007-06-18 13:36:12 [4705] DEBUG:sem_unlock[1]
2007-06-18 13:36:12 [4705] DEBUG:PGRdo_replicate():query :: SELECT CASE
WHEN nspname LIKE E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:36:12 [4705] DEBUG:cmdSts=Q
2007-06-18 13:36:12 [4705] DEBUG:cmdType=S
2007-06-18 13:36:12 [4705] DEBUG:rlog=0
2007-06-18 13:36:12 [4705] DEBUG:port=5432
2007-06-18 13:36:12 [4705] DEBUG:pid=4704
2007-06-18 13:36:12 [4705] DEBUG:from_host=10.203.44.89
2007-06-18 13:36:12 [4705] DEBUG:dbName=postgres
2007-06-18 13:36:12 [4705] DEBUG:userName=postgres
2007-06-18 13:36:12 [4705] DEBUG:recieve sec=1182166572
2007-06-18 13:36:12 [4705] DEBUG:recieve usec=440728
2007-06-18 13:36:12 [4705] DEBUG:query_size=426
2007-06-18 13:36:12 [4705] DEBUG:request_id=55
2007-06-18 13:36:12 [4705] DEBUG:replicate_id=0
2007-06-18 13:36:12 [4705] DEBUG:recovery_status=0
2007-06-18 13:36:12 [4705] DEBUG:query=SELECT CASE WHEN nspname LIKE
E'pg\_temp\_%%' THEN 1
WHEN (nspname LIKE E'pg\_%' OR nspname =
'information_schema') THEN 0
ELSE 3 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS
namespaceowner, nspacl, description, has_schema_privilege(nsp.oid,
'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
ORDER BY 1, nspname
2007-06-18 13:36:12 [4705] DEBUG:sem_lock [1] req
2007-06-18 13:36:12 [4705] DEBUG:sem_lock [1] got it
2007-06-18 13:36:12 [4705] DEBUG:source host
2007-06-18 13:36:12 [4705]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 13:36:12 [4705] DEBUG:read_answer():QUERY DONE
2007-06-18 13:36:12 [4705] DEBUG:end thread_send_source()
2007-06-18 13:36:12 [4705] DEBUG:sem_unlock[1]
M.
> It seems that there is no problem in each configuration files.
> Would you show us the debug messages of replication server.
>
> You can see it when start replication server with debug option (-vn).
>
> Regards,
> --------------
> At.Mitani
>
>
> > Hi Guys I have the following setup with two servers.
> > My config files are as follows. I do not see any errors from the log
> > files but if I create a database on linux-uuv7 it does not show on
> > fcdatarp. and there are no errors on both servers what will I have to
> > change so that the changes can reflect.
> >
> >
> > #-------------------------------------------------------------
> > # file: pgreplicate.conf
> > #-------------------------------------------------------------
> > # A setup of Cluster DB(s)
> > #-------------------------------------------------------------
> > <Cluster_Server_Info>
> > <Host_Name> linux-uuv7 </Host_Name>
> > <Port> 5432 </Port>
> > <Recovery_Port> 7001 </Recovery_Port>
> > </Cluster_Server_Info>
> > <Cluster_Server_Info>
> > <Host_Name> fcdatarp </Host_Name>
> > <Port> 5432 </Port>
> > <Recovery_Port> 7001 </Recovery_Port>
> > </Cluster_Server_Info>
> > #--------------------------------------------------------------------
> > # A setup of loader balancer
> > #--------------------------------------------------------------------
> > <LoadBalance_Server_Info>
> > <Host_Name> linux-uuv7 </Host_Name>
> > <Recovery_Port> 6101 </Recovery_Port>
> > </LoadBalance_Server_Info>
> > <LoadBalance_Server_Info>
> > <Host_Name> fcdatarp </Host_Name>
> > <Recovery_Port> 6101 </Recovery_Port>
> > </LoadBalance_Server_Info>
> > #------------------------------------------------------------
> > # A setup of a replication server
> > #-------------------------------------------------------------
> > <Host_Name> linux-uuv7</Host_Name>
> > <Replication_Port>8001</Replication_Port>
> > <Recovery_Port>8101</Recovery_Port>
> > <RLOG_Port>8301</RLOG_Port>
> > <Response_Mode>normal</Response_Mode>
> > <Use_Replication_Log>no</Use_Replication_Log>
> > <Replication_Timeout>1min</Replication_Timeout>
> > <LifeCheck_Timeout>3s</LifeCheck_Timeout>
> > <LifeCheck_Interval>15s</LifeCheck_Interval>
> > #-------------------------------------------------------------
> > # A setup of a log files
> > #-------------------------------------------------------------
> > <Log_File_Info>
> > <File_Name> /var/log/postgresql/pgreplicate.log </File_Name>
> > <File_Size> 1M </File_Size>
> > <Rotate> 3 </Rotate>
> > </Log_File_Info>
> >
> >
> > #-------------------------------------------------------------
> > # file: pglb.conf
> > #-------------------------------------------------------------
> > # set cluster DB server information
> > #--------------------------------------------------------------------
> > <Cluster_Server_Info>
> > <Host_Name> linux-uuv7 </Host_Name>
> > <Port> 5432 </Port>
> > <Max_Connect> 30 </Max_Connect>
> > </Cluster_Server_Info>
> > <Cluster_Server_Info>
> > <Host_Name> fcdatarp </Host_Name>
> > <Port> 5432 </Port>
> > <Max_Connect> 30 </Max_Connect>
> > </Cluster_Server_Info>
> >
> > #-------------------------------------------------------------
> > # set Load Balance server information
> > #-------------------------------------------------------------
> > <Host_Name> linux-uuv7 </Host_Name>
> > <Backend_Socket_Dir> /tmp </Backend_Socket_Dir>
> > <Receive_Port> 5433 </Receive_Port>
> > <Recovery_Port> 6101 </Recovery_Port>
> > <Max_Cluster_Num> 128 </Max_Cluster_Num>
> > <Use_Connection_Pooling> no </Use_Connection_Pooling>
> > <LifeCheck_Timeout>3s</LifeCheck_Timeout>
> > <LifeCheck_Interval>15s</LifeCheck_Interval>
> > #-------------------------------------------------------------
> > # A setup of a log files
> > #-------------------------------------------------------------
> > <Log_File_Info>
> > <File_Name> /var/log/postgresql/pglb.log </File_Name>
> > <File_Size> 1M </File_Size>
> > <Rotate> 3 </Rotate>
> > </Log_File_Info>
> >
> > #============================================================
> > # Cluster DB Server configuration file
> > #------------------------------------------------------------
> > # file: cluster.conf
> > #------------------------------------------------------------
> > # This file controls:
> > # o which hosts & port are replication server
> > # o which port use for replication request to replication server
> > # o which command use for recovery function
> > #============================================================
> > #------------------------------------------------------------
> > # set Replication Server information
> > #o Host_Name : hostname
> > #o Port : connection for postmaster
> > #o Recovery_Port : connection for recovery process
> > #------------------------------------------------------------
> > <Replicate_Server_Info>
> > <Host_Name> linux-uuv7 </Host_Name>
> > <Port> 8001 </Port>
> > <Recovery_Port> 8101 </Recovery_Port>
> > </Replicate_Server_Info>
> > <Replicate_Server_Info>
> > <Host_Name> fcdatarp </Host_Name>
> > <Port> 8001 </Port>
> > <Recovery_Port> 8101 </Recovery_Port>
> > </Replicate_Server_Info>
> > #<Replicate_Server_Info>
> > #<Host_Name> replicate2.postgres.jp </Host_Name>
> > #<Port> 8002 </Port>
> > #<Recovery_Port> 8102 </Recovery_Port>
> > #</Replicate_Server_Info>
> > #<Replicate_Server_Info>
> > #<Host_Name> replicate3.postgres.jp </Host_Name>
> > #<Port> 8003 </Port>
> > #<Recovery_Port> 8103 </Recovery_Port>
> > #</Replicate_Server_Info>
> > #-------------------------------------------------------------
> > # set Cluster DB Server information
> > #o Host_Name : host name which connect with replication server
> > #o Recovery_Port : connection for recovery
> > #o Rsync_Path : path of rsync command
> > #o Rsync_Option : file transfer option for rsync
> > #o Rsync_Compress : use compression option for rsync
> > # [yes/no]. default : yes
> > #o Pg_Dump_Path : path of pg_dump
> > # o When_Stand_Alone : When all replication servers fell,
> > # you can set up two kinds of permittion,
> > # "real_only" or "read_write".
> > #o Replication_Timeout : timeout of each replication request
> > #o Lifecheck_Timeout : timeout of the lifecheck response
> > #o Lifecheck_Interval : interval time of the lifecheck
> > #(range 1s - 1h)
> > #10s-- 10 seconds
> > #10min-- 10 minutes
> > #1h-- 1 hours
> > #-------------------------------------------------------------
> > <Host_Name>linux-uuv7</Host_Name>
> > <Recovery_Port>7001</Recovery_Port>
> > <Rsync_Path>/usr/bin/rsync</Rsync_Path>
> > <Rsync_Option>ssh -1</Rsync_Option>
> > <Rsync_Compress>yes</Rsync_Compress>
> > <Pg_Dump_Path>/usr/local/pgsql/bin/pg_dump</Pg_Dump_Path>
> > <When_Stand_Alone>read_only</When_Stand_Alone>
> > <Replication_Timeout>1min</Replication_Timeout>
> > <LifeCheck_Timeout>3s</LifeCheck_Timeout>
> > <LifeCheck_Interval>11s</LifeCheck_Interval>
> > #-------------------------------------------------------------
> > # set partitional replicate control information
> > # set DB name and Table name to stop reprication
> > # o DB_Name : DB name
> > # o Table_Name : table name
> > #-------------------------------------------------------------
> > #<Not_Replicate_Info>
> > #<DB_Name> test_db </DB_Name>
> > #<Table_Name> log_table </Table_Name>
> > #</Not_Replicate_Info>
> >
> > M
> >
> >
> > To read FirstRand Bank's Disclaimer for this email click on the following
> > address or copy into your Internet browser:
> > https://www.fnb.co.za/disclaimer.html
> >
> > If you are unable to access the Disclaimer, send a blank e-mail to
> > firstrandbankdisclaimer at fnb.co.za and we will send you a copy of the
> > Disclaimer.
> > _______________________________________________
> > Pgcluster-general mailing list
> > Pgcluster-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgcluster-general
> >
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
To read FirstRand Bank's Disclaimer for this email click on the following address or copy into your Internet browser:
https://www.fnb.co.za/disclaimer.html
If you are unable to access the Disclaimer, send a blank e-mail to
firstrandbankdisclaimer at fnb.co.za and we will send you a copy of the Disclaimer.
More information about the Pgcluster-general
mailing list