Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 326112E2E8F for ; Wed, 14 Nov 2007 16:21:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 58278-01-9 for ; Wed, 14 Nov 2007 16:21:15 -0400 (AST) Received: from rn-out-0102.google.com (rn-out-0910.google.com [64.233.170.191]) by postgresql.org (Postfix) with ESMTP id 1D11E2E2EEE for ; Wed, 14 Nov 2007 16:21:04 -0400 (AST) Received: by rn-out-0102.google.com with SMTP id s46so530117rnb for ; Wed, 14 Nov 2007 12:21:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=cJw0qMPY3ft6gQ9EUhB50bnDMaEqBLpTgN4OMZ4Msfw=; b=dJ6Axkwcl49e1Vfnos7imjPij1euRmBm1S/YC1EnzCgNPNkqBWU4idqVxu+oRpaOgJH2V55hExhBhKibDX47yELulSCzYgg1rsOQyUDf39kone1aOJExn2wSoRd+r8pTQ/vGLjnrepCYf20byelublHMlTTKiCXDKhWTl5Ty8AQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=KKUdI+UyA+Smo4WjbkenGMrYw68CDUCqNmR4122Mpqx1dwbFOnEOMWsCcFOFDFz2XuZENtYU6HFZehlmX8sADT9wXe45sHM2Z5aU9KsahfJjS8FEw+i0GlZ2x1BZnbzxmhDeH8TVMC7Q210pWOXN18rYFprfkJnhuOWkl9s9s84= Received: by 10.70.109.12 with SMTP id h12mr29934wxc.1195071662692; Wed, 14 Nov 2007 12:21:02 -0800 (PST) Received: by 10.70.59.8 with HTTP; Wed, 14 Nov 2007 12:21:02 -0800 (PST) Message-ID: <9e0a28690711141221j3c7c2f04qf3fa0e7887d1d3ec@mail.gmail.com> Date: Wed, 14 Nov 2007 16:21:02 -0400 From: "Juan Miguel Paredes" To: pgsql-admin@postgresql.org Subject: Error when trying to recover from filesystem backup MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/123 X-Sequence-Number: 27366 Hi, folks! Due to a hardware (hard disk) problem, we've tried to restore a postgresql filesystem backup (taken from what was left on the drive) to a fresh Postgresql install (as stated in http://www.postgresql.org/docs/8.1/interactive/backup-file.html), checking the appropiate ownership, privileges, etc. 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." Note that the message doesn't say which locale is (allegedly) missing!!! Both the crashed and the recovery machines have exactly the same locales, Postgresql version, etc (Debian Etch standard with postgresql-8.1 from main repositories), which makes the message a little confusing. Google didn't help much, either (I've found http://www.pg-forum.de/konfiguration/888-umzug-des-ordners-pgdata-auf-anderen-server.html but can't really understand german). Any hints to where should we look will be greatly appreciated!