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

[Masataka S. <pg...@gm...>]

I can't believe pg_dumpall is working.

pg_dumpall uses pg_dump internally to dump each database. pg_dump uses
nextval() to obtain sequce values in a read only transaction. It's
invalid operation because nextval() changes a sequce value regardless
of being read-only transaction.

Regards.

On 9 April 2014 17:43, 鈴木 幸市 <ko...@in...> wrote:
> Please try pg_dumpall if it works.
>
> Regards;
> ---
> Koichi Suzuki
>
> 2014/04/09 17:31、Juned Khan <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
> ------------------------------------------------------------------------------
> 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
>
>
>
> ------------------------------------------------------------------------------
> 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
>