Aleksey Tsalolikhin atsaloli.tech at gmail.com
Mon Mar 29 14:27:09 PDT 2010
Hi.  I am trying to get Slony 2.0.2 up for the first time between two
Postgres 8.4 instances, and the data copy is failing with "could not
lock table $tablename on subscriber".

Connected to provider DB.
Prepare to copy table.
Could not lock table ${name of first table} on subscriber.
Data copy for set 1 failed.

All the tables on the slave are empty.

I am using 'postgres' for the replication user.

I checked with "select * from pg_stat_activity;" on the slave and it
shows all sessions are IDLE.

Any suggestions for getting the initial copy going?

Thanks,
Aleksey


More information about the Slony1-general mailing list