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
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
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:
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
Asia asia123...@op.pl 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
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 and
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:
Postgres
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 you get
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
On Mon, Aug 22, 2011 at 3:40 AM, Condor con...@stz-bg.com 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
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 clue:
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: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.
Thanks in
On Mon, Aug 22, 2011 at 3:40 AM, Condor con...@stz-bg.com 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
On Mon, 22 Aug 2011 09:32:39 -0500, Merlin Moncure wrote:
On Mon, Aug 22, 2011 at 3:40 AM, Condor con...@stz-bg.com 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
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
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
On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley rjpaw...@shaw.ca 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;
–
On Mon, Aug 22, 2011 at 1:40 AM, Condor con...@stz-bg.com 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
On Mon, Aug 22, 2011 at 10:34 AM, Condor con...@stz-bg.com 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,
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
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:
2011/2/17 Greg Smith g...@2ndquadrant.com:
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
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
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
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 rjpaw...@shaw.ca
-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 rjpaw...@shaw.ca 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 rjpaw...@shaw.ca wrote:
Hi
I exploring the use of arrays.
So far I have created a
Merlin Moncure mmonc...@gmail.com writes:
On Mon, Aug 22, 2011 at 8:49 PM, Bob Pawley rjpaw...@shaw.ca 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] =
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 ) =
($4) ,
30 matches
Mail list logo