From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Date: Thu, 13 Dec 2007 15:07:33 +0300 From: Alex Gorbachenko To: sisyphus@lists.altlinux.org Message-ID: <20071213150733.0a37a503@satellite.immo> In-Reply-To: <47611780.4030208@ukr.net> References: <47610BA5.301@ukr.net> <20071213135704.0aaa62cc@satellite.immo> <47611780.4030208@ukr.net> Organization: Inform-Mobil Ltd. X-Mailer: Claws Mail 3.1.0cvs26 (GTK+ 2.12.3; x86_64-alt-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/Opemqu=5qsZI9aQgOZWNcXK"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Virus-Scanned: amavisd-new at immo.ru Subject: Re: [sisyphus] =?windows-1251?b?8e3u4uAg4u7v8O7xIO4g8e7w8ujw7uLq5SDi?= =?windows-1251?b?IO/u8fLj8OXx5Q==?= X-BeenThere: sisyphus@lists.altlinux.org X-Mailman-Version: 2.1.9 Precedence: list Reply-To: ALT Linux Sisyphus discussions List-Id: ALT Linux Sisyphus discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 13 Dec 2007 12:07:39 -0000 Archived-At: List-Archive: List-Post: --Sig_/Opemqu=5qsZI9aQgOZWNcXK Content-Type: text/plain; charset=Windows-1251 Content-Transfer-Encoding: quoted-printable On Thu, 13 Dec 2007 13:29:04 +0200 Serge wrote: >lc_collate ru_RU.KOI8-R >lc_ctype ru_RU.KOI8-R =ED=F3 =E2=EE=F2, =F1=EE=E1=F1=F2=E2=E5=ED=ED=EE, =E8 =EF=F0=E8=F7=E8=ED=E0= =E7=E0=F1=EE=F0=E0. LC_COLLATE =E8 LC_CTYPE =E7=E0=E4=E0=FE=F2=F1=FF =EF=F0=E8 =E8=ED=E8=F6=E8=E0=EB=E8=E7=E0=F6=E8=E8 =EA=EB=E0=F1=F2=E5=F0=E0,= =EF=EE=F1=EB=E5 =F7=E5=E3=EE =E8=F5 =E8=E7=EC=E5=ED=E8=F2=FC =ED=E5=EB=FC= =E7=FF. =EA=E0=EA =F1=EB=E5=E4=F1=F2=E2=E8=E5, =E5=F1=EB=E8 initdb =E1=FB=EB =E2=FB=EF=EE=EB= =ED=E5=ED =F1 =EB=EE=EA=E0=EB=FC=FE KOI, =EF=EE=EB=F3=F7=E0=E5=EC =EF=F0=EE= =E1=EB=E5=EC=FB =F1 =F1=EE=F0=F2=E8=F0=EE=E2=EA=E0=EC=E8 =E8 =F0=E0=E1=EE=F2=EE=E9 =F4-=F6=E8= =E9 upper()/lower() =E2=EE =E2=F1=E5=F5 =C1=C4 =EA=EB=E0=F1=F2=E5=F0=E0, =EA=EE=E4=E8=F0=EE=E2=EA=E0 =EA=EE=F2=EE=F0=FB=F5 =EE=F2=EB=E8=F7=ED=E0 =EE= =F2 =F2=EE=E9, =F1 =EA=EE=F2=EE=F0=EE=E9 =EA=EB=E0=F1=F2=E5=F0 =E8=ED=E8=F6= =E8=E0=EB=E8=E7=E8=F0=EE=E2=E0=EB=E8. =F1=F3=F9=E5=F1=F2=E2=F3=E5=F2 =E4=E2=E0 =F1=EF=EE=F1=EE=E1=E0 =F0=E5=F8=E5= =ED=E8=FF =E4=E0=ED=ED=EE=E9 =EF=F0=EE=E1=EB=E5=EC=FB.=20 =EF=F0=E5=F0=E2=FB=E9. =F1=E4=E0=EC=EF=E8=F2=FC =E1=E0=E7=F3, =EE=F1=F2=E0= =ED=EE=E2=E8=F2=FC =EF=EE=F1=F2=E3=F0=E5=F1, =F3=E4=E0=EB=E8=F2=FC =F1=EE= =E4=E5=F0=E6=E8=EC=EE=E5 =EA=E0=F2=E0=EB=EE=E3=E0 =F1 =E4=E0=ED=ED=FB=EC=E8 (/var/lib/pgsql/data/*, =EF=F0=E5=E4=E2=E0=F0=E8= =F2=E5=EB=FC=ED=EE =F1=EE=F5=F0=E0=ED=E8=E2 =EA=EE=ED=F4=E8=E3=E8 =E8=E7 =ED=E5=E3=EE). =E7=E0=F2=E5=EC =E2=FB=EF=EE=EB=ED=E8=F2=FC:=20 echo "LANG=3Dru_RU.UTF-8" > /var/lib/pgsql/data/.18n =EF=EE=E4=ED=FF=F2=FC =EF=EE=F1=F2=E3=F0=E5=F1, =F1=EE=E7=E4=E0=F2=FC =E1= =E0=E7=F3, =E7=E0=EB=E8=F2=FC =E2 =ED=E5=B8 =F1=EE=E4=E5=F0=E6=E8=EC=EE=E5 = =E4=E0=EC=EF=E0. =FD=F2=EE =EE=F4=E8=F6=E8=E0=EB=FC=ED=EE =F0=E5=EA=EE=EC=E5=ED=E4=EE=E2=E0=ED=FB=E9 = =F1=EF=EE=F1=EE=E1. =F1=EF=EE=F1=EE=E1 =E2=F2=EE=F0=EE=E9. =EE=F4=E8=F6=E8=E0=EB=FC=ED=EE =E5= =E3=EE =E2=EE=EE=E1=F9=E5 =ED=E5 =F1=F3=F9=E5=F1=F2=E2=F3=E5=F2, =E8 =ED=E8= =E2 =EE=E4=ED=EE=E9 =F0=E0=F1=F1=FB=EB=EA=E5 =EF=EE postgresql =E2=E0=EC =E5=E3=EE =ED=E8=EA=EE= =E3=E4=E0 =ED=E5 =F0=E0=F1=F1=EA=E0=E6=F3=F2 :) =F1=F0=E0=E7=F3 =EF=F0=E5=E4=F3=EF=F0=E5=E6=F3, =F7=F2=EE =FF =F1=E0=EC =F2=E0=EA =E4=E5=EB= =E0=F2=FC =F2=EE=E6=E5 =ED=E5 =F0=E5=EA=EE=EC=E5=ED=E4=F3=FE, =EF=EE=F2=EE= =EC=F3 =F7=F2=EE =E2=E5=F0=EE=FF=F2=ED=EE=F1=F2=FC =EF=EE=F2=E5=F0=E8 =E4=E0=ED=ED=FB=F5 =E2= =E5=EB=E8=EA=E0. =E8=F2=E0=EA.=20 1. =CE=F2=EA=EB=FE=F7=E8=F2=FC =F1=E5=F2=FC =E2 postgresql; 2. service postgresql restart. =DD=F2=EE =EF=EE=E7=E2=EE=EB=E8=F2 =F1=E1=F0= =EE=F1=E8=F2=FC =E2=F1=E5 =F1=E5=F2=E5=E2=FB=E5 =F1=EE=E5=E4=E8=ED=E5=ED=E8=FF =E8 =EA=EE=F0=F0=E5=EA=F2=ED=EE =E7=E0=E2=E5= =F0=F8=E8=F2=FC =E2=F1=E5 =F2=F0=E0=ED=E7=E0=EA=F6=E8=E8; 3. service postgresql stop; 4. cp -a /var/lib/pgsql-root/var/lib/pgsql/data/global/ /root - =F1=EF=E0= =F1=E0=E5=EC =F1=EB=F3=E6=E5=E1=ED=F3=FE =E8=ED=F4=EE=F0=EC=E0=F6=E8=FE; 5. subst "s,KOI8-R,UTF8,g" /var/lib/pgsql-root/var/lib/pgsql/data/global/pg_control - =E8=E7=EC=E5=ED=FF=E5=EC =E7=ED=E0=F7=E5=ED=E8=FF LC_COLLATE =E8 LC_CTYPE= =20 6. su -l postgres -s /bin/bash - =EF=EE=EB=F3=F7=E0=E5=EC shell =F1 =EF=F0= =E0=E2=E0=EC=E8 =F1=F3=EF=E5=F0=EF=EE=EB=FC=E7=EE=E2=E0=F2=E5=EB=FF =C1=C4. 7. pg_resetxlog -n /var/lib/pgsql/data - =E7=E0=EF=EE=EC=E8=ED=E0=E5=EC =E7= =ED=E0=F7=E5=ED=E8=FF =ABLatest checkpoint's NextXID=BB =E8 =ABLatest checkpoint's NextOID=BB. =F0=E0=E7=F3= =EC=ED=E5=E5 =FD=F2=EE=F2 =FD=F2=E0=EF =E4=E5=EB=E0=F2=FC =E4=EE =FD=F2=E0=EF=E0 5 :) 8. cp -a /var/lib/pgsql/data/pg_xlog /var/lib/pgsql/data/pg_xlog.old - =ED=E0 =F1=EB=F3=F7=E0=E9, =E5=F1=EB=E8 =E2=E0=EC =ED=F3=E6=ED=FB =F1=F2=E0= =F0=FB=E5 =EB=EE=E3=E8 =F2=F0=E0=ED=E7=E0=EA=F6=E8=E9. =FD=F2=E0=EF =ED=E5= =EE=E1=FF=E7=E0=F2=E5=EB=FC=ED=FB=E9. 9. pg_resetxlog -o =ABLatest checkpoint's NextOID=BB -x =ABLatest checkpoint's NextXID=BB -f /var/lib/pgsql/data - =F7=E8=ED=E8=EC =F1=EB=F3= =E6=E5=E1=ED=FB=E9 =F4=E0=E9=EB, =EA=EE=F2=EE=F0=FB=E9 =E8=F1=EA=EE=F0=B8=E6=E8=EB=E8 =ED=E0 =FD=F2=E0=EF=E5= 5. =EF=EE=F1=EB=E5 =E8=F1=EF=F0=E0=E2=EB=E5=ED=E8=FF =E2=FB=E2=E5=E4=E5=F2= =F1=FF =E4=E8=E0=E3=ED=EE=F1=F2=E8=EA=E0, =E8=E7 =EA=EE=F2=EE=F0=EE=E9 =EC=EE=E6=ED=EE =E1=F3=E4=E5=F2 =EF=EE=ED=FF= =F2=FC, =ED=E0=F1=EA=EE=EB=FC=EA=EE =F3=F1=EF=E5=F8=ED=EE =EF=F0=EE=F8=B8= =EB =EF=F0=EE=F6=E5=F1=F1. 10. =E5=F1=EB=E8 =E2=F1=B8 =F5=EE=F0=EE=F8=EE, =E8 pg_controldata /var/lib= /pgsql/data =ED=E5 =E2=FB=E4=E0=B8=F2 =F0=F3=E3=E0=ED=E8, =F2=EE =EC=EE=E6=ED=EE =EF=EE=E4=ED=FF=F2=FC postgresql= .=20 =E5=F1=EB=E8 =EF=EB=EE=F5=EE, =F2=EE =ED=F3=E6=ED=EE =E2=E5=F0=ED=F3=F2=FC = =ED=E0 =EC=E5=F1=F2=EE =EA=E0=F2=E0=EB=EE=E3=E8 global =E8 pg_xlog. --=20 np: As I Lay Dying - Repeating yersterday --Sig_/Opemqu=5qsZI9aQgOZWNcXK Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.7 (GNU/Linux) iD8DBQFHYSCKnBAcpC5E7HkRAkhjAJ4jrSWDRt057fZfPrBmz7IalZ9BfQCeOJps fSzZZLu5ZbikKqpylxNjees= =FJZ+ -----END PGP SIGNATURE----- --Sig_/Opemqu=5qsZI9aQgOZWNcXK--