|

»

»

Problems with bootstrap and recovery

View: New views

7 Messages — Rating Filter: Alert me

	Problems with bootstrap and recovery by Rogerio Luz Coelho :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message I have a problem to recover a backup database: When fussing about I discovered this error while trying to simply bootstrap to latest ... on a postgresql 8.3 new instalation of a Debian Stable (Lenny) Your PostgreSQL installation seems not to have lc_ctype UTF-8 or C. This will most probably lead to failures of the GNUmed server installation. What to do now? This never happened before Rogerio _______________________________________________ Gnumed-devel mailing list Gnumed-devel@... http://lists.gnu.org/mailman/listinfo/gnumed-devel
	Re: Problems with bootstrap and recovery by Jerzy Luszawski :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Wednesday 28 October 2009 03:09:36 Rogerio Luz Coelho napisał(a): > I have a problem to recover a backup database: > When fussing about I discovered this error while trying to simply bootstrap > to latest ... > > on a postgresql 8.3 new instalation of a Debian Stable (Lenny) > > > > Your PostgreSQL installation seems not to have lc_ctype UTF-8 or C. > This will most probably lead to failures of the GNUmed server installation. > > > What to do now? I remember I also had this message some time ago, and just ignored it. The reason was that my locale is pl_PL.UTF-8 and it was not properly recognized as UTF-8. Try to use psql and check your encoding, see: -------------------- postgres=# show lc_ctype; lc_ctype ------------- pl_PL.UTF-8 (1 row) postgres=# show server_encoding; server_encoding ----------------- UTF8 (1 row) --------------------------- Can you force the bootstrap and check the encoding after bootstrapping? _______________________________________________ Gnumed-devel mailing list Gnumed-devel@... http://lists.gnu.org/mailman/listinfo/gnumed-devel
	Re: Problems with bootstrap and recovery by Karsten Hilbert :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message On Wed, Oct 28, 2009 at 09:47:20AM +0100, Jerzy Luszawski wrote: > > When fussing about I discovered this error while trying to simply bootstrap > > to latest ... > > > > on a postgresql 8.3 new instalation of a Debian Stable (Lenny) > > > > Your PostgreSQL installation seems not to have lc_ctype UTF-8 or C. > > This will most probably lead to failures of the GNUmed server installation. > > > > > > What to do now? Jerzy is right. Edit /usr/sbin/gm-bootstrap_server and comment out the "exit" inside the UTF-8 check. I guess we'll have to improve that check. It would also be useful to post the output of the below as Jerzy suggested: > Try to use psql and check your encoding, see: > -------------------- > postgres=# show lc_ctype; > lc_ctype > ------------- > pl_PL.UTF-8 > (1 row) > > postgres=# show server_encoding; > server_encoding > ----------------- > UTF8 > (1 row) > --------------------------- Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 _______________________________________________ Gnumed-devel mailing list Gnumed-devel@... http://lists.gnu.org/mailman/listinfo/gnumed-devel
	Re: Problems with bootstrap and recovery by Jim Busser :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message On 2009-10-28, at 7:01 AM, Karsten Hilbert wrote: > Jerzy is right. Edit /usr/sbin/gm-bootstrap_server and > comment out the "exit" inside the UTF-8 check. I guess we'll > have to improve that check. I notice in common that Jerzy has pl_PL.UTF-8 and Rogerio presumably pt_BR.po ... could this be any basis for the trip-up? _______________________________________________ Gnumed-devel mailing list Gnumed-devel@... http://lists.gnu.org/mailman/listinfo/gnumed-devel
	Re: Problems with bootstrap and recovery by Karsten Hilbert :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message On Wed, Oct 28, 2009 at 07:46:39AM -0700, Jim Busser wrote: > >Jerzy is right. Edit /usr/sbin/gm-bootstrap_server and > >comment out the "exit" inside the UTF-8 check. I guess we'll > >have to improve that check. > > I notice in common that Jerzy has pl_PL.UTF-8 and Rogerio presumably > pt_BR.po > > ... could this be any basis for the trip-up? I don't think so as the check greps for UTF-8 inside the string: psql -t -d template1 -c \"show lc_ctype;\" \| grep -q -e C -e UTF-8 Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 _______________________________________________ Gnumed-devel mailing list Gnumed-devel@... http://lists.gnu.org/mailman/listinfo/gnumed-devel
	Re: Problems with bootstrap and recovery by Rogerio Luz Coelho :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Ok after some getting-used-to I understood how to use psql :) so step 1) type 'su postgres' step 2) type 'psql' step 3) type 'show lc_ctype;' (the dot-comma IS important) step 4) type 'show server_encoding;' (again the dot-comma IS important) have the following result: postgres=# show lc_ctype; lc_ctype ---------- pt_BR (1 registro) postgres=# show server_encoding; server_encoding ----------------- LATIN1 (1 registro) I took the test out of the gm-bootstrap-server file, but it did not work ... Rogerio 2009/10/28 Karsten Hilbert <Karsten.Hilbert@...> On Wed, Oct 28, 2009 at 07:46:39AM -0700, Jim Busser wrote: > >Jerzy is right. Edit /usr/sbin/gm-bootstrap_server and > >comment out the "exit" inside the UTF-8 check. I guess we'll > >have to improve that check. > > I notice in common that Jerzy has pl_PL.UTF-8 and Rogerio presumably > pt_BR.po > > ... could this be any basis for the trip-up? I don't think so as the check greps for UTF-8 inside the string: psql -t -d template1 -c \"show lc_ctype;\" \| grep -q -e C -e UTF-8 Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 _______________________________________________ Gnumed-devel mailing list Gnumed-devel@... http://lists.gnu.org/mailman/listinfo/gnumed-devel _______________________________________________ Gnumed-devel mailing list Gnumed-devel@... http://lists.gnu.org/mailman/listinfo/gnumed-devel
	Re: Problems with bootstrap and recovery by Karsten Hilbert :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message On Wed, Oct 28, 2009 at 05:39:39PM -0200, Rogerio Luz Coelho wrote: > Ok after some getting-used-to I understood how to use psql :) That's Rogerio Braveheart as we know him ! ;-) > step 3) type 'show lc_ctype;' (the dot-comma IS important) > step 4) type 'show server_encoding;' (again the dot-comma IS important) The ";" tells psql that the user considers the input string finished and wants it executed. Otherwise it'll open a new line (yes, one can enter multi-line SQL). > postgres=# show lc_ctype; > lc_ctype > ---------- > pt_BR > (1 registro) > > postgres=# show server_encoding; > server_encoding > ----------------- > LATIN1 > (1 registro) :-( That server is set to LATIN1 as the base encoding. That truly won't work. You will want that to be either C or preferably UTF8. If I remember correctly under Debian Stable you may need to truly use C. > I took the test out of the gm-bootstrap-server file, but it did not work ... Yeah, because there's another (safer) check deep inside the bootstrapper to protect people from the above situation ;-)) Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 _______________________________________________ Gnumed-devel mailing list Gnumed-devel@... http://lists.gnu.org/mailman/listinfo/gnumed-devel