pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  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:52  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Juan Miguel Paredes <juan.paredes@gmail.com>
  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