[GENERAL] specifics about BIT(n) types

please CC me as I'm on silent or digest. -- I know these questions have been asked, and once by me. I can't find it in the archives or in the documentation. 1/ Are the bits in BIT(n) types stored as 1 bit per '0/1' or as one BYTE per '0/1' ? 2/ Wha

Re: [GENERAL] REINDEX slow?

Edmund Dengler <[EMAIL PROTECTED]> writes: > Alternatively, if I created a second index, and then dropped the first, > would this be faster (though I would suppose that an ANALYZE would need to > be done to recognize the utility of the new index, thereby negating any > speed improvements)? Curre

Re: [GENERAL] Data Encryption in PostgreSQL, and a Tutorial.

[EMAIL PROTECTED] ("scott.marlowe") wrote: > On Mon, 12 Apr 2004, Tom Lane wrote: > >> "scott.marlowe" <[EMAIL PROTECTED]> writes: >> > On Fri, 9 Apr 2004, Christopher Browne wrote: >> >> See the "pgcrypto" contrib module in the source tree. >> >> >> >> It is not typically compiled into what gets

Re: [GENERAL] Data Encryption in PostgreSQL, and a Tutorial.

> True, but the original discussion, I believe, was on storing user > passwords etc... for which md5 is the preferred method... I thought the original question was what to use for storing credit cards, for which you want a decryptable method. (A public/private key method would be even better for

Re: [GENERAL] Problems setting shared_buffers to large value

"Barry L. Geipel" <[EMAIL PROTECTED]> writes: > When I set shared_buffers to a value which puts the total shared memory > usage over 1GB, my postgres server fails to start. You definitely can't set shared memory to more than 2GB because its allocation arithmetic is done with ints. Not sure why it

Re: [GENERAL] Problems setting shared_buffers to large value

Hello, What operating system? Sincerely, Joshua D. Drake Barry L. Geipel wrote: --> Hi all,   I am running postgres 7.4.2 on a Dual processor Opteron with 16GB of ram. I want to set shared_buffers to a large value, but I am running into startup problems.   I have set my

Re: [GENERAL] Data Encryption in PostgreSQL, and a Tutorial.

On Mon, 12 Apr 2004, Tom Lane wrote: > "scott.marlowe" <[EMAIL PROTECTED]> writes: > > On Fri, 9 Apr 2004, Christopher Browne wrote: > >> See the "pgcrypto" contrib module in the source tree. > >> > >> It is not typically compiled into what gets distributed with the > >> typical Linux/BSD distrib

[GENERAL] Problems setting shared_buffers to large value

Hi all,   I am running postgres 7.4.2 on a Dual processor Opteron with 16GB of ram. I want to set shared_buffers to a large value, but I am running into startup problems.   I have set my kernel SHMMAX and SHMALL to 12GB.   When I set shared_buffers to a value which puts the total shar

Re: [GENERAL] PostgreSQL Invalid Page Header in Block XXXXX

[EMAIL PROTECTED] (Anthony) writes: > Our Database is having errors. We are currently using PostgreSQL to > store 2.5 Million records per day. The average addition to our primary > table is 4.5 Gigs of data. > > We are doing this on a dual Opteron 244 system with 1 TeraByte of HDD > space. The driv

Re: [GENERAL] Data Encryption in PostgreSQL, and a Tutorial.

"scott.marlowe" <[EMAIL PROTECTED]> writes: > On Fri, 9 Apr 2004, Christopher Browne wrote: >> See the "pgcrypto" contrib module in the source tree. >> >> It is not typically compiled into what gets distributed with the >> typical Linux/BSD distribution because of the library dependencies >> that

Re: [GENERAL] db schema diff

Igor Shevchenko <[EMAIL PROTECTED]> writes: > On Monday 12 April 2004 22:38, you wrote: >> ${PG_DUMP} -s -p 5432 mydb|${GREP} -v '^--'|${CAT} -s >5432.sql >> ${PG_DUMP} -s -p 5433 mydb|${GREP} -v '^--'|${CAT} -s >5433.sql >> ${PG_DUMP} -s -p 5434 mydb|${GREP} -v '^--'|${CAT} -s >5434.sql >> >> ${D

Re: [GENERAL] db schema diff

On Monday 12 April 2004 22:38, you wrote: > ${PG_DUMP} -s -p 5432 mydb|${GREP} -v '^--'|${CAT} -s >5432.sql > ${PG_DUMP} -s -p 5433 mydb|${GREP} -v '^--'|${CAT} -s >5433.sql > ${PG_DUMP} -s -p 5434 mydb|${GREP} -v '^--'|${CAT} -s >5434.sql > > ${DIFF} 5432.sql 5433.sql > 5432-5433.diff > ${DIFF} 54

Re: [GENERAL] db schema diff

> Suppose I have "pg_dump -s" of two pg installs, one is "dev", another > is "production". Their schemas don't differ too much, and I want to > get a "diff -u"-like schema diff so I can quickly add missing/remove > old > tables/sequences/etc to one or another (manually). Is there some quick > too

Re: [GENERAL] COPY TO order

--- Guy Fraser <[EMAIL PROTECTED]> > If you have a 'serial' or 'bigserial' field like this : > > create table test_table ( > test_id bigserial, > data integer, > comment text > ); > > and you use : > > copy test_table (data,comment) > from '/wherever/the/file/is' > using delimiters ','; > >

[GENERAL] db schema diff

Hi! Suppose I have "pg_dump -s" of two pg installs, one is "dev", another is "production". Their schemas don't differ too much, and I want to get a "diff -u"-like schema diff so I can quickly add missing/remove old tables/sequences/etc to one or another (manually). Is there some quick tool for

Re: [GENERAL] COPY TO order

Christopher Browne wrote: Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Clodoaldo Pinto Neto) would write: How to make sure COPY TO writes the table lines to the file in the same order they were inserted? You probably want to rewrite PostgreSQL then. I'm producing html pag