Home > Archive > Slony1 PostgreSQL Replication > September 2005 > dump/restore of replica?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author dump/restore of replica?
Philip Warner

2005-09-17, 3:24 am


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?
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com