Re: [GENERAL] could not read block... how could I identify/fix

Vick, Thank you very much. Yes, I just go ahead did what you said and all appears to be fine. On Thu, Mar 29, 2012 at 7:08 AM, Vick Khera wrote: > On Wed, Mar 28, 2012 at 6:31 PM, Naoko Reeves > wrote: > > Do you think this should be the next step I might take? > > Could you

[GENERAL] could not read block... how could I identify/fix

There was a hardware crash. Since then INSERT to one table is failing with the following message: ERROR: could not read block 11857 of relation base/16396/3720450: read only 0 of 8192 bytes ERROR: could not read block 11805 of relation base/16396/3720450: read only 0 of 8192 bytes Similar error

Re: [GENERAL] invalid memory alloc request size 1765277700 Error Question

id memory alloc request size 1765277700 Some rows returned ERROR: compressed data is corrupt Thank you so much again for all your help. - Naoko On Fri, Feb 24, 2012 at 1:25 PM, Scott Marlowe wrote: > On Fri, Feb 24, 2012 at 4:01 AM, Naoko Reeves > wrote: > > -- I have narrowed do

[GENERAL] invalid memory alloc request size 1765277700 Error Question

Version: "PostgreSQL 8.4.6 on i386-apple-darwin, compiled by GCC i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370), 32-bit" There was an hardware crash. after that pg_dump failed with an error: ERROR: invalid memory alloc request size 1765277700 I searched archive and it i

Re: [GENERAL] ERROR from pg_restore - From OS X to Ubuntu

Got it. Thank you very much! On Fri, Nov 4, 2011 at 2:06 AM, Albe Laurenz wrote: > Naoko Reeves wrote: > > I dumped from: > > [...] PostgreSQL 9.0.4 [...] > > > to: > > [...] PostgreSQL 9.1.1 [...] > > > During the restoration I got the following errors

[GENERAL] ERROR from pg_restore - From OS X to Ubuntu

I dumped from: OS: OS X 10.5.8 pg version: PostgreSQL 9.0.4 on x86_64-apple-darwin, compiled by GCC i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5664), 64-bit Installation Method: EDB installer to: OS: Ubuntu 10.04.3 64bit pg version: PostgreSQL 9.1.1 on x86_64-pc-linux-gnu, compile

Re: [GENERAL] Regex Query Index question

t;[999" take about 28 ms with index. Yes, standard_conforming_strings is ON. Also forgot to mentioned the version: select version() >> "PostgreSQL 8.4.6 on i386-apple-darwin, compiled by GCC i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370), 32-bit"

[GENERAL] Regex Query Index question

27; || '7890') No success... Also { and period doesn't seems to use index either but } ) [ ] $ # works. Could you guide me to right direction for me please? Thank you very much for your time in advance. Naoko Reeves

[GENERAL] Unable to kill local COPY

version: 8.3 The other day, my DB stop processing request. It still accepts connections but not processing those. So I quit all client connections from client yet those process still alive on SQL Server. I tried to Stop DB by issuing pt_ctl STOP -m fast but failed to shut down database. Next I issu

[GENERAL] System Log is logging row number -1 is out of range 0..-1

version: "PostgreSQL 8.3.8 on i386-apple-darwin8.11.1, compiled by GCC i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370)" We are using custom plugin to connect to postgresql. We reviewed OS (OS X 10.6.2 2.26 GHz Quad-Core Intel Xeon Meomory 6 GB) system log and noticed tha

Re: [GENERAL] how do I disable automatic start on mac os x?

gt; cheers, > > Chris > > -- > Simplistix - Content Management, Batch Processing & Python Consulting >            - http://www.simplistix.co.uk > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.

Re: [GENERAL] column does not exist error

SELECT title FROM node WHERE type='client'; Would this work? -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dave Coventry Sent: Wednesday, November 18, 2009 6:24 AM To: pgsql-general General Subject: [GENERAL] column doe

Re: [GENERAL] Where do you store key for encryption

Got it. Thank you very much for your advice. -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Tuesday, November 17, 2009 8:54 PM To: Naoko Reeves Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Where do you store key for encryption On Tue, Nov 17, 2009

[GENERAL] Where do you store key for encryption

Hi, We have web application and encrypt PII columns. We use encrypt/decrypt function for this. Currently we hard coded the key in postgresql function which I am not sure of it. I did google it and people suggest that it needed to be stored in physically isolated location (storing decryption key

Re: [GENERAL] does encrypt function support higher than basic ascii?

I see that's how you cast...Yes that worked PERFECTLY. I am always learning something new from the list. Thank you VERY much! -Original Message- From: Richard Huxton [mailto:d...@archonet.com] Sent: Tuesday, November 17, 2009 2:07 PM To: Naoko Reeves Cc: pgsql-general@postgresq

Re: [GENERAL] does encrypt function support higher than basic ascii?

ODE') -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Naoko Reeves Sent: Tuesday, November 17, 2009 1:38 PM To: Richard Huxton Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] does encrypt function suppor

Re: [GENERAL] does encrypt function support higher than basic ascii?

x27;aes'),'foo','aes') select decrypt(encrypt((select convert('aéiou','LATIN1', 'LATIN1')),'foo','aes'),'foo','aes') but none of above seems to be resolving the issue... -Original Message- From:

[GENERAL] does encrypt function support higher than basic ascii?

Hello, I have the following statement and accent e doesn't seems to be decrypted correctly. select decrypt(encrypt('aéiou','foo','aes'),'foo','aes') Could you tell me if there is an option for encoding or this function only encrypt basic ascii? Thank you very much for your time in advance.

Re: [GENERAL] Fast Search on Encrypted Feild

As Alban pointed out encrypting the search value and compare stored encrypted value is very fast though it can't do LIKE search. After I received valuable input from Merlin, Bill and John, I did some research regarding "search against encrypted field" in general and as in everyone's advice, I must

Re: [GENERAL] Fast Search on Encrypted Feild

Merlin, Thank you for your quick response. I see... our security requirements are: We are encrypting PII information within our DB and because of the sensitive nature of our data, we must balancing both performance and security to meet our client requirements. Our clients are mainly lawyers and h

[GENERAL] Fast Search on Encrypted Feild

built index like: CREATE INDEX idx_phn_phone_dec ON phn (decrypt(phn_phone_enc, 'xxx', 'xxx')) This returns 12 rows in 68 ms. Would this be the solution for the fast encrypted field search or does this raise the security issue? Kindest regards, Naoko Reeves

[GENERAL] how to Export ALL plpgsql functions/triggers to file

Hi, Could you tell me how to Export ALL plpgsql functions/triggers to file? Thank you

[GENERAL] Cascading of trigger execution level

Hello, Is there a way to identify cascading of trigger execution level? Please let me know if my question doesn't make any sense.

[GENERAL] Is there a way to know if trigger is invoked by the code from another trigger

Could you tell me if there is a way to know if trigger is invoked by the code from another trigger? For instance, table A Trigger deletes table B record. While in table B trigger, I want to know whether this was triggered from table A. Thank you, Naoko

[GENERAL] How to identify nested level of trigger

Is there a way to identify whether the given execution is in nested trigger or not?

Re: [GENERAL] Query and the number of row result

Which client do you use to access to db? GUI (pgAdmin?)? Command-line? Either way, it should give you row number... -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of bilal ghayyad Sent: Monday, August 31, 2009 4:11 AM To:

Re: [GENERAL] Aggregate function with Join stop working under certain condition

@postgresql.org Subject: Re: [GENERAL] Aggregate function with Join stop working under certain condition On Wed, Aug 26, 2009 at 11:17:10AM -0400, Naoko Reeves wrote: > I am joining 4 tables (doc, bpt, con, emp) - emp and doc relationship is > one to many. I want to only one doc record per

[GENERAL] Aggregate function with Join stop working under certain condition

I am joining 4 tables (doc, bpt, con, emp) - emp and doc relationship is one to many. I want to only one doc record per emp as condition shown below: The query below successfully returns desired result (returns 4 records): Select bpt_key, emp_full_name, con_full_name, max(doc_date_created) as