Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WxyDE-0006ii-48 for pgsql-admin@arkaria.postgresql.org; Fri, 20 Jun 2014 12:46:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WxyDD-0006s8-G6 for pgsql-admin@arkaria.postgresql.org; Fri, 20 Jun 2014 12:46:35 +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 1WxyDC-0006rs-9A for pgsql-admin@postgresql.org; Fri, 20 Jun 2014 12:46:34 +0000 Received: from nm3-vm6.bullet.mail.ne1.yahoo.com ([98.138.91.96]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1WxyD7-0007Vr-GF for pgsql-admin@postgresql.org; Fri, 20 Jun 2014 12:46:33 +0000 Received: from [98.138.226.176] by nm3.bullet.mail.ne1.yahoo.com with NNFMP; 20 Jun 2014 12:46:26 -0000 Received: from [98.138.89.166] by tm11.bullet.mail.ne1.yahoo.com with NNFMP; 20 Jun 2014 12:46:26 -0000 Received: from [127.0.0.1] by omp1022.mail.ne1.yahoo.com with NNFMP; 20 Jun 2014 12:46:26 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 567567.84348.bm@omp1022.mail.ne1.yahoo.com Received: (qmail 56477 invoked by uid 60001); 20 Jun 2014 12:46:26 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1403268386; bh=WPryLGE57Sw9OGBgchL7lKSWwXcThTV4W1Nc3h++gOY=; h=References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Eh957U9ogKe4QFE6WNRb46NijlXl69Gx3X+wyw+MY+L+fC1QTe5mksleIgUBOgOXHTJxtO92jwwdKtVaxI3QKRO7lslhsIH1v94stt3lFSNDy4dKtj/4zt6ZZPRFv8yUXTSj5Q8n6wc133DHdE4BupH235MBVNZkHGxvhU9/OVY= X-YMail-OSG: M44QDx4VM1n6VRLJi5XSeuy1wstrUrLAEqJp7FGfFmaL3t7 3ZIA.ZZUt73ihXggkylxo1jLJdK7m_B5YREme4q6TmCacF_C2rEm8HIWAwfO VSXqhlcYrv5EsxwANKCBe9oIpuFbUTiKelhMUymWTeM6vRk61NTsNythIyqw cbKcMN1gbxb0y0mA2t6D3zPePTHDBNXAQlAPF1uIq_EPQMkMw9bJXKIRh0PM .pPlUsPVAnhmk1HOL6GifPSjOoly5w4eE6HiAKjMEcsYvq7tm2ebv9hsUr4Y SIHKWUy9UCSevjQuHlRupxbRQQy6gtCvunYwHJZXxSt.x91MJabTQdzLDU8D ZeGzEjJUvssgPj9bQdaErXw_vV5t4CctBO16MhbwlrAabvobtpNwjA_adiZ0 qoPw045poHsSq5x3ZyVtfO2QjFFjPAQHFu.ZaBVnj2KSApef8MMwY_7624AY 6qvjCK2cjtEk91CJSG8k0.rPd.LwX.v0A7hY08pYuVnn39jYh3fcs0hsRUCG 4l__BVKPpl2hOejWx4IUCe2y3ZFA1.xhVsTvZtPm8WRfoIp9WnG1w1MvPXSG VkRITHCwCCnGXXIdYoTg1nlob590IBzudCGaGLSgkRSBPTEgYfC.FSqd9KDn YTU084tkQtY5Qk28lUFCadrC9.COg5v6KbpiOqtvKjV5oOSxiWnTkxpoU_Xb gy9bsOiw6 Received: from [24.178.25.147] by web122301.mail.ne1.yahoo.com via HTTP; Fri, 20 Jun 2014 05:46:26 PDT X-Rocket-MIMEInfo: 002.001, T2xpdmVyIDxvZmFiZWxvQGdtYWlsLmNvbT4gd3JvdGU6Cgo.ICQgbW9yZSBQR19WRVJTSU9OCj4gOS4zCgpJZiB5b3UgY2FuIHN0YXJ0IHRoZSBkYXRhYmFzZWQgc2VydmljZSBhbmQgY29ubmVjdCB0byBpdCwgdGhlIGJlc3QKd2F5IHRvIGNoZWNrIHRoZSB2ZXJzaW9uIGlzOgoKwqAgU0VMRUNUIHZlcnNpb24oKTsKCklmIHlvdSBjYW4ndCBzdGFydCB0aGUgc2VydmljZSwgeW91IGNhbiBkbyB0aGlzOgoKwqAgJCBwb3N0Z3JlcyAtLXZlcnNpb24KCihZb3UgbWF5IG5lZWQgdG8gc3BlY2lmeSB0aGUgcGF0aCABMAEBAQE- X-Mailer: YahooMailWebService/0.8.191.1 References: <8b8abf0c137c0dac2d29c163537a7ea2@imap.lan.net> Message-ID: <1403268386.87807.YahooMailNeo@web122301.mail.ne1.yahoo.com> Date: Fri, 20 Jun 2014 05:46:26 -0700 From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: Postgresql not getting assigned memory To: Oliver , Jan Lentfer Cc: "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable 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 Oliver wrote: > $ more PG_VERSION > 9.3 If you can start the databased service and connect to it, the best way to check the version is: =A0 SELECT version(); If you can't start the service, you can do this: =A0 $ postgres --version (You may need to specify the path to the postgres executable.) Either way you should be able to determine the minor release.=A0 It is always a good idea to keep up-to-date on minor releases (where the version number only changes to the right of the second dot), because in PostgreSQL we only include fixes for serious bugs and security vulnerabilities in minor releases, not new features.=A0 See this page for additional discussion of the issue: http://www.postgresql.org/support/versioning/ This is even more important than usual for 9.3, which had some data corruption bugs in early versions. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin