Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 31E9637BD40 for ; Tue, 30 Sep 2008 10:51:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30198-08 for ; Tue, 30 Sep 2008 10:51:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from server4.pinguin-hosting.de (server4.pinguin-hosting.de [88.198.11.108]) by postgresql.org (Postfix) with ESMTP id 5DE9237BAB7 for ; Tue, 30 Sep 2008 10:51:08 -0300 (ADT) Received: from tp570.private.tamay-dogan.net (unknown [194.250.145.134]) (Authenticated sender: linux4michelle@tamay-dogan.net) by server4.pinguin-hosting.de (Postfix) with ESMTPA id 0A26E5E5D2B for ; Tue, 30 Sep 2008 15:51:17 +0200 (CEST) Received: by tp570.private.tamay-dogan.net (sSMTP sendmail emulation); Tue, 30 Sep 2008 15:50:43 +0200 Received: by tp570.private.tamay-dogan.net (TDSSMTP outspool); Sat, 27 Sep 2008 17:24:15 +0200 Date: Sat, 27 Sep 2008 17:24:15 +0200 From: Michelle Konzack To: pgsql-admin@postgresql.org Subject: Re: Hex representation Message-ID: <20080927152415.GP17284@tamay-dogan.net> References: <337D9AE2-2BEF-48E3-8DF4-E7F0CA560A1B@indiana.edu> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="pvq4FPIYehQuVelz" Content-Disposition: inline In-Reply-To: <337D9AE2-2BEF-48E3-8DF4-E7F0CA560A1B@indiana.edu> X-Message-Flag: Improper configuration of Outlook is a breeding ground for viruses. Please take care your Client is configured correctly. Greetings Michelle. X-Disclaimer-DE: Eine weitere Verwendung oder die Veroeffentlichung dieser Mail oder dieser Mailadresse ist nur mit der Einwilligung des Autors gestattet. Organization: Tamay Dogan Network X-Operating-System: Linux tp570 2.4.27-2-686 X-Uptime: 17:19:18 up 22:15, 9 users, load average: 0.17, 0.11, 0.11 X-Homepage: http://www.debian.tamay-dogan.net/ User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/350 X-Sequence-Number: 30443 --pvq4FPIYehQuVelz Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Am 2008-09-24 15:20:03, schrieb Carol Walter: > Hello, >=20 > Does anyone know what the format of hex characters for postgres are? =20 > I'm trying to create files that contain a 0x55. It looks to me like =20 > it should require a delimiter of some sort between the characters. I =20 > don't know how postgres would know that the string was a hex =20 > representation and not just a character zero, followed by a character =20 > x, followed by a character 5, followed by a character 5. This is working: #!/bin/sh for MAJ in 0 1 2 3 ; do for MIN in 0 1 2 3 4 5 6 7 8 9 A B C D E F ; do for HEX in $(seq 1 262144) ; do echo -n \x55 >>00${MAY}${MIN} done done done which should create your missing pg_clog files Thanks, Greetings and nice Day/Evening Michelle Konzack Systemadministrator 24V Electronic Engineer Tamay Dogan Network Debian GNU/Linux Consultant --=20 Linux-User #280138 with the Linux Counter, http://counter.li.org/ ##################### Debian GNU/Linux Consultant ##################### Michelle Konzack Apt. 917 ICQ #328449886 +49/177/9351947 50, rue de Soultz MSN LinuxMichi +33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com) --pvq4FPIYehQuVelz Content-Type: application/pgp-signature; name="signature.pgp" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFI3lAfC0FPBMSS+BIRAjORAKCsLzU/3E0o4Cner9k2NEUqnjR89QCgm5+s t6iMvA6d7LBAvUMAJGcFhhU= =WxRA -----END PGP SIGNATURE----- --pvq4FPIYehQuVelz--