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

[鈴木 幸市 <ko...@in...>]

Please try pg_dumpall if it works.

Regards;
---
Koichi Suzuki

2014/04/09 17:31、Juned Khan <jkh...@gm...<mailto: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<http://www.inextrix.com/>
------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general