Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42151=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WBPoK-0001E1-3p
 for pgsql-admin@arkaria.postgresql.org; Thu, 06 Feb 2014 14:20:12 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42151=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WBPoJ-0004A9-B6
 for pgsql-admin@arkaria.postgresql.org; Thu, 06 Feb 2014 14:20:11 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sql-pgsql-admin@m.gmane.org>) id 1WBPoI-00049w-Fz
 for pgsql-admin@postgresql.org; Thu, 06 Feb 2014 14:20:10 +0000
Received: from plane.gmane.org ([80.91.229.3])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sql-pgsql-admin@m.gmane.org>) id 1WBPoE-0003MC-Nk
 for pgsql-admin@postgresql.org; Thu, 06 Feb 2014 14:20:09 +0000
Received: from list by plane.gmane.org with local (Exim 4.69)
 (envelope-from <sql-pgsql-admin@m.gmane.org>) id 1WBPoA-0006ia-Ee
 for pgsql-admin@postgresql.org; Thu, 06 Feb 2014 15:20:02 +0100
Received: from 195-202-234-210.dynamic.hispeed.ch ([195.202.234.210])
 by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
 id 1AlnuQ-0007hv-00
 for <pgsql-admin@postgresql.org>; Thu, 06 Feb 2014 15:20:02 +0100
Received: from stelian by 195-202-234-210.dynamic.hispeed.ch with local
 (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
 for <pgsql-admin@postgresql.org>; Thu, 06 Feb 2014 15:20:02 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-admin@postgresql.org
From: Stelian Iancu <stelian@iancu.ch>
Subject: Enable pg_stat_statements
Date: Thu, 06 Feb 2014 15:16:14 +0100
Lines: 23
Message-ID: <ld05en$cci$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: 195-202-234-210.dynamic.hispeed.ch
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9;
 rv:24.0) Gecko/20100101 Thunderbird/24.3.0
X-Pg-Spam-Score: -1.6 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi all,

I have Postgres 9.3.2 running on Debian 7.

I would like to enable the pg_stat_statements extension. In order to do 
this, I added the following line to postgresql.conf:

shared_preload_libraries = 'pg_stat_statements'

However after that the server fails to restart and I get the following 
error message:

Restarting PostgreSQL 9.3 database server: mainThe PostgreSQL server 
failed to start. Please check the log output: 2014-02-06 15:12:34 CET 
FATAL: could not access file "pg_stat_statements": No such file or 
directory ... failed!
  failed!

Any ideas why?

Thanks in advance!

S.



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin