pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Error when trying to recover from filesystem backup 2+ messages / 2 participants [nested] [flat]
* Error when trying to recover from filesystem backup @ 2007-11-14 20:21 Juan Miguel Paredes <juan.paredes@gmail.com> 2007-11-14 20:52 ` Re: Error when trying to recover from filesystem backup Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Juan Miguel Paredes @ 2007-11-14 20:21 UTC (permalink / raw) To: pgsql-admin 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! ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Error when trying to recover from filesystem backup 2007-11-14 20:21 Error when trying to recover from filesystem backup Juan Miguel Paredes <juan.paredes@gmail.com> @ 2007-11-14 20:52 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2007-11-14 20:52 UTC (permalink / raw) To: Juan Miguel Paredes <juan.paredes@gmail.com>; +Cc: pgsql-admin "Juan Miguel Paredes" <juan.paredes@gmail.com> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-11-14 20:52 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-11-14 20:21 Error when trying to recover from filesystem backup Juan Miguel Paredes <juan.paredes@gmail.com> 2007-11-14 20:52 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox