Philip Warner pjw
Sat Sep 17 07:38:58 PDT 2005
When we dump/restore a replica DB (and fix table/sequence OIDs in
replica sl_tables/sl_sequences), we get:

declare LOG
 cursor for select     log_origin, log_xid, log_tableid,    
log_actionseq, log_cmdtype, log_cmddata from "_upsreplication".sl_log_1
where log_origin
 = 1 and (  order by log_actionseq; " PGRES_FATAL_ERROR ERROR:  syntax
error at or near "order" at character 173

Prior to this in the log is:

DEBUG2 remoteWorkerThread_1: Didn't add or to provider

Any ideas what I have missed in my dump/restore?




More information about the Slony1-general mailing list