Re: [Postgres-xc-general] Problem with executing any query (No space left on )

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

what will be the impact if i remove files under pg_xlog directory ?

root@db02:/home/postgres/pgxc/nodes/dn_master/pg_xlog# du -sh
33G     .



On Thu, May 1, 2014 at 4:05 PM, Juned Khan <jkh...@gm...> wrote:

> As of now i am attaching my pgxc_ctl.conf file, i have setup everything
> using pgxc_ctl. this database is in production. to perform all above steps
> i need to set downtime. so when i get a change i ll perform this steps .
>  please tell me if i have done any misconfiguration in this file. so i can
> update this at that time.
>
>
>
>
> On Thu, May 1, 2014 at 3:50 PM, 鈴木 幸市 <ko...@in...> wrote:
>
>>  I needd an info how you configured your cluster, manually or pgxc_ctl.
>> If pgxc_ctl, I need your configuration file.
>>
>>  Also, it’s very funny that gtm.control is missing.     If so, next
>> thing you can do is:
>>
>>  1) Stop all the coordinators/datanodes/gtm, master and slave.
>> 2) Bake file-level backup of all the resources (cold backup)
>> 3) Detach coordinator/datanode slaves and see if masters run normally.
>> 4) If so, then reconstruct slaves.
>> 5) If masters does not work correctly, you need to hack each node’s
>> pg_control to see current GXID value and restore gtm.control with this
>> value to restart gtm.
>>
>>  Even if gtm fails, gtm.control is available to indicate a safe restart
>> point.   Do you have any idea how it’s been gone?
>>
>>  Regards;
>>  ---
>> Koichi Suzuki
>>
>>  2014/05/01 19:02、Juned Khan <jkh...@gm...> のメール：
>>
>>   I am not sure but may be datanode_archlog directory is not exists in
>> my case. may be its have different name.
>>  however size of /home/postgres/pgxc/nodes/dn_master directory is *42G*and /home/postgres/pgxc/nodes/gtm_pxy is of
>> *31G*.
>>
>>  Please suggest.
>>
>>
>> On Thu, May 1, 2014 at 12:50 PM, Michael Paquier <
>> mic...@gm...> wrote:
>>
>>> On Mon, Apr 28, 2014 at 8:31 PM, Juned Khan <jkh...@gm...> wrote:
>>> > "/home/postgres/pgxc/nodes/datanode_archlog/000000010000001C0000006A":
>>> No
>>> > space left on device (28)
>>>  This means that the partition containing folder
>>> /home/postgres/pgxc/nodes/datanode_archlog/ is full. Try to do some df
>>> and monitor the size of this partition/disk that you are using for
>>> your archive files.
>>> --
>>> Michael
>>>
>>
>>
>>
>> --
>> Thanks,
>> Juned Khan
>> iNextrix Technologies Pvt Ltd.
>> www.inextrix.com
>> ------------------------------------------------------------------------------
>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> Instantly run your Selenium tests across 300+ browser/OS combos.  Get
>> unparalleled scalability from the best Selenium testing platform
>> available.
>> Simple to use. Nothing to install. Get started now for free."
>>
>> http://p.sf.net/sfu/SauceLabs_______________________________________________
>> Postgres-xc-general mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>
>>
>>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>



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