Ubuntu
postgresql-8.2 package

  1. Bug #162517
  2. Comment #31

Comment 31 for bug 162517

Revision history for this message
Martin Pitt (pitti) wrote : Re: [Bug 162517] Re: postgresql does not start

Hi Wolf,

Wolf Rogner [2008-01-24 20:46 -0000]:
> Tried to understand what I did wrong (I administer my machine using
> webmin. So setting all locales during the installation process was
> not required. webmin covers most locale handling). Hope I did.

If you changed the locales in webmin, then webmin apparently has a bug
that it does not actually create the locales you set.

> 5. Thank you for patience and even putting up with my bad temper

Sorry in return for becoming a bit rude in my previous reply.

> 6. (I dare not say it) how can I change the location of my database :-?

On cluster creation: pg_createcluster -d /path/to/data/dir (see
manpage).

On already existing clusters:
 - stop the db (init script or pg_ctlcluster)
 - move /var/lib/postgresql/8.2/main to whereever you want
 - do either of (whichever you like more):
   * change the /etc/postgresql/8.2/main/pgdata symlink to the new
     location
   * set data_directory in /etc/postgresql/8.2/main/postgresql.conf
     and remove above symlink [1]

Martin

[1] I know that removal of the symlink should not be necessary, the
config file option should trump the pgdata symlink. This is fixed in
the current versions in Hardy.