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 vi...@khera.org wrote:
On Wed, Mar 28, 2012 at 6:31 PM, Naoko Reeves naokoree...@gmail.com
wrote:
Do you think this should be the next step I might take
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
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
Thank you so much again for all your help.
- Naoko
On Fri, Feb 24, 2012 at 1:25 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Fri, Feb 24, 2012 at 4:01 AM, Naoko Reeves naokoree...@gmail.com
wrote:
-- I have narrowed down the row
SELECT * FROM table ORDER BY table_id OFFSET 526199 LIMIT
Got it. Thank you very much!
On Fri, Nov 4, 2011 at 2:06 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Naoko Reeves wrote:
I dumped from:
[...] PostgreSQL 9.0.4 [...]
to:
[...] PostgreSQL 9.1.1 [...]
During the restoration I got the following errors:
ERROR: could not access
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,
please?
Thank you very much for your time in advance.
Naoko Reeves
, 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
Thank you very much for your time.
Naoko Reeves
On Thu, Aug 11, 2011
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
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 that
- http://www.simplistix.co.uk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sincerely,
Naoko Reeves
--
Sent via pgsql-general mailing list (pgsql-general
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
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
')
but none of above seems to be resolving the issue...
-Original Message-
From: Richard Huxton [mailto:d...@archonet.com]
Sent: Tuesday, November 17, 2009 1:14 PM
To: Naoko Reeves
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] does encrypt function support higher than basic ascii
[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 support higher than basic ascii?
I have tried:
select decrypt(encrypt((select convert
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@postgresql.org
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
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
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
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
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
Hi,
Could you tell me how to Export ALL plpgsql functions/triggers to file?
Thank you
Hello,
Is there a way to identify cascading of trigger execution level?
Please let me know if my question doesn't make any sense.
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
Is there a way to identify whether the given execution is in nested
trigger or not?
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:
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
@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 emp as condition
28 matches
Mail list logo
