On 05/23/10 18:03, Andy Colson wrote:
> On 05/22/2010 09:40 PM, Ivan Voras wrote:
>> Hello,
>>
>> I have a schema which tracks various pieces of information which would
>> need to be globally searchable. One approach I came up with to make all
>> of the data searchable is to create a view made of U
On 05/23/10 07:17, Craig Ringer wrote:
> On 23/05/10 10:40, Ivan Voras wrote:
>> Hello,
>>
>> I have a schema which tracks various pieces of information which would
>> need to be globally searchable.
>
> If systems that exist outside the database its self are acceptable,
> check out Apache Lucerne
Is this the latest on this subject?
Re: Apache2 PostgreSQL http authentication
• From: "Jeffrey Brower"
• To:
• Subject: Re: Apache2 PostgreSQL http authentication
• Date: Sun, 7 Oct 2007 20:29:27 -0400
First you need to make sure that the blastwave package fo
On Mon, May 24, 2010 at 1:44 AM, Ravi Katkar wrote:
> Please let me know what’s wrong with below code
> create or replace FUNCTION test_call()
>
> RETURNS VOID
>
> AS $procedure$
>
> DECLARE
>
> c_cursor REFCURSOR;
give your cursor a name:
c_cursor REFCURSOR default 'a_name';
this nam
Hi,
When I try to install postgres 8.4 on windows server 2003, I get the
following error: "A non-fatal error occurred whilst loading database
modules. Please check the installation logs in C:/docs&setttings/user/local
settings/temp for details". The log file doesn't have any error, but it
looks l
oops, sorry, my question was very ambiguous ...
What I want to know is:
The correct procedure to remove the wal files that have been used in
the recovery of a postgres server.
Consider the following;
1.- A main server in production.
2.- A secondary server that is normally off.
3.- By conn
Craig ~
Your rollback solution works! For anyone who wants to use Craig's solution,
the new version of my example (with the test code omitted to clarify the
structural pattern) is:
CREATE OR REPLACE FUNCTION tests() RETURNS varchar AS
$BODY$
DECLARE
errs VARCHAR = '';
-- Test dec
On 5/24/10 7:52 PM, ritas wrote:
Hi,
When I try to install postgres 8.4 on windows server 2003, I get the
following error: "A non-fatal error occurred whilst loading database
modules. Please check the installation logs in C:/docs&setttings/user/local
settings/temp for details". The log file does
Thanks Sachin for your response. I have attached the install-postgresql.log.
Also, if it helps, I have the following error in my event viewer: pg_ctl:
could not register service "postgresql-8.4": error code 0
The postgres service is not listed under services.
Thanks.
http://old.nabble.com/file/p
Hi guys,
does ANYONE have any tips on hiding data on a database server? This means
that data is stored in places that is not necessarily picked up in the
schema of the database. I am doing some research on databases and need some
direction.
Any help or direction will be highly appreciated.
Kind
On Mon, May 24, 2010 at 2:16 PM, Hector Beyers wrote:
>
> Hi guys,
> does ANYONE have any tips on hiding data on a database server? This means
> that data is stored in places that is not necessarily picked up in the
> schema of the database. I am doing some research on databases and need some
> di
On 24 May 2010 20:16, Hector Beyers wrote:
>
> Hi guys,
> does ANYONE have any tips on hiding data on a database server? This means
> that data is stored in places that is not necessarily picked up in the
> schema of the database. I am doing some research on databases and need some
> direction.
>
On Mon, May 24, 2010 at 1:16 PM, Hector Beyers wrote:
>
> Hi guys,
> does ANYONE have any tips on hiding data on a database server? This means
> that data is stored in places that is not necessarily picked up in the
> schema of the database. I am doing some research on databases and need some
> di
In response to Scott Marlowe :
> On Mon, May 24, 2010 at 1:16 PM, Hector Beyers wrote:
> >
> > Hi guys,
> > does ANYONE have any tips on hiding data on a database server? This means
> > that data is stored in places that is not necessarily picked up in the
> > schema of the database. I am doing s
Wow, this is really an idea I can work with.
I know this is getting really brainstorming, but do you think it is possible
to apply steganography (hiding data in pictures) tactics to the columns of a
database?
Regards
Hector
On Mon, May 24, 2010 at 9:30 PM, Peter Hunsberger <
peter.hunsber...@
Yes, I mean hide. I am approaching the problem out of the perspective of a
malicious user / hacker.
On Mon, May 24, 2010 at 10:08 PM, Bill Moran wrote:
> In response to Scott Marlowe :
>
> > On Mon, May 24, 2010 at 1:16 PM, Hector Beyers
> wrote:
> > >
> > > Hi guys,
> > > does ANYONE have any
On Mon, May 24, 2010 at 3:10 PM, Hector Beyers wrote:
> Wow, this is really an idea I can work with.
> I know this is getting really brainstorming, but do you think it is possible
> to apply steganography (hiding data in pictures) tactics to the columns of a
> database?
If by that, you mean a var
Dear Peter,
can you elaborate on what you mean by storing 'this' in the index. Are you
referring to the function that is applied over the data?
How would you be able to see the result with a dump?
Thanks, your ideas are really helping...
Regards
Hector
On Mon, May 24, 2010 at 9:30 PM, Peter Hu
On Mon, May 24, 2010 at 3:24 PM, Hector Beyers wrote:
> Dear Peter,
> can you elaborate on what you mean by storing 'this' in the index. Are you
> referring to the function that is applied over the data?
> How would you be able to see the result with a dump?
Yes, you would the function to create
Acutally, that's probably the best way to this. The key to effective
steganography is having a large amount of data to store a small amount
of data. So, if you don't mind having a db that's 10 to 100 times
bigger than it has to be to store the original data it should work.
On Mon, May 24, 2010 a
On Mon, May 24, 2010 at 3:16 PM, Hector Beyers wrote:
>
> Hi guys,
> does ANYONE have any tips on hiding data on a database server? This means
> that data is stored in places that is not necessarily picked up in the
> schema of the database. I am doing some research on databases and need some
> di
is there anyway with a running instance of postgres to find out if it was
compiled with:
BIGINT
vs
DOUBLE PRECISION
timestamps?
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com
2010/5/25 Dennis Gearon :
> is there anyway with a running instance of postgres to find out if it was
> compiled with:
>
> BIGINT
> vs
> DOUBLE PRECISION
>
> timestamps?
>
SHOW INTEGER_DATETIMES;
Osvaldo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Hello.
When you execute pg_stop_backup,postgresql makes a special file, like this
00010015.0064.backup.
This means you can delete wal 00010014 and before.
The PostgreSQL manual also says following.
http://www.postgresql.org/docs/8.4/interactive/continuous-ar
for those walking up to a new server and who want to know the same information:
shell script invoked by:
script_filename database user
#!/bin/sh
psql -c "show INTEGER_DATETIMES;" -d $1 -U $2 -W
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die
25 matches
Mail list logo
