Re: [ADMIN] How to restore updated records

2007-06-19 Thread Aleksander Kmetec - INTERA
About 2 years ago a new guy at our company deleted all contents of a table on a development server and I managed to restore them by changing the XID value with pg_resetxlog. You can get last chackpoint's XID by running pg_controldata; then use pg_resetxlog -x and try different values. You'll ne

[ADMIN] Locale problems

2003-02-13 Thread Aleksander Kmetec
Hello! I have a db cluster which contains databases with LATIN2 encoding and some databases with UNICODE encoding. If I initalise the cluster with --locale=sl_SI option, then special characters in LATIN2 databases are sorted correctly, but special chars in UNICODE dbs end up in wrong places; a