From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.2.3 (2007-08-08) on sa.int.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-1.1 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=3.2.3 Date: Wed, 26 Dec 2007 11:24:16 +0300 From: =?koi8-r?B?5MXOydMg883J0s7P1w==?= To: ALT Linux sysadmin discuss Message-ID: <20071226082416.GA9694@mw.local.seiros.ru> References: <20071222134213.GF18259@osdn.org.ua> <200712232158.45132.pechnikov@sandy.ru> <200712232119.28602.pechnikov@sandy.ru> <200712231805.24298.pechnikov@sandy.ru> <476E641C.5070506@sattaroff.name> <200712231543.47016.pechnikov@sandy.ru> <476E31E5.3070007@sattaroff.name> <20071225093900.GS26614@osdn.org.ua> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="xHFwDpU9dbj6ez1V" Content-Disposition: inline In-Reply-To: Subject: Re: [Sysadmins] =?koi8-r?b?z9DUyc3J2sHDydEgxMnTy8/Xz8og0M/E08nT1MXN?= =?koi8-r?b?2SAobGludXggbXVsdGktZGlzayBzZXJ2ZXIgaG93dG8pICh3YXM6?= =?koi8-r?b?IE9wZW5WWiwgVlNlcnZlciDJINDPzNXExdPR1M/LKQ==?= X-BeenThere: sysadmins@lists.altlinux.org X-Mailman-Version: 2.1.9 Precedence: list Reply-To: ALT Linux sysadmin discuss List-Id: ALT Linux sysadmin discuss List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 26 Dec 2007 08:25:01 -0000 Archived-At: List-Archive: --xHFwDpU9dbj6ez1V Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Dec 25, 2007 at 06:51:51PM +0300, Eugene Prokopiev wrote: >> =EE=C1 =D7=D3=D1=CB=C9=CA =D3=CC=D5=DE=C1=CA =CE=C1=D0=CF=CD=C9=CE=C1=C0= =CC=C0=C2=C9=D4=C5=CC=D1=CD =D0=CF=D2=C1=D3=CB=C9=C4=D9=D7=C1=D4=D8 =D7=D3= =C5 =D0=CF =D2=C1=DA=CE=D9=CD >> =DB=D0=C9=CE=C4=C5=CC=D1=CD =CF tablespaces =D7 =D0=CF=D3=D4=C7=D2=C5=D3= =C5. =F2=C1=D3=CB=C9=C4=D9=D7=C1=D4=D8 =CF=D4=C4=C5=CC=D8=CE=D9=C5 =D4=C1= =C2=CC=C9=DE=CB=C9 =D0=CF >> =D2=C1=DA=CE=D9=CD =DB=D0=C9=CE=C4=C5=CC=D1=CD =CD=CF=D6=C5=D4 =C2=D9=D4= =D8 =CF=CA =CB=C1=CB =D0=CF=CC=C5=DA=CE=CF. EP> =E1 =D2=C1=D3=CB=C9=C4=D9=D7=C1=D4=D8 =CF=D4=C4=C5=CC=D8=CE=CF =C4=C1= =CE=CE=D9=C5 =C9 =C9=CE=C4=C5=CB=D3=D9? =F2=C1=DA=D5=CD=C5=C5=D4=D3=D1 =D4=CF=D6=C5 =D0=CF=CC=C5=DA=CE=CF :) =EB=D3=D4=C1=D4=C9 =D1 =CF=C2 =DC=D4=CF=CD =D0=CF=DE=C5=CD=D5-=D4=CF =CE=C5= =DA=C1=C4=D5=CD=D9=D7=C1=CC=D3=D1, =C1 =D2=C5=DA=D5=CC=D8=D4=C1=D4-=D4=CF = =C4=CF=D3=D4=C9=C7=C1=C5=D4=D3=D1 =DC=CC=C5=CD=C5=CE=D4=C1=D2=CE=CF =C9, =CB=C1=CB =CD=CE=C5 =CB=C1=D6=C5=D4= =D3=D1, =D7=CF =CD=CE=CF=C7=C9=C8 =D3=CC=D5=DE=C1=D1=C8 =D3=D5=DD=C5=D3=D4= =D7=C5=CE=CE=D9=CA... EP> =E5=D3=D4=D8 =D5 =CD=C5=CE=D1 =D6=C5=CC=C5=DA=CB=C1, =D7 =CB=CF=D4=CF= =D2=D5=C0 =CD=CF=D6=CE=CF =D7=CF=D4=CB=CE=D5=D4=D8 =CE=C5 =C2=CF=CC=C5=C5 2= -=C8 EP> SATA-=C4=C9=D3=CB=CF=D7, =C9 =D4=D2=C5=C2=D5=C5=D4=D3=D1 =D0=CF=C4=CE= =D1=D4=D8 =CE=C1 =CE=C5=CA =D0=CF=D3=D4=C7=D2=C5=D3. =F3=C1=CD=C1 =D3=C9=D3= =D4=C5=CD=C1 =D7=CD=C5=D3=D4=C5 EP> =D3=CF =D7=D3=C5=CD=C9 =D3=CB=D2=C9=D0=D4=C1=CD=C9 =C3=C5=CE=CE=C5=C5, = =DE=C5=CD =C4=C1=CE=CE=D9=C5, =CB=CF=D4=CF=D2=D9=C5 =CC=C5=D6=C1=D4 =C5=DD= =C5 =C9 =D7 =D3=C5=CA=C6=C5 =CE=C1 EP> DVD-R =C9 =CB=CF=D4=CF=D2=D9=C5 =CD=CF=D6=CE=CF =DA=C1=CC=C9=D4=D8 =D0= =CF=D7=D4=CF=D2=CE=CF, =CE=CF =D6=C5=CC=C1=D4=C5=CC=D8=CE=CF =D7 =E2=E4 =C4= =C5=D2=D6=C1=D4=D8 =CB=C1=CB EP> =CD=CF=D6=CE=CF =C2=CF=CC=D8=DB=C5 =C4=C1=CE=CE=D9=C8 =C9 =C4=C5=CC=C1= =D4=D8 =D7=D9=C2=CF=D2=CB=C9 =C9=DA =CE=C9=C8 =CB=C1=CB =CD=CF=D6=CE=CF =C2= =D9=D3=D4=D2=C5=C5. EP> =F3=CF=CF=D4=D7=C5=D3=D4=D7=C5=CE=CE=CF, =D3=C9=D3=D4=C5=CD=D5 =D0=CC= =C1=CE=C9=D2=D5=C5=D4=D3=D1 =C4=C5=D2=D6=C1=D4=D8 =CE=C1 RAID1, =C1 =D7=CF= =D4 =C4=C1=CE=CE=D9=C5 EP> =CE=C5=D0=CF=CE=D1=D4=CE=CF. =F4.=C5. =C1=CC=D8=D4=C5=D2=CE=C1=D4=C9=D7= =D9 XFS =CE=C5=D4, =C1 =D7=CF=D4 =DE=D4=CF =CE=C9=D6=C5? =F7=C1=D2=C9=C1=CE= =D4=D9: =E4=CC=D1 =E2=E4 ext3 =D3 data=3Djournal =D2=C1=C2=CF=D4=C1=C5=D4 =CF=DE=C5= =CE=D8 =C4=C1=D6=C5 =DA=C1=CD=C5=DE=C1=D4=C5=CC=D8=CE=CF. =F1 =CE=C5 =D0=D2= =CF=C2=CF=D7=C1=CC =D0=D2=CF=D7=CF=C4=C9=D4=D8 =D4=C5=D3=D4=C9=D2=CF=D7=C1=CE=C9=C5 =DE=D4=CF = =D2=C5=C1=CC=D8=CE=CF =CC=D5=DE=DB=C5. EP> 2) =C4=C1=CE=CE=D9=C5 =CE=C1 =CF=C4=CE=CF=CD =C4=C9=D3=CB=C5, =CC=CF=C7= =C9 =CE=C1 =C4=D2=D5=C7=CF=CD - =CE=CF =CC=CF=C7=C9 =DA=C1=CE=C9=CD=C1=C0=D4 EP> =DA=CE=C1=DE=C9=D4=C5=CC=D8=CE=CF =CD=C5=CE=D8=DB=C5 =CD=C5=D3=D4=C1, = =DE=C5=CD =C4=C1=CE=CE=D9=C5 - =C1 =CD=C5=D3=D4=C1 =D6=C1=CC=CB=CF =F5 =D4=C5=C2=D1 =C4=D7=C1 =C4=C9=D3=CB=C1. =F2=C1=D3=CB=C9=C4=D7=C1=CA =C4= =C1=CE=CE=D9=C5 =D0=CF =CE=C9=CD =D4=C1=CB, =DE=D4=CF=C2=D9 =CE=C1=C7=D2=D5= =DA=CB=C1 =C2=D9=CC=C1 =C2=CF=CC=C5=C5-=CD=C5=CE=C5=C5 =D2=C1=D7=CE=CF=CD=C5=D2=CE=C1=D1. =F4=CF = =C5=D3=D4=D8 =CC=CF=C7=C9 =C4=C1, =CE=C1 =CF=C4=C9=CE. =ED=CF=D6=CE=CF =C5= =DD=C5 =DE=D4=CF-=D4=CF =CE=C1 =CE=C5=C7=CF =D6=C5. =EC=CF=C7=C9, =CB=D3=D4=C1=D4=C9, =CC=D5=DE=DB=C5 =D7=D3=C5=C7=CF =C4=C5=CA= =D3=D4=D7=C9=D4=C5=CC=D8=CE=CF =CE=C1 XFS. EP> 3) =C4=C1=CE=CE=D9=C5 =CE=C1 =CF=C4=CE=CF=CD =C4=C9=D3=CB=C5, =C9=CE=C4= =C5=CB=D3=D9 =CE=C1 =C4=D2=D5=C7=CF=CD - =CB=D5=C4=C1 =D4=CF=C7=C4=C1 =C4= =C5=D7=C1=D4=D8 =CC=CF=C7=C9? EP> =D2=C1=DA=CD=C1=DA=D9=D7=C1=D4=D8 =D0=CF =C4=D7=D5=CD =C4=C9=D3=CB=C1= =CD =D7 =D7=C9=C4=C5 RAID0? =EE=C1=C6=C9=C7-=CE=C1=C6=C9=C7! RAID0, =CB=D3=D4=C1=D4=C9, =DE=D4=CF=C2=D9= =C4=C1=D7=C1=CC =D5=D3=CB=CF=D2=C5=CE=C9=C5 =C1 =CE=C5 =D4=CF=D2=CD=CF=DA= =C1 =C5=DD=C5 =D4=C0=CE=C9=D4=D8 =CE=C1=C4=CF. =E4=CC=D1 =CC=CF=C7=CF=D7 =D5 =CD=C5=CE=D1 =C5=D3=D4=D8 =D3= =CF=CD=CE=C5=CE=C9=D1 =D7 =D0=CF=CC=D8=DA=C5 =D4=C1=CB=CF=C7=CF =C4=C5=CA= =D3=D4=D7=C9=D1. EP> =E5=D3=CC=C9 =C4=C5=CC=C1=D4=D8 =D4=CF =D6=C5 =CE=C1 =D4=D2=C5=C8 =C4= =C9=D3=CB=C1=C8, =D4=CF =CE=C1 =D4=D2=C5=D4=C9=CA =CC=D5=DE=DB=C5 =D7=D9=CE= =CF=D3=C9=D4=D8 =CC=CF=C7=C9 EP> =D0=CF=D3=D4=C7=D2=C5=D3=C1 =C9 =CC=CF=C7=C9 XFS =CF=C4=CE=CF=D7=D2=C5= =CD=C5=CE=CE=CF? =E8=CF=D2=CF=DB=C9=CA =D7=CF=D0=D2=CF=D3. =F1 =CE=C5 =DA=CE=C1=C0 =CE=C1 = =CE=C5=C7=CF =CF=D4=D7=C5=D4=C1, =CB =D3=CF=D6=C1=CC=C5=CE=C9=C0. >> =F6=C1=CC=D8 =D7 =D0=CF=D3=D4=C7=D2=C5=D3=C5 =C4=CF =D3=C9=C8 =D0=CF=D2 = =CE=C5=CC=D8=DA=D1 =C4=C5=CC=C1=D4=D8 =C9=CE=C4=C5=CB=D3=D9 =D3=D2=C1=DA=D5= =D0=CF =D7=D3=C5=CD >> =CE=C1=D3=CC=C5=C4=CE=C9=CB=C1=CD =CB=CF=CE=CB=D2=C5=D4=CE=CF=CA =D4=C1= =C2=CC=C9=C3=D9 (=CE=C5=CF=C2=C8=CF=C4=C9=CD=CF =C4=CC=D1 unique =DA=CE=C1= =DE=C5=CE=C9=CA), =CB=CF=C7=C4=C1 >> =DC=D4=CF =D0=CF=D1=D7=C9=D4=D3=D1, =C2=D5=C4=C5=D4 =D7=CF=CF=C2=DD=C5 = =DE=D5=C4=C5=D3=CE=C1=D1 =D7=CF=DA=CD=CF=D6=CE=CF=D3=D4=D8 =D0=D2=C1=CB=D4= =C9=DE=C5=D3=CB=C9 =CE=C5 =D4=D2=CF=C7=C1=D1 >> frontend =D7=D9=CB=C9=C4=D9=D7=C1=D4=D8 =D2=C5=C4=CB=CF =C9=D3=D0=CF=CC= =D8=DA=D5=C5=CD=D9=C5 _=CF=D4=C4=C5=CC=D8=CE=D9=C5 row_ =CE=C1 =C4=D2=D5=C7= =CF=CA >> =DB=D0=C9=CE=C4=C5=CC=D8. EP> =ED=CF=D6=CE=CF =DE=D5=D4=D8 =D0=CF=C4=D2=CF=C2=CE=C5=C5: =CB=C1=CB =C6= =CF=D2=CD=D5=CC=C9=D2=D5=C5=D4=D3=D1 =DA=C1=C4=C1=DE=C1 =C9 =DE=D4=CF =C8= =CF=DE=C5=D4=D3=D1 =D0=CF=CC=D5=DE=C9=D4=D8? =EB=D2=C1=D4=CB=C1=D1 =D7=D7=CF=C4=CE=C1=D1: =F7 =D0=CF=D3=D4=C7=D2=C5=D3=C5 =C5=D3=D4=D8 =DA=C1=DE=C1=D4=CB=C9 =CF=C2= =DF=C5=CB=D4=CE=CF-=CF=D2=C9=C5=CE=D4=C9=D2=CF=D7=C1=CE=CE=CF=D3=D4=C9. =F7= =D4=CF=CD =DE=C9=D3=CC=C5 "=CE=C1=D3=CC=C5=C4=CF=D7=C1=CE=C9=C5". =F4=C1=CB =D7=CF=D4, =CB =D0=D2=C9=CD=C5=D2=D5, =CD=CF=D6=CE=CF =D3=C4=C5= =CC=C1=D4=D8 =D4=C1=C2=CC=C9=DE=CB=D5: CREATE TABLE blabla ( blabla_id SERIAL PRIMARY KEY, cooldata VARCHAR, is_old BOOLEAN NOT NULL CHECK(is_old =3D=3D 'f') ); CREATE TABLE blabla_old LIKE blabla( CHECK(is_old =3D=3D 't') ); =F2=C5=C1=CC=D8=CE=CF =D3=CF=DA=C4=C1=CC=CF=D3=D8 =C4=D7=C5 =D4=C1=C2=CC=C9= =C3=D9. =F3=C1=CD=CF=C5 =C9=CE=D4=C5=D2=C5=D3=CE=CF=C5 =D7 =DC=D4=CF=CD =D4= =CF, =DE=D4=CF =C5=D3=CC=C9 =CD=D9 =DA=C1=D0=CF=CC=CE=C9=CD =C9=C8 =C4=C1=CE=CE=D9=CD=C9, =C1 =C4=C1=CC=D8=DB= =C5 =D7=D9=D0=CF=CC=CE=C9=CD =CB=CF=CD=C1=CE=C4=D5: SELECT * FROM blabla*; =D4=CF =CD=D9 =D0=CF=CC=D5=DE=C9=CD =C4=C1=CE=CE=D9=C5 =C9=DA =CF=C2=C5=C9= =C8 (!) =D4=C1=C2=CC=C9=C3. =E1 =C5=D3=CC=C9: SELECT * FROM blabla* WHERE is_old =3D 'f'; =F4=CF =CE=C9=CB=C1=CB=C9=C8 =CF=C2=D2=C1=DD=C5=CE=C9=CA =CB =D7=D4=CF=D2= =CF=CA =D4=C1=C2=CC=C9=C3=C5 =CE=C5 =C2=D5=C4=C5=D4 =D7=CF=CF=C2=DD=C5. =F3=CF=C2=D3=D4=D7=C5=CE=CE=CF =CF=D0=C9=D3=C1=CE=C9=C5 =C4=CF=D3=D4=C1=D4= =CF=DE=CE=CF =CB=D2=C1=D4=CB=CF=C5, =D4=C1=CD =CE=C1=C4=CF =C5=DD=C5 =DE=D5= =D4=CF=DE=CB=D5 =D3 =C2=D5=C2=CE=CF=CD =D0=CF=D0=CC=D1=D3=C1=D4=D8 =DE=D4=CF=C2=D9 =DC=D4=CF =DA=C1=D2=C1=C2=CF=D4= =C1=CC=CF, =CE=CF =D0=CF=D4=C5=CE=C3=C9=C1=CC =D5 =DC=D4=CF=C7=CF =D2=C5=DB= =C5=CE=C9=D1 =CF=C7=D2=CF=CD=CE=D9=CA. =E1 =D7=CF=D4 =DA=C1=D3=C1=C4=C1 =D3=CC=C5=C4=D5=C0=DD=C1=D1 -- blabla_id = =CE=C5 =D5=CE=C9=CB=C1=CC=C5=CE =C4=CC=D1 =DC=D4=CF=CA =C7=D2=D5=D0=D0=D9 = =D4=C1=C2=CC=C9=C3, =CF=CE =D5=CE=C9=CB=C1=CC=C5=CE =D4=CF=CC=D8=CB=CF =D7 =D0=D2=C5=C4=C5=CC=C1=C8 = =CF=C4=CE=CF=CA =D4=C1=C2=CC=C9=C3=D9. =F0=D2=C9 =DC=D4=CF=CD =C2=CC=C1=C7= =CF=C4=C1=D2=D1 =D4=CF=CD=D5 =DE=D4=CF =CF=CE SERIAL =CF=CE =D0=D2=C9 =DA=C1=D0=CF=CC=CE=C5=CE=C9=C9 =C2=D5=C4=C5=D4 =D7= =D2=CF=C4=C5 =CB=C1=CB =CB=C1=DA=C1=D4=D8=D3=D1 =D5=CE=C9=CB=C1=CC=D8=CE=D9= =CD (=CE=C1 =D7=D3=C5 =D4=C1=C2=CC=C9=C3=D9 =C2=D5=C4=C5=D4 =CF=C4=CE=C1 sequence), =CE=CF insert= /update =D3 =D5=CB=C1=DA=C1=CE=C9=C5=CD =CB=CF=CE=CB=D2=C5=D4=CE=CF=C7=CF =DA=CE=C1=DE=C5=CE=C9=D1 =C4=CC=D1 blabla_id =DC=D4=D5 =C9=C4=C9=CC=CC=C9= =C0 =D2=C1=DA=D2=D5=DB=C1=D4. =F7=D3=C5 =DE=D4=CF =D1 =D3=C5=CA=DE=C1=D3 =D2=C1=D3=D3=CB=C1=DA=D9=D7=C1= =C0 =CF=D0=C9=D3=C1=CE=CF =D7 =C4=CF=CB=D5=CD=C5=CE=D4=C1=C3=C9=C9 =CE=C1 = =D0=CF=D3=D4=C7=D2=C5=D3 =C7=CF=D2=C1=DA=C4=CF =D0=CF=C4=D2=CF=C2=CE=C5=C5, =D3 =CF=D0=C9=D3=C1=CE=C9=C5=CD =CD=CE=CF=D6= =C5=D3=D4=D7=C1 =D0=CF=C4=D7=CF=C4=CE=D9=C8 =C7=D2=C1=C2=CC=C5=CA =C9 =D0= =D2=CF=DE=C9=C8 =D0=D2=C9=D1=D4=CE=CF=D3=D4=C5=CA. --=20 =F3 =D5=D7=C1=D6=C5=CE=C9=C5=CD, =E4=C5=CE=C9=D3 http://freesource.info ---------------------------------------------------------------------------- =F3=D4=C1=D2=D9=CA =C7=CC=C0=CB =CC=D5=DE=DB=C5 =CE=CF=D7=D9=C8 =C4=D7=D5= =C8. --xHFwDpU9dbj6ez1V Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) iD8DBQFHcg+wPuR8c4jhFKIRAiIVAJ4mO8BDwlfMqsdHThOFvgNaNg6wAwCfXFYT Bgur16knc2tCWNchM+gjIlI= =7X4N -----END PGP SIGNATURE----- --xHFwDpU9dbj6ez1V--