Re: Hex representation

From: Michelle Konzack <linux4michelle(at)tamay-dogan(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Hex representation
Date: 2008-09-27 15:24:15
Message-ID: 20080927152415.GP17284@tamay-dogan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Am 2008-09-24 15:20:03, schrieb Carol Walter:
> Hello,
>
> Does anyone know what the format of hex characters for postgres are?
> I'm trying to create files that contain a 0x55. It looks to me like
> it should require a delimiter of some sort between the characters. I
> don't know how postgres would know that the string was a hex
> representation and not just a character zero, followed by a character
> 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

--
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)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Kovacs 2008-09-28 08:18:34 Re: Error while trying to back up database: out of memroy
Previous Message Mikel Lindsaar 2008-09-27 07:22:18 Re: unable to restore 8.2.5