Thank you for your reply. I agree that this configuration could be better and
this is why I sent my post.
There is still one concern remaining. As I said I have working configuration
with libpq and jdbc. For jdbc I created keystore, that is properly used with
connection ssl=on parameter and cli
On Mon, 22 Aug 2011 14:20:00 -0400 (EDT), Gary Chambers wrote:
so when this remote server reboots, where does the encryption key
come
from?
Why, from a file that resides in /root on the server, of course! :-)
That's secure, right?
-- Gary Chambers
Isn't necessary to be on the same server.
Hi,
Thank you for the reply.
> > I am trying to debug a query that gives an error. The error in the
> > application server log is
> > " ERROR: operator does not exist: timestamp without time zone =
character
> > varying
>
> > It looks like the error is for the condition ( CUSINDINF.MEMDOB ) =
Merlin Moncure writes:
> On Mon, Aug 22, 2011 at 8:49 PM, Bob Pawley wrote:
>> I'm not sure what you mean.
>> _base -- not base -- is the column name.
> oops. anyways, the important point is on the right side of the equals sign.
> Update library.compare set _base[2] = 2 where process_id = 2;
Ri
> -Original Message- From: Merlin Moncure
> Sent: Monday, August 22, 2011 11:03 AM
> To: Bob Pawley
> Cc: Postgresql
> Subject: Re: [GENERAL] Updating Arrays
>
> On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley wrote:
>> Hi
>>
>> I exploring the use of arrays.
>>
>> So far I have created a
> -Original Message- From: Merlin Moncure
> Sent: Monday, August 22, 2011 11:03 AM
> To: Bob Pawley
> Cc: Postgresql
> Subject: Re: [GENERAL] Updating Arrays
>
> On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley wrote:
>>
>> Hi
>>
>> I exploring the use of arrays.
>>
>> So far I have created a
I'm not sure what you mean.
_base -- not base -- is the column name.
Bob
-Original Message-
From: Merlin Moncure
Sent: Monday, August 22, 2011 11:03 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Updating Arrays
On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley wrote:
Hi
I exp
Hi all,
I'm trying from a C function to return a SETOF anyelement,
but get_call_result_type(fcinfo, NULL, &tupdesc)
don't return TYPEFUNC_COMPOSITE as expected.
Something i've missed ?
(I know i can do it with a SETOF RECORD instead,
but it leads to explicitely define the output type of each c
On 08/22/2011 05:07 PM, Martín Marqués wrote:
My question regarding your answer is, why is it important for the
first page after a checkpoint and not on other page writes?
The first time a page is written after a checkpoint, when
full_page_writes is on, the entire 8K page is written out to
2011/2/17 Greg Smith :
> AI Rumman wrote:
>>
>> I can't clearly understand what FULL_PAGE_WRITE parameter is stand for.
>> Documentation suggest that If I make it OFF, then I have the chance for DB
>> crash.
>> Can anyone please tell me how it could be happened?
>
> The database writes to disk in 8
so when this remote server reboots, where does the encryption key come
from?
Why, from a file that resides in /root on the server, of course! :-)
That's secure, right?
-- Gary Chambers
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Mon, 22 Aug 2011 10:54:23 -0700, John R Pierce wrote:
On 08/22/11 10:34 AM, Condor wrote:
I did not worry about hackers attack, I worrying how to secure data
if I physical loss hard drives or server.
so when this remote server reboots, where does the encryption key
come from?
--
john
On Mon, Aug 22, 2011 at 10:34 AM, Condor wrote:
> I did not worry about hackers attack, I worrying how to secure data
> if I physical loss hard drives or server. Let's just imagine that you have
> a server and you store on it important data like credit cards, bank acc,
> password, clients names,
On Mon, Aug 22, 2011 at 1:40 AM, Condor wrote:
> Hello ppl,
> any one can tell me how I can secure linux server with database postgres for
> example ?
Here are a few steps:
1) Identify your environment. Focus on details. For example, this
might be in a monitored server room where access is req
On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley wrote:
> Hi
>
> I exploring the use of arrays.
>
> So far I have created a table and inserted a row and updated the row with an
> array
> Update library.compare
> set _base =
> '{2, 0.764149497122068, 4.8886}'
> where process_id = 2;
> – successfu
Hi
I exploring the use of arrays.
So far I have created a table and inserted a row and updated the row with an
array
Update library.compare
set _base =
'{2, 0.764149497122068, 4.8886}'
where process_id = 2;
– successfully.
However when I attempt to update a specific element of the array
On 08/22/11 10:34 AM, Condor wrote:
I did not worry about hackers attack, I worrying how to secure data
if I physical loss hard drives or server.
so when this remote server reboots, where does the encryption key come from?
--
john r pierceN 37, W 122
santa cruz
On Mon, 22 Aug 2011 09:32:39 -0500, Merlin Moncure wrote:
On Mon, Aug 22, 2011 at 3:40 AM, Condor wrote:
Hello ppl,
any one can tell me how I can secure linux server with database
postgres for
example ?
Im thinking to make a cryptfs file system and to deploy database
over the
cryptfs. The p
On Mon, Aug 22, 2011 at 3:40 AM, Condor wrote:
> Hello ppl,
> any one can tell me how I can secure linux server with database postgres
> for example ?
> Im thinking to make a cryptfs file system and to deploy database over the
> cryptfs. The problem
> here may will be when front end need any data
On Monday, August 22, 2011 7:47:47 am salah jubeh wrote:
> Hello,
>
> I have a lookup table I want to delete which is referenced as a foreign
> key in another table. Is there is a way to find all of the tables
> depends on this column (foreign key) but not the whole table or view.
>
>
> Thank
Hello,
I have a lookup table I want to delete which is referenced as a foreign key in
another table. Is there is a way to find all of the tables depends on this
column (foreign key) but not the whole table or view.
Thanks in advance
On Monday, August 22, 2011 7:24:30 am c k wrote:
> No i didn't removed any thing. Only I have installed python 2.6. And then
> tried to create plpythonu. It got created, but when tries to execute
> already mentioned function server crashes.
>
> I didn't have any clue.
My guess is this is the clu
On Mon, Aug 22, 2011 at 3:40 AM, Condor wrote:
> Hello ppl,
> any one can tell me how I can secure linux server with database postgres for
> example ?
> Im thinking to make a cryptfs file system and to deploy database over the
> cryptfs. The problem
> here may will be when front end need any data
No i didn't removed any thing. Only I have installed python 2.6. And then
tried to create plpythonu. It got created, but when tries to execute already
mentioned function server crashes.
I didn't have any clue.
Thanks and regards.
Chaitany Kulkarni
On Sun, Aug 14, 2011 at 12:37 AM, Adrian Klave
On Monday, August 22, 2011 5:11:08 am alexondi wrote:
> Hi!
> Sometimes I got this error
>
> FATAL: could not open relation mapping file "global/pg_filenode.map": No
> such file or directory
>
> and after restart computer all is fine. What mean this?
>
Meant to add to my previous post:
When y
On Monday, August 22, 2011 5:11:08 am alexondi wrote:
> Hi!
> Sometimes I got this error
>
> FATAL: could not open relation mapping file "global/pg_filenode.map": No
> such file or directory
>
> and after restart computer all is fine. What mean this?
>
Some more information would be helpful:
P
On Monday, August 22, 2011 5:17:47 am alexondi wrote:
> Hi!
> I use postgresql version 9.1beta3 and use pg_controldata and when I see
> first row
>
> pg_controldata version number: 903
I believe you are actually seeing:
pg_control version number:903
This refers to the pg_control file
Asia writes:
> Now the issue is then when using libpq it was enough to have only root
> certificate in server's root.crt and it worked fine.
> But when I tried using the same with JDBC it turned out that I need to put
> whole chain (2 certs) of Intermediate CA 1 in server's root.crt.
This is po
Hi!
I use postgresql version 9.1beta3 and use pg_controldata and when I see
first row
pg_controldata version number: 903
Is this right version?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pg-controldata-return-wrong-version-tp4723194p4723194.html
Sent from the Po
Hi!
Sometimes I got this error
FATAL: could not open relation mapping file "global/pg_filenode.map": No
such file or directory
and after restart computer all is fine. What mean this?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-with-pg-filenode-map-file-tp4723
Recently I have been working on implementation of mutual SSL authentication
between our application and PostgreSQL database.
I managed to make it work wih "ssl=true" connection option and "clientcert=1"
flags in pg_hba.conf. Moreover I managed to make it work with C++ application
using libpq and
Hello ppl,
any one can tell me how I can secure linux server with database
postgres for example ?
Im thinking to make a cryptfs file system and to deploy database over
the cryptfs. The problem
here may will be when front end need any data for in/out cpus of the
server will aways
decrypt/encry
32 matches
Mail list logo
