[Postgres-xc-general] Problem with taking database dump with pgxc-1.2.1

[Juned K. <jkh...@gm...>]

Hi All,

recently i have just installed the pgxc-1.2.1 on one of my production server
but when i tried to take backup of all data it gave me below errors.

PGXC pg_dump mydatabase > mydatabase.sql
pg_dump: [archiver (db)] query failed: ERROR:  cannot execute nextval() in
a read-only transaction
pg_dump: [archiver (db)] query was: SELECT
pg_catalog.nextval('account_package_id_seq');

With some googling i found this
http://www.postgresql.org/message-id/4DC...@po...

How to solve this issue? even pg_dumpall is working

Please suggest.

-- 

Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com