Hello,
How can I crypt the field of a table?
This field will contain secret data, I need therefore
to crypt this field to avoid those data to be stored
on the disk unprotected.
Where can I found documentation on this topic?
Thanks
Greg
__
Do You
Hello Greg,
I've created a stupid little C trigger that is kinda like MySQL's "encrypt"
function. I use it to store passwords in the UNIX crypt format.
Here's the encrypt.c:
/*
*
* Henrique Pantarotto ([EMAIL PROTECTED])
* Funcao para
Hi,
I wrote an application that uses PgSQL as database backend. It ran for
almost a year and now it's database directory grew to 85633Kbyte.
Inspecting this directory, I found out that a file called oid_index grew
to 84058112 bytes, i.e. 99% of the database is index. What went wrong?
What can be
Dear All,
There is a big one for the weekend to think on it... ;-)
I have two problems I can't solve since a week now.
The config is Debian linux 2.1.121, Postgres 6.4.2, Apache.
There is a very simple application running on it with small tables (a couple
of MB altogether), communicating via HT
I did vacuum a database that I previously loaded 'heavily' with data and
got the following results and got it everytime I repeat vacuum:
elmu=> vacuum;
NOTICE: BlowawayRelationBuffers(annex_log, 58): block 184 is referenced
(private 0, last 0, global 1)
pqReadData() -- backend closed the channel
Hi,
I have experience with Linux, but I've never installed a patch. Do I
just go 'patch postgresql-6.5.1-6.5.2.patch'? Do I need any parameters
or do I need to be in a special directory? Basically, how do I do it?
Thanks, Daniel Stolk
Sebestyen Zoltan wrote:
>
> Hi,
>
> I wrote an application that uses PgSQL as database backend. It ran for
> almost a year and now it's database directory grew to 85633Kbyte.
> Inspecting this directory, I found out that a file called oid_index grew
> to 84058112 bytes, i.e. 99% of the database
On Fri, Sep 17, 1999 at 09:03:58AM -0300, Henrique Pantarotto wrote:
> PS: Note that all crypted passwords are created with salt "HP" (my name
> initials..) You can change that, or if you know C, you can do in a way that it
> will pick two random characters (the way it should really be).
I've g
Daniel Stolk wrote:
>
> Hi,
>
> I have experience with Linux, but I've never installed a patch. Do I
> just go 'patch postgresql-6.5.1-6.5.2.patch'? Do I need any parameters
> or do I need to be in a special directory? Basically, how do I do it?
>
> Thanks, Daniel Stolk
As soon as there exi
