Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9FB9A2E2002 for ; Wed, 14 Nov 2007 16:52:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 66143-05 for ; Wed, 14 Nov 2007 16:52:16 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id EA3152E1A8C for ; Wed, 14 Nov 2007 16:52:18 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lAEKqHpG013619; Wed, 14 Nov 2007 15:52:17 -0500 (EST) To: "Juan Miguel Paredes" cc: pgsql-admin@postgresql.org Subject: Re: Error when trying to recover from filesystem backup In-reply-to: <9e0a28690711141221j3c7c2f04qf3fa0e7887d1d3ec@mail.gmail.com> References: <9e0a28690711141221j3c7c2f04qf3fa0e7887d1d3ec@mail.gmail.com> Comments: In-reply-to "Juan Miguel Paredes" message dated "Wed, 14 Nov 2007 16:21:02 -0400" Date: Wed, 14 Nov 2007 15:52:17 -0500 Message-ID: <13618.1195073537@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/125 X-Sequence-Number: 27368 "Juan Miguel Paredes" writes: > ... But when trying to > start Postgresql with the recovered location, we get the following > error: > " * Error: The server must be started under the locale : which does > not exist any more." There is no such message text in the standard Postgres distribution. I suppose this is another example of Debian's packager trying to be helpful. You might try looking through the startup script to see what it's testing exactly. As far as what PG itself thinks the locale should be, pg_controldata would tell you ... regards, tom lane