[Pgcluster-general] pgcluster 1.7.0rc5, load balancer andpgreplicate
Monde Hans
mhans at fnb.co.za
Mon Jun 18 13:16:05 UTC 2007
I get this error when I try to create from the slave. But it goes on and
creates the databases on this only.
The Creation on the master worked and created on the slave(second db).
[postgres at fcdatarp bin]$ ./createdb testm321
createdb: database creation failed: ERROR: database "testm321" already
exists
[postgres at fcdatarp bin]$ ./createdb newdb123
createdb: database creation failed: ERROR: database "newdb123" already
exists
Here are the logs.
2007-06-18 15:09:31 [11785] DEBUG:dbName=postgres
2007-06-18 15:09:31 [11785] DEBUG:userName=postgres
2007-06-18 15:09:31 [11785] DEBUG:recieve sec=1182172171
2007-06-18 15:09:31 [11785] DEBUG:recieve usec=967803
2007-06-18 15:09:31 [11785] DEBUG:query_size=21
2007-06-18 15:09:31 [11785] DEBUG:request_id=1
2007-06-18 15:09:31 [11785] DEBUG:replicate_id=0
2007-06-18 15:09:31 [11785] DEBUG:recovery_status=0
2007-06-18 15:09:31 [11785] DEBUG:query=PGR_CLOSE_CONNECTION
2007-06-18 15:09:31 [11785] DEBUG:sem_lock [1] req
2007-06-18 15:09:31 [11785] DEBUG:sem_lock [1] got it
2007-06-18 15:09:31 [11785] DEBUG:source host
2007-06-18 15:09:31 [11785]
DEBUG:replicate_packet_send_internal():connect db:postgres port:5432
user:postgres host:fcdatarp query:PGR_CLOSE_CONNECTION
2007-06-18 15:09:31 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:09:31 [11785] DEBUG:sem_unlock[1]
2007-06-18 15:09:51 [11794] DEBUG:PGRdo_replicate():query :: CREATE
DATABASE newdb123
2007-06-18 15:09:51 [11794] DEBUG:cmdSts=Q
2007-06-18 15:09:51 [11794] DEBUG:cmdType=O
2007-06-18 15:09:51 [11794] DEBUG:rlog=0
2007-06-18 15:09:51 [11794] DEBUG:port=5432
2007-06-18 15:09:51 [11794] DEBUG:pid=22123
2007-06-18 15:09:51 [11794] DEBUG:from_host=10.203.44.89
2007-06-18 15:09:51 [11794] DEBUG:dbName=postgres
2007-06-18 15:09:51 [11794] DEBUG:userName=postgres
2007-06-18 15:09:51 [11794] DEBUG:recieve sec=1182172191
2007-06-18 15:09:51 [11794] DEBUG:recieve usec=527250
2007-06-18 15:09:51 [11794] DEBUG:query_size=24
2007-06-18 15:09:51 [11794] DEBUG:request_id=1
2007-06-18 15:09:51 [11794] DEBUG:replicate_id=0
2007-06-18 15:09:51 [11794] DEBUG:recovery_status=0
2007-06-18 15:09:51 [11794] DEBUG:query=CREATE DATABASE newdb123
2007-06-18 15:09:51 [11794] DEBUG:sem_lock [1] req
2007-06-18 15:09:51 [11794] DEBUG:sem_lock [1] got it
2007-06-18 15:09:51 [11794] DEBUG:source host
2007-06-18 15:09:51 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:09:51 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172191,527250,0,1,6) )
2007-06-18 15:09:51 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :CREATE DATABASE
newdb123
2007-06-18 15:09:51 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :CREATE DATABASE
2007-06-18 15:09:51 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:09:51 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:09:51 [11794] DEBUG:end thread_send_source()
2007-06-18 15:09:51 [11794] DEBUG:sem_unlock[1]
2007-06-18 15:09:51 [11794] DEBUG:PGRdo_replicate():query ::
PGR_CLOSE_CONNECTION
2007-06-18 15:09:51 [11794] DEBUG:cmdSts=O
2007-06-18 15:09:51 [11794] DEBUG:cmdType=x
2007-06-18 15:09:51 [11794] DEBUG:rlog=0
2007-06-18 15:09:51 [11794] DEBUG:port=5432
2007-06-18 15:09:51 [11794] DEBUG:pid=22123
2007-06-18 15:09:51 [11794] DEBUG:from_host=10.203.44.89
2007-06-18 15:09:51 [11794] DEBUG:dbName=postgres
2007-06-18 15:09:51 [11794] DEBUG:userName=postgres
2007-06-18 15:09:51 [11794] DEBUG:recieve sec=1182172191
2007-06-18 15:09:51 [11794] DEBUG:recieve usec=758685
2007-06-18 15:09:51 [11794] DEBUG:query_size=21
2007-06-18 15:09:51 [11794] DEBUG:request_id=1
2007-06-18 15:09:51 [11794] DEBUG:replicate_id=0
2007-06-18 15:09:51 [11794] DEBUG:recovery_status=0
2007-06-18 15:09:51 [11794] DEBUG:query=PGR_CLOSE_CONNECTION
2007-06-18 15:09:51 [11794] DEBUG:sem_lock [1] req
2007-06-18 15:09:51 [11794] DEBUG:sem_lock [1] got it
2007-06-18 15:09:51 [11794] DEBUG:source host
2007-06-18 15:09:51 [11794]
DEBUG:replicate_packet_send_internal():connect db:postgres port:5432
user:postgres host:fcdatarp query:PGR_CLOSE_CONNECTION
2007-06-18 15:09:51 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:09:51 [11794] DEBUG:sem_unlock[1]
2007-06-18 15:10:33 [11808] DEBUG:PGRdo_replicate():query :: SET
DateStyle=ISO
2007-06-18 15:10:33 [11808] DEBUG:cmdSts=Q
2007-06-18 15:10:33 [11808] DEBUG:cmdType=T
2007-06-18 15:10:33 [11808] DEBUG:rlog=0
2007-06-18 15:10:33 [11808] DEBUG:port=5432
2007-06-18 15:10:33 [11808] DEBUG:pid=11807
2007-06-18 15:10:33 [11808] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:33 [11808] DEBUG:dbName=postgres
2007-06-18 15:10:33 [11808] DEBUG:userName=postgres
2007-06-18 15:10:33 [11808] DEBUG:recieve sec=1182172233
2007-06-18 15:10:33 [11808] DEBUG:recieve usec=591752
2007-06-18 15:10:33 [11808] DEBUG:query_size=17
2007-06-18 15:10:33 [11808] DEBUG:request_id=1
2007-06-18 15:10:33 [11808] DEBUG:replicate_id=0
2007-06-18 15:10:33 [11808] DEBUG:recovery_status=0
2007-06-18 15:10:33 [11808] DEBUG:query=SET DateStyle=ISO
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] req
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] got it
2007-06-18 15:10:33 [11808] DEBUG:source host
2007-06-18 15:10:33 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172233,591752,274,1,8) )
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SET DateStyle=ISO
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:33 [11808] DEBUG:end thread_send_source()
2007-06-18 15:10:33 [11808] DEBUG:sem_unlock[1]
2007-06-18 15:10:33 [11808] DEBUG:PGRdo_replicate():query :: set
client_encoding to 'UNICODE'
2007-06-18 15:10:33 [11808] DEBUG:cmdSts=Q
2007-06-18 15:10:33 [11808] DEBUG:cmdType=T
2007-06-18 15:10:33 [11808] DEBUG:rlog=0
2007-06-18 15:10:33 [11808] DEBUG:port=5432
2007-06-18 15:10:33 [11808] DEBUG:pid=11807
2007-06-18 15:10:33 [11808] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:33 [11808] DEBUG:dbName=postgres
2007-06-18 15:10:33 [11808] DEBUG:userName=postgres
2007-06-18 15:10:33 [11808] DEBUG:recieve sec=1182172233
2007-06-18 15:10:33 [11808] DEBUG:recieve usec=607292
2007-06-18 15:10:33 [11808] DEBUG:query_size=32
2007-06-18 15:10:33 [11808] DEBUG:request_id=2
2007-06-18 15:10:33 [11808] DEBUG:replicate_id=0
2007-06-18 15:10:33 [11808] DEBUG:recovery_status=0
2007-06-18 15:10:33 [11808] DEBUG:query=set client_encoding to 'UNICODE'
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] req
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] got it
2007-06-18 15:10:33 [11808] DEBUG:source host
2007-06-18 15:10:33 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172233,607292,275,1,9) )
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :set client_encoding
to 'UNICODE'
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:33 [11808] DEBUG:end thread_send_source()
2007-06-18 15:10:33 [11808] DEBUG:sem_unlock[1]
2007-06-18 15:10:33 [11808] DEBUG:PGRdo_replicate():query :: SELECT
usecreatedb, usesuper, CASE WHEN usesuper THEN
pg_postmaster_start_time() ELSE NULL END as upsince
FROM pg_user WHERE usename=current_user
2007-06-18 15:10:33 [11808] DEBUG:cmdSts=Q
2007-06-18 15:10:33 [11808] DEBUG:cmdType=S
2007-06-18 15:10:33 [11808] DEBUG:rlog=0
2007-06-18 15:10:33 [11808] DEBUG:port=5432
2007-06-18 15:10:33 [11808] DEBUG:pid=11807
2007-06-18 15:10:33 [11808] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:33 [11808] DEBUG:dbName=postgres
2007-06-18 15:10:33 [11808] DEBUG:userName=postgres
2007-06-18 15:10:33 [11808] DEBUG:recieve sec=1182172233
2007-06-18 15:10:33 [11808] DEBUG:recieve usec=618220
2007-06-18 15:10:33 [11808] DEBUG:query_size=147
2007-06-18 15:10:33 [11808] DEBUG:request_id=3
2007-06-18 15:10:33 [11808] DEBUG:replicate_id=0
2007-06-18 15:10:33 [11808] DEBUG:recovery_status=0
2007-06-18 15:10:33 [11808] DEBUG:query=SELECT usecreatedb, usesuper,
CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as
upsince
FROM pg_user WHERE usename=current_user
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] req
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] got it
2007-06-18 15:10:33 [11808] DEBUG:source host
2007-06-18 15:10:33 [11808]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:33 [11808] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:33 [11808] DEBUG:end thread_send_source()
2007-06-18 15:10:33 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172233,618220,276,1,10) )
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SELECT usecreatedb,
usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL
END as upsince
FROM pg_user WHERE usename=current_user
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:33 [11808] DEBUG:sem_unlock[1]
2007-06-18 15:10:33 [11808] DEBUG:PGRdo_replicate():query :: SELECT
rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user
2007-06-18 15:10:33 [11808] DEBUG:cmdSts=Q
2007-06-18 15:10:33 [11808] DEBUG:cmdType=S
2007-06-18 15:10:33 [11808] DEBUG:rlog=0
2007-06-18 15:10:33 [11808] DEBUG:port=5432
2007-06-18 15:10:33 [11808] DEBUG:pid=11807
2007-06-18 15:10:33 [11808] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:33 [11808] DEBUG:dbName=postgres
2007-06-18 15:10:33 [11808] DEBUG:userName=postgres
2007-06-18 15:10:33 [11808] DEBUG:recieve sec=1182172233
2007-06-18 15:10:33 [11808] DEBUG:recieve usec=639398
2007-06-18 15:10:33 [11808] DEBUG:query_size=76
2007-06-18 15:10:33 [11808] DEBUG:request_id=4
2007-06-18 15:10:33 [11808] DEBUG:replicate_id=0
2007-06-18 15:10:33 [11808] DEBUG:recovery_status=0
2007-06-18 15:10:33 [11808] DEBUG:query=SELECT rolcreaterole,
rolcreatedb FROM pg_roles WHERE rolname = current_user
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] req
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] got it
2007-06-18 15:10:33 [11808] DEBUG:source host
2007-06-18 15:10:33 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172233,639398,277,1,11) )
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SELECT
rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:33 [11808]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:33 [11808] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:33 [11808] DEBUG:end thread_send_source()
2007-06-18 15:10:33 [11808] DEBUG:sem_unlock[1]
2007-06-18 15:10:33 [11808] 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 15:10:33 [11808] DEBUG:cmdSts=Q
2007-06-18 15:10:33 [11808] DEBUG:cmdType=S
2007-06-18 15:10:33 [11808] DEBUG:rlog=0
2007-06-18 15:10:33 [11808] DEBUG:port=5432
2007-06-18 15:10:33 [11808] DEBUG:pid=11807
2007-06-18 15:10:33 [11808] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:33 [11808] DEBUG:dbName=postgres
2007-06-18 15:10:33 [11808] DEBUG:userName=postgres
2007-06-18 15:10:33 [11808] DEBUG:recieve sec=1182172233
2007-06-18 15:10:33 [11808] DEBUG:recieve usec=657116
2007-06-18 15:10:33 [11808] DEBUG:query_size=306
2007-06-18 15:10:33 [11808] DEBUG:request_id=5
2007-06-18 15:10:33 [11808] DEBUG:replicate_id=0
2007-06-18 15:10:33 [11808] DEBUG:recovery_status=0
2007-06-18 15:10:33 [11808] 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 15:10:33 [11808] DEBUG:sem_lock [1] req
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] got it
2007-06-18 15:10:33 [11808] DEBUG:source host
2007-06-18 15:10:33 [11808]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:33 [11808] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:33 [11808] DEBUG:end thread_send_source()
2007-06-18 15:10:33 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172233,657116,278,1,12) )
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :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 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:33 [11808] DEBUG:sem_unlock[1]
2007-06-18 15:10:33 [11808] 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 15:10:33 [11808] DEBUG:cmdSts=Q
2007-06-18 15:10:33 [11808] DEBUG:cmdType=S
2007-06-18 15:10:33 [11808] DEBUG:rlog=0
2007-06-18 15:10:33 [11808] DEBUG:port=5432
2007-06-18 15:10:33 [11808] DEBUG:pid=11807
2007-06-18 15:10:33 [11808] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:33 [11808] DEBUG:dbName=postgres
2007-06-18 15:10:33 [11808] DEBUG:userName=postgres
2007-06-18 15:10:33 [11808] DEBUG:recieve sec=1182172233
2007-06-18 15:10:33 [11808] DEBUG:recieve usec=698729
2007-06-18 15:10:33 [11808] DEBUG:query_size=426
2007-06-18 15:10:33 [11808] DEBUG:request_id=6
2007-06-18 15:10:33 [11808] DEBUG:replicate_id=0
2007-06-18 15:10:33 [11808] DEBUG:recovery_status=0
2007-06-18 15:10:33 [11808] 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 15:10:33 [11808] DEBUG:sem_lock [1] req
2007-06-18 15:10:33 [11808] DEBUG:sem_lock [1] got it
2007-06-18 15:10:33 [11808] DEBUG:source host
2007-06-18 15:10:33 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172233,698729,279,1,13) )
2007-06-18 15:10:33 [11808]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:33 [11808] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:33 [11808] DEBUG:end thread_send_source()
2007-06-18 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :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 15:10:33 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:33 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:33 [11808] DEBUG:sem_unlock[1]
2007-06-18 15:10:40 [11819] DEBUG:PGRdo_replicate():query :: SET
DateStyle=ISO
2007-06-18 15:10:40 [11819] DEBUG:cmdSts=Q
2007-06-18 15:10:40 [11819] DEBUG:cmdType=T
2007-06-18 15:10:40 [11819] DEBUG:rlog=0
2007-06-18 15:10:40 [11819] DEBUG:port=5432
2007-06-18 15:10:40 [11819] DEBUG:pid=11818
2007-06-18 15:10:40 [11819] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:40 [11819] DEBUG:dbName=testm123
2007-06-18 15:10:40 [11819] DEBUG:userName=postgres
2007-06-18 15:10:40 [11819] DEBUG:recieve sec=1182172240
2007-06-18 15:10:40 [11819] DEBUG:recieve usec=901123
2007-06-18 15:10:40 [11819] DEBUG:query_size=17
2007-06-18 15:10:40 [11819] DEBUG:request_id=1
2007-06-18 15:10:40 [11819] DEBUG:replicate_id=0
2007-06-18 15:10:40 [11819] DEBUG:recovery_status=0
2007-06-18 15:10:40 [11819] DEBUG:query=SET DateStyle=ISO
2007-06-18 15:10:40 [11819] DEBUG:sem_lock [1] req
2007-06-18 15:10:40 [11819] DEBUG:sem_lock [1] got it
2007-06-18 15:10:40 [11819] DEBUG:source host
2007-06-18 15:10:40 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172240,901123,280,1,14) )
2007-06-18 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SET DateStyle=ISO
2007-06-18 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:40 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:40 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:40 [11819] DEBUG:end thread_send_source()
2007-06-18 15:10:40 [11819] DEBUG:sem_unlock[1]
2007-06-18 15:10:40 [11819] DEBUG:PGRdo_replicate():query :: set
client_encoding to 'UNICODE'
2007-06-18 15:10:40 [11819] DEBUG:cmdSts=Q
2007-06-18 15:10:40 [11819] DEBUG:cmdType=T
2007-06-18 15:10:40 [11819] DEBUG:rlog=0
2007-06-18 15:10:40 [11819] DEBUG:port=5432
2007-06-18 15:10:40 [11819] DEBUG:pid=11818
2007-06-18 15:10:40 [11819] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:40 [11819] DEBUG:dbName=testm123
2007-06-18 15:10:40 [11819] DEBUG:userName=postgres
2007-06-18 15:10:40 [11819] DEBUG:recieve sec=1182172240
2007-06-18 15:10:40 [11819] DEBUG:recieve usec=917826
2007-06-18 15:10:40 [11819] DEBUG:query_size=32
2007-06-18 15:10:40 [11819] DEBUG:request_id=2
2007-06-18 15:10:40 [11819] DEBUG:replicate_id=0
2007-06-18 15:10:40 [11819] DEBUG:recovery_status=0
2007-06-18 15:10:40 [11819] DEBUG:query=set client_encoding to 'UNICODE'
2007-06-18 15:10:40 [11819] DEBUG:sem_lock [1] req
2007-06-18 15:10:40 [11819] DEBUG:sem_lock [1] got it
2007-06-18 15:10:40 [11819] DEBUG:source host
2007-06-18 15:10:40 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172240,917826,281,1,15) )
2007-06-18 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :set client_encoding
to 'UNICODE'
2007-06-18 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:40 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:40 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:40 [11819] DEBUG:end thread_send_source()
2007-06-18 15:10:40 [11819] DEBUG:sem_unlock[1]
2007-06-18 15:10:40 [11819] 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 15:10:40 [11819] DEBUG:cmdSts=Q
2007-06-18 15:10:40 [11819] DEBUG:cmdType=S
2007-06-18 15:10:40 [11819] DEBUG:rlog=0
2007-06-18 15:10:40 [11819] DEBUG:port=5432
2007-06-18 15:10:40 [11819] DEBUG:pid=11818
2007-06-18 15:10:40 [11819] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:40 [11819] DEBUG:dbName=testm123
2007-06-18 15:10:40 [11819] DEBUG:userName=postgres
2007-06-18 15:10:40 [11819] DEBUG:recieve sec=1182172240
2007-06-18 15:10:40 [11819] DEBUG:recieve usec=948012
2007-06-18 15:10:40 [11819] DEBUG:query_size=426
2007-06-18 15:10:40 [11819] DEBUG:request_id=3
2007-06-18 15:10:40 [11819] DEBUG:replicate_id=0
2007-06-18 15:10:40 [11819] DEBUG:recovery_status=0
2007-06-18 15:10:40 [11819] 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 15:10:40 [11819] DEBUG:sem_lock [1] req
2007-06-18 15:10:40 [11819] DEBUG:sem_lock [1] got it
2007-06-18 15:10:40 [11819] DEBUG:source host
2007-06-18 15:10:40 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172240,948012,282,1,16) )
2007-06-18 15:10:40 [11819]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:40 [11819] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:40 [11819] DEBUG:end thread_send_source()
2007-06-18 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :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 15:10:40 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:40 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:40 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:40 [11819] DEBUG:sem_unlock[1]
2007-06-18 15:10:47 [11823] DEBUG:PGRdo_replicate():query :: SET
DateStyle=ISO
2007-06-18 15:10:47 [11823] DEBUG:cmdSts=Q
2007-06-18 15:10:47 [11823] DEBUG:cmdType=T
2007-06-18 15:10:47 [11823] DEBUG:rlog=0
2007-06-18 15:10:47 [11823] DEBUG:port=5432
2007-06-18 15:10:47 [11823] DEBUG:pid=22131
2007-06-18 15:10:47 [11823] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:47 [11823] DEBUG:dbName=postgres
2007-06-18 15:10:47 [11823] DEBUG:userName=postgres
2007-06-18 15:10:47 [11823] DEBUG:recieve sec=1182172247
2007-06-18 15:10:47 [11823] DEBUG:recieve usec=923966
2007-06-18 15:10:47 [11823] DEBUG:query_size=17
2007-06-18 15:10:47 [11823] DEBUG:request_id=1
2007-06-18 15:10:47 [11823] DEBUG:replicate_id=0
2007-06-18 15:10:47 [11823] DEBUG:recovery_status=0
2007-06-18 15:10:47 [11823] DEBUG:query=SET DateStyle=ISO
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] req
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] got it
2007-06-18 15:10:47 [11823] DEBUG:source host
2007-06-18 15:10:47 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172247,923966,283,1,17) )
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SET DateStyle=ISO
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:47 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:47 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:47 [11823] DEBUG:end thread_send_source()
2007-06-18 15:10:47 [11823] DEBUG:sem_unlock[1]
2007-06-18 15:10:47 [11823] DEBUG:PGRdo_replicate():query :: set
client_encoding to 'UNICODE'
2007-06-18 15:10:47 [11823] DEBUG:cmdSts=Q
2007-06-18 15:10:47 [11823] DEBUG:cmdType=T
2007-06-18 15:10:47 [11823] DEBUG:rlog=0
2007-06-18 15:10:47 [11823] DEBUG:port=5432
2007-06-18 15:10:47 [11823] DEBUG:pid=22131
2007-06-18 15:10:47 [11823] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:47 [11823] DEBUG:dbName=postgres
2007-06-18 15:10:47 [11823] DEBUG:userName=postgres
2007-06-18 15:10:47 [11823] DEBUG:recieve sec=1182172247
2007-06-18 15:10:47 [11823] DEBUG:recieve usec=954907
2007-06-18 15:10:47 [11823] DEBUG:query_size=32
2007-06-18 15:10:47 [11823] DEBUG:request_id=2
2007-06-18 15:10:47 [11823] DEBUG:replicate_id=0
2007-06-18 15:10:47 [11823] DEBUG:recovery_status=0
2007-06-18 15:10:47 [11823] DEBUG:query=set client_encoding to 'UNICODE'
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] req
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] got it
2007-06-18 15:10:47 [11823] DEBUG:source host
2007-06-18 15:10:47 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172247,954907,284,1,18) )
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :set client_encoding
to 'UNICODE'
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:47 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:47 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:47 [11823] DEBUG:end thread_send_source()
2007-06-18 15:10:47 [11823] DEBUG:sem_unlock[1]
2007-06-18 15:10:47 [11823] DEBUG:PGRdo_replicate():query :: SELECT
usecreatedb, usesuper, CASE WHEN usesuper THEN
pg_postmaster_start_time() ELSE NULL END as upsince
FROM pg_user WHERE usename=current_user
2007-06-18 15:10:47 [11823] DEBUG:cmdSts=Q
2007-06-18 15:10:47 [11823] DEBUG:cmdType=S
2007-06-18 15:10:47 [11823] DEBUG:rlog=0
2007-06-18 15:10:47 [11823] DEBUG:port=5432
2007-06-18 15:10:47 [11823] DEBUG:pid=22131
2007-06-18 15:10:47 [11823] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:47 [11823] DEBUG:dbName=postgres
2007-06-18 15:10:47 [11823] DEBUG:userName=postgres
2007-06-18 15:10:47 [11823] DEBUG:recieve sec=1182172247
2007-06-18 15:10:47 [11823] DEBUG:recieve usec=965412
2007-06-18 15:10:47 [11823] DEBUG:query_size=147
2007-06-18 15:10:47 [11823] DEBUG:request_id=3
2007-06-18 15:10:47 [11823] DEBUG:replicate_id=0
2007-06-18 15:10:47 [11823] DEBUG:recovery_status=0
2007-06-18 15:10:47 [11823] DEBUG:query=SELECT usecreatedb, usesuper,
CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL END as
upsince
FROM pg_user WHERE usename=current_user
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] req
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] got it
2007-06-18 15:10:47 [11823] DEBUG:source host
2007-06-18 15:10:47 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172247,965412,285,1,19) )
2007-06-18 15:10:47 [11823]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:47 [11823] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:47 [11823] DEBUG:end thread_send_source()
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SELECT usecreatedb,
usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL
END as upsince
FROM pg_user WHERE usename=current_user
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:47 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:47 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:47 [11823] DEBUG:sem_unlock[1]
2007-06-18 15:10:47 [11823] DEBUG:PGRdo_replicate():query :: SELECT
rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user
2007-06-18 15:10:47 [11823] DEBUG:cmdSts=Q
2007-06-18 15:10:47 [11823] DEBUG:cmdType=S
2007-06-18 15:10:47 [11823] DEBUG:rlog=0
2007-06-18 15:10:47 [11823] DEBUG:port=5432
2007-06-18 15:10:47 [11823] DEBUG:pid=22131
2007-06-18 15:10:47 [11823] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:47 [11823] DEBUG:dbName=postgres
2007-06-18 15:10:47 [11823] DEBUG:userName=postgres
2007-06-18 15:10:47 [11823] DEBUG:recieve sec=1182172247
2007-06-18 15:10:47 [11823] DEBUG:recieve usec=975709
2007-06-18 15:10:47 [11823] DEBUG:query_size=76
2007-06-18 15:10:47 [11823] DEBUG:request_id=4
2007-06-18 15:10:47 [11823] DEBUG:replicate_id=0
2007-06-18 15:10:47 [11823] DEBUG:recovery_status=0
2007-06-18 15:10:47 [11823] DEBUG:query=SELECT rolcreaterole,
rolcreatedb FROM pg_roles WHERE rolname = current_user
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] req
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] got it
2007-06-18 15:10:47 [11823] DEBUG:source host
2007-06-18 15:10:47 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172247,975709,286,1,20) )
2007-06-18 15:10:47 [11823]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:47 [11823] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:47 [11823] DEBUG:end thread_send_source()
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SELECT
rolcreaterole, rolcreatedb FROM pg_roles WHERE rolname = current_user
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:47 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:47 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:47 [11823] DEBUG:sem_unlock[1]
2007-06-18 15:10:47 [11823] 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 15:10:47 [11823] DEBUG:cmdSts=Q
2007-06-18 15:10:47 [11823] DEBUG:cmdType=S
2007-06-18 15:10:47 [11823] DEBUG:rlog=0
2007-06-18 15:10:47 [11823] DEBUG:port=5432
2007-06-18 15:10:47 [11823] DEBUG:pid=22131
2007-06-18 15:10:47 [11823] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:47 [11823] DEBUG:dbName=postgres
2007-06-18 15:10:47 [11823] DEBUG:userName=postgres
2007-06-18 15:10:47 [11823] DEBUG:recieve sec=1182172247
2007-06-18 15:10:47 [11823] DEBUG:recieve usec=995888
2007-06-18 15:10:47 [11823] DEBUG:query_size=306
2007-06-18 15:10:47 [11823] DEBUG:request_id=5
2007-06-18 15:10:47 [11823] DEBUG:replicate_id=0
2007-06-18 15:10:47 [11823] DEBUG:recovery_status=0
2007-06-18 15:10:47 [11823] 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 15:10:47 [11823] DEBUG:sem_lock [1] req
2007-06-18 15:10:47 [11823] DEBUG:sem_lock [1] got it
2007-06-18 15:10:47 [11823] DEBUG:source host
2007-06-18 15:10:47 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:47 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172247,995888,287,1,21) )
2007-06-18 15:10:47 [11823]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:47 [11823] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:47 [11823] DEBUG:end thread_send_source()
2007-06-18 15:10:48 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :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 15:10:48 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:48 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:48 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:48 [11823] DEBUG:sem_unlock[1]
2007-06-18 15:10:48 [11823] 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 15:10:48 [11823] DEBUG:cmdSts=Q
2007-06-18 15:10:48 [11823] DEBUG:cmdType=S
2007-06-18 15:10:48 [11823] DEBUG:rlog=0
2007-06-18 15:10:48 [11823] DEBUG:port=5432
2007-06-18 15:10:48 [11823] DEBUG:pid=22131
2007-06-18 15:10:48 [11823] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:48 [11823] DEBUG:dbName=postgres
2007-06-18 15:10:48 [11823] DEBUG:userName=postgres
2007-06-18 15:10:48 [11823] DEBUG:recieve sec=1182172248
2007-06-18 15:10:48 [11823] DEBUG:recieve usec=73494
2007-06-18 15:10:48 [11823] DEBUG:query_size=426
2007-06-18 15:10:48 [11823] DEBUG:request_id=6
2007-06-18 15:10:48 [11823] DEBUG:replicate_id=0
2007-06-18 15:10:48 [11823] DEBUG:recovery_status=0
2007-06-18 15:10:48 [11823] 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 15:10:48 [11823] DEBUG:sem_lock [1] req
2007-06-18 15:10:48 [11823] DEBUG:sem_lock [1] got it
2007-06-18 15:10:48 [11823] DEBUG:source host
2007-06-18 15:10:48 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:48 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172248,73494,288,1,22) )
2007-06-18 15:10:48 [11823]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:48 [11823] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:48 [11823] DEBUG:end thread_send_source()
2007-06-18 15:10:48 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :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 15:10:48 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:48 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:48 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:48 [11823] DEBUG:sem_unlock[1]
2007-06-18 15:10:51 [11833] DEBUG:PGRdo_replicate():query :: SET
DateStyle=ISO
2007-06-18 15:10:51 [11833] DEBUG:cmdSts=Q
2007-06-18 15:10:51 [11833] DEBUG:cmdType=T
2007-06-18 15:10:51 [11833] DEBUG:rlog=0
2007-06-18 15:10:51 [11833] DEBUG:port=5432
2007-06-18 15:10:51 [11833] DEBUG:pid=22134
2007-06-18 15:10:51 [11833] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:51 [11833] DEBUG:dbName=newdb123
2007-06-18 15:10:51 [11833] DEBUG:userName=postgres
2007-06-18 15:10:51 [11833] DEBUG:recieve sec=1182172251
2007-06-18 15:10:51 [11833] DEBUG:recieve usec=20865
2007-06-18 15:10:51 [11833] DEBUG:query_size=17
2007-06-18 15:10:51 [11833] DEBUG:request_id=1
2007-06-18 15:10:51 [11833] DEBUG:replicate_id=0
2007-06-18 15:10:51 [11833] DEBUG:recovery_status=0
2007-06-18 15:10:51 [11833] DEBUG:query=SET DateStyle=ISO
2007-06-18 15:10:51 [11833] DEBUG:sem_lock [1] req
2007-06-18 15:10:51 [11833] DEBUG:sem_lock [1] got it
2007-06-18 15:10:51 [11833] DEBUG:source host
2007-06-18 15:10:51 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172251,20865,289,1,23) )
2007-06-18 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SET DateStyle=ISO
2007-06-18 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:51 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:51 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:51 [11833] DEBUG:end thread_send_source()
2007-06-18 15:10:51 [11833] DEBUG:sem_unlock[1]
2007-06-18 15:10:51 [11833] DEBUG:PGRdo_replicate():query :: set
client_encoding to 'UNICODE'
2007-06-18 15:10:51 [11833] DEBUG:cmdSts=Q
2007-06-18 15:10:51 [11833] DEBUG:cmdType=T
2007-06-18 15:10:51 [11833] DEBUG:rlog=0
2007-06-18 15:10:51 [11833] DEBUG:port=5432
2007-06-18 15:10:51 [11833] DEBUG:pid=22134
2007-06-18 15:10:51 [11833] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:51 [11833] DEBUG:dbName=newdb123
2007-06-18 15:10:51 [11833] DEBUG:userName=postgres
2007-06-18 15:10:51 [11833] DEBUG:recieve sec=1182172251
2007-06-18 15:10:51 [11833] DEBUG:recieve usec=38757
2007-06-18 15:10:51 [11833] DEBUG:query_size=32
2007-06-18 15:10:51 [11833] DEBUG:request_id=2
2007-06-18 15:10:51 [11833] DEBUG:replicate_id=0
2007-06-18 15:10:51 [11833] DEBUG:recovery_status=0
2007-06-18 15:10:51 [11833] DEBUG:query=set client_encoding to 'UNICODE'
2007-06-18 15:10:51 [11833] DEBUG:sem_lock [1] req
2007-06-18 15:10:51 [11833] DEBUG:sem_lock [1] got it
2007-06-18 15:10:51 [11833] DEBUG:source host
2007-06-18 15:10:51 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172251,38757,290,1,24) )
2007-06-18 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :set client_encoding
to 'UNICODE'
2007-06-18 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:51 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:51 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:51 [11833] DEBUG:end thread_send_source()
2007-06-18 15:10:51 [11833] DEBUG:sem_unlock[1]
2007-06-18 15:10:51 [11833] 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 15:10:51 [11833] DEBUG:cmdSts=Q
2007-06-18 15:10:51 [11833] DEBUG:cmdType=S
2007-06-18 15:10:51 [11833] DEBUG:rlog=0
2007-06-18 15:10:51 [11833] DEBUG:port=5432
2007-06-18 15:10:51 [11833] DEBUG:pid=22134
2007-06-18 15:10:51 [11833] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:51 [11833] DEBUG:dbName=newdb123
2007-06-18 15:10:51 [11833] DEBUG:userName=postgres
2007-06-18 15:10:51 [11833] DEBUG:recieve sec=1182172251
2007-06-18 15:10:51 [11833] DEBUG:recieve usec=87281
2007-06-18 15:10:51 [11833] DEBUG:query_size=426
2007-06-18 15:10:51 [11833] DEBUG:request_id=3
2007-06-18 15:10:51 [11833] DEBUG:replicate_id=0
2007-06-18 15:10:51 [11833] DEBUG:recovery_status=0
2007-06-18 15:10:51 [11833] 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 15:10:51 [11833] DEBUG:sem_lock [1] req
2007-06-18 15:10:51 [11833] DEBUG:sem_lock [1] got it
2007-06-18 15:10:51 [11833] DEBUG:source host
2007-06-18 15:10:51 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172251,87281,291,1,25) )
2007-06-18 15:10:51 [11833]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:51 [11833] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:51 [11833] DEBUG:end thread_send_source()
2007-06-18 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :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 15:10:51 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:51 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:51 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:51 [11833] DEBUG:sem_unlock[1]
2007-06-18 15:10:57 [11837] DEBUG:PGRdo_replicate():query :: SET
DateStyle=ISO
2007-06-18 15:10:57 [11837] DEBUG:cmdSts=Q
2007-06-18 15:10:57 [11837] DEBUG:cmdType=T
2007-06-18 15:10:57 [11837] DEBUG:rlog=0
2007-06-18 15:10:57 [11837] DEBUG:port=5432
2007-06-18 15:10:57 [11837] DEBUG:pid=22136
2007-06-18 15:10:57 [11837] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:57 [11837] DEBUG:dbName=testm123
2007-06-18 15:10:57 [11837] DEBUG:userName=postgres
2007-06-18 15:10:57 [11837] DEBUG:recieve sec=1182172257
2007-06-18 15:10:57 [11837] DEBUG:recieve usec=651922
2007-06-18 15:10:57 [11837] DEBUG:query_size=17
2007-06-18 15:10:57 [11837] DEBUG:request_id=1
2007-06-18 15:10:57 [11837] DEBUG:replicate_id=0
2007-06-18 15:10:57 [11837] DEBUG:recovery_status=0
2007-06-18 15:10:57 [11837] DEBUG:query=SET DateStyle=ISO
2007-06-18 15:10:57 [11837] DEBUG:sem_lock [1] req
2007-06-18 15:10:57 [11837] DEBUG:sem_lock [1] got it
2007-06-18 15:10:57 [11837] DEBUG:source host
2007-06-18 15:10:57 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172257,651922,292,1,26) )
2007-06-18 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SET DateStyle=ISO
2007-06-18 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:57 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:57 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:57 [11837] DEBUG:end thread_send_source()
2007-06-18 15:10:57 [11837] DEBUG:sem_unlock[1]
2007-06-18 15:10:57 [11837] DEBUG:PGRdo_replicate():query :: set
client_encoding to 'UNICODE'
2007-06-18 15:10:57 [11837] DEBUG:cmdSts=Q
2007-06-18 15:10:57 [11837] DEBUG:cmdType=T
2007-06-18 15:10:57 [11837] DEBUG:rlog=0
2007-06-18 15:10:57 [11837] DEBUG:port=5432
2007-06-18 15:10:57 [11837] DEBUG:pid=22136
2007-06-18 15:10:57 [11837] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:57 [11837] DEBUG:dbName=testm123
2007-06-18 15:10:57 [11837] DEBUG:userName=postgres
2007-06-18 15:10:57 [11837] DEBUG:recieve sec=1182172257
2007-06-18 15:10:57 [11837] DEBUG:recieve usec=670276
2007-06-18 15:10:57 [11837] DEBUG:query_size=32
2007-06-18 15:10:57 [11837] DEBUG:request_id=2
2007-06-18 15:10:57 [11837] DEBUG:replicate_id=0
2007-06-18 15:10:57 [11837] DEBUG:recovery_status=0
2007-06-18 15:10:57 [11837] DEBUG:query=set client_encoding to 'UNICODE'
2007-06-18 15:10:57 [11837] DEBUG:sem_lock [1] req
2007-06-18 15:10:57 [11837] DEBUG:sem_lock [1] got it
2007-06-18 15:10:57 [11837] DEBUG:source host
2007-06-18 15:10:57 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172257,670276,293,1,27) )
2007-06-18 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :set client_encoding
to 'UNICODE'
2007-06-18 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:10:57 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:57 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:57 [11837] DEBUG:end thread_send_source()
2007-06-18 15:10:57 [11837] DEBUG:sem_unlock[1]
2007-06-18 15:10:57 [11837] 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 15:10:57 [11837] DEBUG:cmdSts=Q
2007-06-18 15:10:57 [11837] DEBUG:cmdType=S
2007-06-18 15:10:57 [11837] DEBUG:rlog=0
2007-06-18 15:10:57 [11837] DEBUG:port=5432
2007-06-18 15:10:57 [11837] DEBUG:pid=22136
2007-06-18 15:10:57 [11837] DEBUG:from_host=10.203.44.89
2007-06-18 15:10:57 [11837] DEBUG:dbName=testm123
2007-06-18 15:10:57 [11837] DEBUG:userName=postgres
2007-06-18 15:10:57 [11837] DEBUG:recieve sec=1182172257
2007-06-18 15:10:57 [11837] DEBUG:recieve usec=719725
2007-06-18 15:10:57 [11837] DEBUG:query_size=426
2007-06-18 15:10:57 [11837] DEBUG:request_id=3
2007-06-18 15:10:57 [11837] DEBUG:replicate_id=0
2007-06-18 15:10:57 [11837] DEBUG:recovery_status=0
2007-06-18 15:10:57 [11837] 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 15:10:57 [11837] DEBUG:sem_lock [1] req
2007-06-18 15:10:57 [11837] DEBUG:sem_lock [1] got it
2007-06-18 15:10:57 [11837] DEBUG:source host
2007-06-18 15:10:57 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172257,719725,294,1,28) )
2007-06-18 15:10:57 [11837]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:10:57 [11837] DEBUG:read_answer():QUERY DONE
2007-06-18 15:10:57 [11837] DEBUG:end thread_send_source()
2007-06-18 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :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 15:10:57 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:10:57 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:10:57 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:10:57 [11837] DEBUG:sem_unlock[1]
2007-06-18 15:11:06 [11844] DEBUG:PGRdo_replicate():query :: SET
DateStyle=ISO
2007-06-18 15:11:06 [11844] DEBUG:cmdSts=Q
2007-06-18 15:11:06 [11844] DEBUG:cmdType=T
2007-06-18 15:11:06 [11844] DEBUG:rlog=0
2007-06-18 15:11:06 [11844] DEBUG:port=5432
2007-06-18 15:11:06 [11844] DEBUG:pid=22139
2007-06-18 15:11:06 [11844] DEBUG:from_host=10.203.44.89
2007-06-18 15:11:06 [11844] DEBUG:dbName=testm321
2007-06-18 15:11:06 [11844] DEBUG:userName=postgres
2007-06-18 15:11:06 [11844] DEBUG:recieve sec=1182172266
2007-06-18 15:11:06 [11844] DEBUG:recieve usec=661755
2007-06-18 15:11:06 [11844] DEBUG:query_size=17
2007-06-18 15:11:06 [11844] DEBUG:request_id=1
2007-06-18 15:11:06 [11844] DEBUG:replicate_id=0
2007-06-18 15:11:06 [11844] DEBUG:recovery_status=0
2007-06-18 15:11:06 [11844] DEBUG:query=SET DateStyle=ISO
2007-06-18 15:11:06 [11844] DEBUG:sem_lock [1] req
2007-06-18 15:11:06 [11844] DEBUG:sem_lock [1] got it
2007-06-18 15:11:06 [11844] DEBUG:source host
2007-06-18 15:11:06 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172266,661755,295,1,29) )
2007-06-18 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :SET DateStyle=ISO
2007-06-18 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:11:06 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:11:06 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:11:06 [11844] DEBUG:end thread_send_source()
2007-06-18 15:11:06 [11844] DEBUG:sem_unlock[1]
2007-06-18 15:11:06 [11844] DEBUG:PGRdo_replicate():query :: set
client_encoding to 'UNICODE'
2007-06-18 15:11:06 [11844] DEBUG:cmdSts=Q
2007-06-18 15:11:06 [11844] DEBUG:cmdType=T
2007-06-18 15:11:06 [11844] DEBUG:rlog=0
2007-06-18 15:11:06 [11844] DEBUG:port=5432
2007-06-18 15:11:06 [11844] DEBUG:pid=22139
2007-06-18 15:11:06 [11844] DEBUG:from_host=10.203.44.89
2007-06-18 15:11:06 [11844] DEBUG:dbName=testm321
2007-06-18 15:11:06 [11844] DEBUG:userName=postgres
2007-06-18 15:11:06 [11844] DEBUG:recieve sec=1182172266
2007-06-18 15:11:06 [11844] DEBUG:recieve usec=679601
2007-06-18 15:11:06 [11844] DEBUG:query_size=32
2007-06-18 15:11:06 [11844] DEBUG:request_id=2
2007-06-18 15:11:06 [11844] DEBUG:replicate_id=0
2007-06-18 15:11:06 [11844] DEBUG:recovery_status=0
2007-06-18 15:11:06 [11844] DEBUG:query=set client_encoding to 'UNICODE'
2007-06-18 15:11:06 [11844] DEBUG:sem_lock [1] req
2007-06-18 15:11:06 [11844] DEBUG:sem_lock [1] got it
2007-06-18 15:11:06 [11844] DEBUG:source host
2007-06-18 15:11:06 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172266,679601,296,1,30) )
2007-06-18 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :set client_encoding
to 'UNICODE'
2007-06-18 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SET
2007-06-18 15:11:06 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:11:06 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:11:06 [11844] DEBUG:end thread_send_source()
2007-06-18 15:11:06 [11844] DEBUG:sem_unlock[1]
2007-06-18 15:11:06 [11844] 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 15:11:06 [11844] DEBUG:cmdSts=Q
2007-06-18 15:11:06 [11844] DEBUG:cmdType=S
2007-06-18 15:11:06 [11844] DEBUG:rlog=0
2007-06-18 15:11:06 [11844] DEBUG:port=5432
2007-06-18 15:11:06 [11844] DEBUG:pid=22139
2007-06-18 15:11:06 [11844] DEBUG:from_host=10.203.44.89
2007-06-18 15:11:06 [11844] DEBUG:dbName=testm321
2007-06-18 15:11:06 [11844] DEBUG:userName=postgres
2007-06-18 15:11:06 [11844] DEBUG:recieve sec=1182172266
2007-06-18 15:11:06 [11844] DEBUG:recieve usec=739914
2007-06-18 15:11:06 [11844] DEBUG:query_size=426
2007-06-18 15:11:06 [11844] DEBUG:request_id=3
2007-06-18 15:11:06 [11844] DEBUG:replicate_id=0
2007-06-18 15:11:06 [11844] DEBUG:recovery_status=0
2007-06-18 15:11:06 [11844] 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 15:11:06 [11844] DEBUG:sem_lock [1] req
2007-06-18 15:11:06 [11844] DEBUG:sem_lock [1] got it
2007-06-18 15:11:06 [11844] DEBUG:source host
2007-06-18 15:11:06 [11719] DEBUG:start thread_send_cluster()
2007-06-18 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():sync_command(SELECT
PGR_SYSTEM_COMMAND_FUNCTION(3,1182172266,739914,297,1,31) )
2007-06-18 15:11:06 [11844]
DEBUG:read_answer():answer[PGR_QUERY_DONE_NOTICE_CMD]
2007-06-18 15:11:06 [11844] DEBUG:read_answer():QUERY DONE
2007-06-18 15:11:06 [11844] DEBUG:end thread_send_source()
2007-06-18 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():PQexec send :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 15:11:06 [11719]
DEBUG:send_replicate_packet_to_server():PQexec returns :SELECT
2007-06-18 15:11:06 [11719] DEBUG:thread_send_cluster():return value
from send_replicate_packet_to_server() is 0
2007-06-18 15:11:06 [11719] DEBUG:thread_send_cluster():pthread_exit[1]
2007-06-18 15:11:06 [11844] DEBUG:sem_unlock[1]
On Mon, 2007-06-18 at 15:08 +0200, a.mitani at sra-europe.com wrote:
> Hi Hans,
>
> It seems that the replication server does not find other cluster DB.
>
> Would you show us the start-up debug messages of replication server.
>
> 1. start-up both cluster DBs.
> 2. start-up replication server.
> 3. send "CREATE DB" query from both cluster DB.
> (please do not create the same name of db at each cluster)
>
> Regards,
> --------------
> At.Mitani
> _______________________________________________
> 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