On 2008-07-23 11:48, valgog wrote:
> Another question. Is it possible to change the current Database
> LC_CTYPE on the database without recreating it with initdb and
> reimporting all the data.
No.
> I would rather prefer my indexes recreated, rather then reimporting
> database (cannot afford such a long time out of service :(
You can use slony replication for minimal downtime (seconds), but it is
rather complicated.
You can also seriously reduce reimport time by:
- temporary disabling sync;
- temporary enabling hard disk write cache;
- importing and exporting concurrently with a pipe:
old_pgdata = /var/lib/pgsql/data
new_pgdata = /var/lib/pgsql/newdata
initdb -D $new_pgdata
postgres -p 10001 -F -D $new_pgdata &
su -c 'service postgresql stop'
postgres -p 10002 -F -D $old_pgdata &
pg_dumpall -p 10002 | pg_restore -p 10001
killall postgres
mv $old_pgdata $old_pgdata.bak
mv $new_pgdata $old_pgdata
su -c 'service postgresql start'
- importing and exporting from one disk or cluster to another
Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh