Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XEJ0d-0003ul-55 for pgsql-admin@arkaria.postgresql.org; Mon, 04 Aug 2014 14:13:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XEJ0c-0008Bo-Ka for pgsql-admin@arkaria.postgresql.org; Mon, 04 Aug 2014 14:13:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XEJ0b-0008Bf-Ra for pgsql-admin@postgresql.org; Mon, 04 Aug 2014 14:13:05 +0000 Received: from nm14.bullet.mail.ne1.yahoo.com ([98.138.90.77]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XEJ0W-0005CX-Ev for pgsql-admin@postgresql.org; Mon, 04 Aug 2014 14:13:04 +0000 Received: from [98.138.101.131] by nm14.bullet.mail.ne1.yahoo.com with NNFMP; 04 Aug 2014 14:12:57 -0000 Received: from [98.138.89.244] by tm19.bullet.mail.ne1.yahoo.com with NNFMP; 04 Aug 2014 14:12:57 -0000 Received: from [127.0.0.1] by omp1058.mail.ne1.yahoo.com with NNFMP; 04 Aug 2014 14:12:57 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 467675.23688.bm@omp1058.mail.ne1.yahoo.com Received: (qmail 99842 invoked by uid 60001); 4 Aug 2014 14:12:57 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1407161577; bh=zF3Pv3OdlpTWyvGbbcyO8iuSgf2o++fX+Fab92CpwKI=; h=References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=mFDjOaJnYoQ2TkqL9TjBySGB5zLUm2WYoBPFewBG91J9xaVzTocx6aKHW1jM9m8JV3nDf7pqmvwmcUSASLI/M27S45c6VEf/PYRle020ZuaBr7feCyv6ccG++LHcfrExe39NSLSxzSWto9Ym4hhNfIpOWXUDPVabFkzMwCaUWHc= X-YMail-OSG: tjP82gMVM1kby5v0d_lXW7rYjARBsHjCtPVt7nBPP9VfiUj rX8XHa.Z912YoexcGUwESs619bAUk43xK7FcxfWc.aeR2OzJ3xKRkRPsvgUL EcARX2ssj_WB4u4e8iOSFy6ieKUiQqk6uDAf6X2yjD8rvIb2GDsRMD6sPJlV U0218h62oIp4EH8i466RSpRQMSgFDUBIuCdjyvqRYiFsQmZHvmSPoxgO4pob ZrVnTn1a3V2q8At9qB60_9oyy98lcgogcZkDK86dcJgWTcO_YnBuMVONSpNE FRjiXwFysqr1VS5rqu9_l_iFodcHNj0LAH911P9mmgRaVA0gN6aGwgW7BevQ xqACYPI7cJ2L1.E6a4fKtX6yHVR0iqXFdD_F6Vv0sZgUsSae5vtjP2hC5She .d6liHJjG4HeznF.MFgcoRUBtXKAxV22OMt821u6f76t81rBf1XPbGkPRkTK jx_Ro07IzriQ50opPbdW1teDcsNzF.miIl0St.bq5cH_9.tqKo4m6gfYaOVP __EiNW5IGH9lD7x.wmH7xffFwRKnoAcHo1HhJbhmkAqYtiDKTtZkJaVmPfd2 F267D2.8S71XMhU1kz3hjCN8TKXmaWbU8uxYoVKyc5JKi_58dPLtuO73GWXz rC.JNS_HtjKJvCBkm69mLBb8FRpsXdAc.Rie3HYHd968n87TRkk5RWR1aQpp 1KN4hreBlV00- Received: from [24.178.25.147] by web122305.mail.ne1.yahoo.com via HTTP; Mon, 04 Aug 2014 07:12:57 PDT X-Rocket-MIMEInfo: 002.001, IlNvZmVyLCBZdXZhbCIgPFl1dmFsX1NvZmVyQGJtYy5jb20.IHdyb3RlOgoKPiBJcyB0aGVyZSBhbnkgd2F5IHRvIHR1cm4gYXJjaGl2ZSBtb2RlIHRvIG9uLCB3aXRob3V0IHJlc3RhcnRpbmcgCj4gUG9zdGdyZXMgZGF0YWJhc2Ugc2VydmVyPwoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvaW50ZXJhY3RpdmUvcnVudGltZS1jb25maWctd2FsLmh0bWwjUlVOVElNRS1DT05GSUctV0FMLUFSQ0hJVklORwoKIlRoaXMgcGFyYW1ldGVyIGNhbiBvbmx5IGJlIHNldCBhdCBzZXJ2ZXIgc3QBMAEBAQE- X-Mailer: YahooMailWebService/0.8.198.689 References: <05d9187d37584aee9847d1bcb01cdb81@phx-exmbprd-02.adprod.bmc.com> Message-ID: <1407161577.75942.YahooMailNeo@web122305.mail.ne1.yahoo.com> Date: Mon, 4 Aug 2014 07:12:57 -0700 From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: set archive mode => on To: "Sofer, Yuval" , "pgsql-admin@postgresql.org" In-Reply-To: <05d9187d37584aee9847d1bcb01cdb81@phx-exmbprd-02.adprod.bmc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org "Sofer, Yuval" wrote: > Is there any way to turn archive mode to on, without restarting > Postgres database server? http://www.postgresql.org/docs/current/interactive/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING "This parameter can only be set at server start." -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin