The following command was run and the content of content_file, signature_file
and id_rsa.pub (or pem) are inserted into a Postgres database.
openssl dgst -sign id_rsa content_file > signature_file
Is there any way to verify that the signature corresponds with the
content/public key within Pos
On Tue, 23 Feb 2016, at 17:20, Adrian Klaver wrote:
> Where did you install Postgres from and what version of OpenSSL was it
> compiled against?
I now realise that I wasn't compiling PostgreSQL against my
self-compiled openssl. After adding --with-includes and --with-libraries
to configure I have
not accept SSL connection: unknown message digest algorithm
I could use -sha1 to generate my certificates but -sha256 should work,
Some searching indicates this is usually an OpenSSL version issue.
So the OpenSSL version you mention above is where, the client or the
server or both?
Where did
Hi,
I am using PostgreSQL 9.4.6 and openssl 1.0.2f. If my server or client
certificate use SHA256, I get the following error on the client:
psql: SSL error: tlsv1 alert decrypt error
And the following log message on the server:
LOG: could not accept SSL connection: unknown message digest
On Tue, 2015-08-25 at 15:41 +, Neil Tiffin
wrote:
> I really like the standardization that PostgreSQL uses in auto
> generating default names. The rule I use is to always use the auto
> generated names unless the object is referenced routinely in code. In
> most cases developers don’t care
Hi.
I was looking into a need of doing SHA on contents of a "large object", and
it seems that the only digest (and other) functions provided by pgcrypto
produce output based on a single string on an input, without being able to
accumulate for multiple data blocks. It would be nice to
Me bad. It was right there in front me.
I'm now in Digest Mode.
- Bob
On Wed, Oct 9, 2013 at 12:00 PM, Igor Neyman wrote:
> > -Original Message-
> > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> > ow...@postgresql.org] On Behalf Of Ray
ERAL] I need more specific instructions for switching to
> digest mode for this list
>
> On 09/10/2013 16:47, Bob Futrelle wrote:
> > Trying to switch to the digest didn't work.
> > How do I find more specific details about switching?
> >
> >
> > On Wed, O
On 09/10/2013 16:47, Bob Futrelle wrote:
> Trying to switch to the digest didn't work.
> How do I find more specific details about switching?
>
>
> On Wed, Oct 9, 2013 at 12:27 AM, Bob Futrelle <mailto:bob.futre...@gmail.com>> wrote:
>
> set pgsql-gener
Trying to switch to the digest didn't work.
How do I find more specific details about switching?
On Wed, Oct 9, 2013 at 12:27 AM, Bob Futrelle wrote:
> set pgsql-general digest
>
Yes indeed, pg_query returns "t" or "f" as strings when selecting
boolean columns.
I was able to switch over to PDO with only an afternoon's work and it works
perfectly for boolean columns, returning values that are properly interpreted
as true and false by php, and by json_encode. I'm all set now
On 23/09/2010 02:00, Adrian Klaver wrote:
On Wednesday 22 September 2010 5:40:55 pm David Wilson wrote:
On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaverwrote:
From here;
http://www.postgresql.org/docs/8.4/interactive/datatype-boolean.html
I believe the question relates to changing the string
On Wednesday 22 September 2010 5:40:55 pm David Wilson wrote:
> On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaver wrote:
> > From here;
> >
> > http://www.postgresql.org/docs/8.4/interactive/datatype-boolean.html
>
> I believe the question relates to changing the string *output* of the
> database to s
On Wed, Sep 22, 2010 at 8:30 PM, Adrian Klaver wrote:
>
> From here;
>
> http://www.postgresql.org/docs/8.4/interactive/datatype-boolean.html
>
>
>
I believe the question relates to changing the string *output* of the
database to something other than 't' and 'f', not an issue with input
formats.
On Wednesday 22 September 2010 5:12:45 pm TJ O'Donnell wrote:
> Many frameworks do not natively recognize "t" as true and "f" as false.
> I'm using php, json_encode and extjs.
> Is it possible to cause the default output of boolean values to be
> something other than "t" and "f", say "true" and "fa
Many frameworks do not natively recognize "t" as true and "f" as false.
I'm using php, json_encode and extjs.
Is it possible to cause the default output of boolean values to be something
other than "t" and "f", say "true" and "false" or even 1 and 0?
Of course I can do this for an individual query
subscribe-set pgsql-general digest
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Jun 08, 2009 at 08:08:02PM +0100, Oliver Kohll - Mailing Lists wrote:
> On 8 Jun 2009, at 17:23, Merlin Moncure wrote:
>
Is there a way when creating a table to limit it to one row? That
is,
without using a stored procedure?
I searched the documentation, but did
On 8 Jun 2009, at 17:23, Merlin Moncure wrote:
Is there a way when creating a table to limit it to one row? That
is,
without using a stored procedure?
I searched the documentation, but didn't find anything.
CREATE TABLE x (...);
CREATE UNIQUE INDEX x_only_one_row ON ((1));
very cleve
Network
Debian GNU/Linux Consultant
- Forwarded message from [EMAIL PROTECTED] -
Date: Thu, 27 Mar 2008 05:56:10 -0300
Envelope-to: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Subject: [GENERAL] [pgsql-general] Daily digest v1.8030 (22 messages)
X-Mailing
well (see below). Seems like
<[EMAIL PROTECTED]> has a problem.
Rainer
Path: news.hub.org!postgresql.org!pgsql-general-owner+m130868
From: [EMAIL PROTECTED]
Newsgroups: pgsql.general
Subject: [pgsql-general] Daily digest v1.8030 (22 messages)
Date: Thu, 27 Mar 2008 05:56:10 -0300
Organization: Hub.Org N
x27;t seem to have to do with duplicates, since the eight
digests were different. On the other hand, I think you're probably
right about the these being related to bounces.
The following are the Received headers from before the list daemon sent
me the first digest.
Received: from ma
"Brett Hoerner" <[EMAIL PROTECTED]> writes:
> On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
>> I received eight of these unwanted digests last night and early this
>> morning, after never seeing them before. Is this a new configuration
>> change that I need to go per
On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
> I received eight of these unwanted digests last night and early this
> morning, after never seeing them before. Is this a new configuration
> change that I need to go personalize?
I was wondering the same thing, but
[EMAIL PROTECTED] wrote:
Message Digest
Volume 1 : Issue 8030 : "index" Format
Messages in this Issue:
200803/1324: Re: casting from integer to boolean
200803/1325: Re: casting from integer to boolean
200803/1326: Re: casting from integer to boolean
200803/1327: Re: Survey
Message Digest
Volume 1 : Issue 8037 : "index" Format
Messages in this Issue:
200803/1458: Delete after trigger fixing the key of row numbers
200803/1459: Re: SELECT DISTINCT ON and ORDER BY
200803/1460: Re: SELECT DISTINCT ON and ORDER BY
200803/1461: Re: SELECT DISTINCT ON an
Message Digest
Volume 1 : Issue 8035 : "index" Format
Messages in this Issue:
200803/1421: Re: Survey: renaming/removing script binaries
(createdb, createuser...)
200803/1422: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1423: Re: Using
Message Digest
Volume 1 : Issue 8036 : "index" Format
Messages in this Issue:
200803/1440: Re: Need help on how to backup a table
200803/1441: Persistent user-defined functions
200803/1442: Merge Joins and Views
200803/1443: Re: Persistent user-defined functions
200803/1444
Message Digest
Volume 1 : Issue 8034 : "index" Format
Messages in this Issue:
200803/1400: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1401: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1402: Re: Survey
Message Digest
Volume 1 : Issue 8031 : "index" Format
Messages in this Issue:
200803/1346: Re: RULES and QUALIFICATION for INSERT
200803/1347: Re: How to "use" database?
200803/1348: Re: RULES and QUALIFICATION for INSERT
200803/1349: Performance of update
200803/1
Message Digest
Volume 1 : Issue 8032 : "index" Format
Messages in this Issue:
200803/1364: very delayed autovacuum on certain tables
200803/1365: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1366: Re: Performance of update
20080
Message Digest
Volume 1 : Issue 8030 : "index" Format
Messages in this Issue:
200803/1324: Re: casting from integer to boolean
200803/1325: Re: casting from integer to boolean
200803/1326: Re: casting from integer to boolean
200803/1327: Re: Survey: renaming/removing scrip
Message Digest
Volume 1 : Issue 8033 : "index" Format
Messages in this Issue:
200803/1382: Re: Using tables in other PostGreSQL database
200803/1383: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1384: Re: Timezones in 8.2.7
20080
n make your own type that does
something similar without much effort.
> Am I correct in assuming that the space saved by storing digests as
> binary (1/2 size of hex) will substantially impact index ins/upd/del
> performance or when the digest itself is a large fraction of the rest
> of
t the space saved by storing digests as
binary (1/2 size of hex) will substantially impact index ins/upd/del
performance or when the digest itself is a large fraction of the rest of
the row size?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
t the space saved by storing digests as
binary (1/2 size of hex) will substantially impact index ins/upd/del
performance or when the digest itself is a large fraction of the rest of
the row size?
Thanks,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
Don Lavelle <[EMAIL PROTECTED]> writes:
> I just signed up for the mailing list, but when I tried to change
> over to a digest subscription, I got an error back from the server.
I'm fairly sure that the way you do that involves some kind of "set mode"
command, no
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I just signed up for the mailing list, but when I tried to change
> over to a digest subscription, I got an error back from the server.
> The instructions I followed were from http://archives.postgresql.org/
> pgsql-general/
Hi all,
I just signed up for the mailing list, but when I tried to change
over to a digest subscription, I got an error back from the server.
The instructions I followed were from http://archives.postgresql.org/
pgsql-general/ .
From the few e-mails I've gotten so far, it looks like
On Nov 6, 2006, at 21:00 , Marc Munro wrote:
For an alternative approach, you might want to check out Veil:
http://pgfoundry.org/projects/veil
Addendum: I took Veil to be undocumented since the source archive
only comes with Doxygen scripts; I thought the small "here" link on
the Veil home
On Nov 6, 2006, at 21:00 , Marc Munro wrote:
A fairly cursory look at your proposed model suggests that it will
work,
but is likely to have serious performance problems. The issue is
not so
much the simple queries on single views, but the complex queries your
developers will almost certainl
On Sat, 2006-04-11 at 06:13 -0400, [EMAIL PROTECTED]
wrote:
> Date: Fri, 3 Nov 2006 23:08:47 +0100
> From: Alexander Staubo <[EMAIL PROTECTED]>
> To: PgSQL General
> Subject: Per-row security
> Message-ID: <[EMAIL PROTECTED]>
>
> I am designing an application which requires fine-grained role-base
Sylvain,
All of the things you want to do can be done using Veil:
http://veil.projects.postgresql.org/
Be warned though, it is not simple. If you want privileges at the
column level, or based on a where clause, you will have to use
techniques like Veil's secured views.
It's better to avoid this
owing
message from one of our marketing partners.
===
Holiday specials for
Writer's Digest readers:
Final Draft Sale Price: $199
The number-one selling scriptwriting software for film, television
and theater.
Final Draft AV Sale Pr
Florian,
Reponses from, an ex-Oracle DBA, below.
On Mon, 2005-10-24 at 11:51 -0300, [EMAIL PROTECTED]
wrote:
> Date: Mon, 24 Oct 2005 14:29:24 +0200
> From: Florian Ledoux <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Subject: pg_dump, MVCC and consistency
> Message-ID: <[EMAIL PROTECTE
Nikolay,
I think I must be missing your point. Even if updatable views existed,
I would still have created Veil. The real point of Veil is to control
each type of operation (insert, update, etc) on each record.
With updatable views, you could avoid a lot of the tedium of creating
the instead-of
Brew,
Yep we tried that. It did nothing. The same pg_hba.conf change worked
when we later tried it with the client disconnected.
__
Marc
> Date: Fri, 16 Sep 2005 21:36:01 -0400 (EDT)
> From: [EMAIL PROTECTED]
> To: pgsql-general@postgresql.org
> Subject: Re: pg_ctl reload breaks our client
> Me
# [EMAIL PROTECTED] / 2005-07-27 10:03:15 -0400:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2005-07-27 08:56:24 -0400:
> >>How does one receive all mail to this list in a daily digest?
> >
> > Have you read the mailing list usage notes on the web site
set pgsql-general digest
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2005-07-27 08:56:24 -0400:
How does one receive all mail to this list in a daily digest?
Have you read the mailing list usage notes on the web site?
---(end of broadcast
# [EMAIL PROTECTED] / 2005-07-27 08:56:24 -0400:
> How does one receive all mail to this list in a daily digest?
Have you read the mailing list usage notes on the web site?
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KN
How does one receive all mail to this list in a daily digest?
-Andrew
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Yeah.. I'm with you.. I don't really know what all of this is about - I
like the way the Postgres mailing list works as it is Are any of the
changes being discussed here going to change the content or how we
receive the mailing lists?..
What exactly is the problem they thing exists anyways?..
I couldn't agree more!.. I've been watching the list every day just to
see what is going to be said next
Good stuff!
- Greg
>BTW, I think this thread is really interesting -- certainly more
>informative than a rehash of the usual "processes vs. threads" debate.
>
>-Neil
-
>
> I'm writing a very robust validation script in perl for database entry. One
> of the things I'd like to do is check how large a field is, and make sure
> that the entry into that field isn't too big. Problem is, for variable length
> fields, DBD::Pg returns a -1 size, using the pg_size attribu
Why is pg_dump not correct? You need to elaborate on the parameters of the
situation.
--rob
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 13, 2000 6:26 PM
Subject: Daily Digest V1 #108
> Daily Digest (mime) - Volum
A person who will remain nameless wrote:
> set digest
Perhaps it's time to remind people once again that sending list
management commands to the list repeater address accomplishes nothing,
except to annoy the hundreds of other members of the mailing list.
If you need to change/add/rem
set digest pgsql-general
E-tools 5.316 (Entity 5.212)
>
>PostgreSQL General Digest (mime) - Volume 1 : Issue 764
>
>Today's Topics:
> Re: 7.0 vs. 7.1 (was: latest version?)
>[Bruce Momjian <[EMAIL PROTECTED]>]
> Re: Alternate locations of DB's
Oops, sorry!
David
set digest
set digest
>
I don't know the internals of PostgreSQL, but logically INTERSECT is a join, but with
an automatic
default generation of the WHERE clause. As such, there should not be any difference in
performance
on tables that are large enough to mask small differences in the time it takes to
parse the
co
Help, I'm drowining in eMail... anybody know how to set digest mode?
Thanks
Rob
Hi!
As the digest of the general mailing list now (nearly) works perfectly
for me, i have a question:
Is it in the users hand to decide the size of the digest? I receive
digests 3-4 times a day but would be more happy receiving them only once
a day (which was true as long majordomo was ruling
set digest
set digest
end
Steven Pennie
Application Programmer/Analyst III
KDOT Materials & Research Center
2300 SW Van Buren
Topeka, KS 66611-1195
(785) 291-3863 - Fax (785) 296-2526
[EMAIL PROTECTED]
Groetjes/Greetinx,
Ger
--
Ger Hobbelt a.k.a. Insh_Allah mailto:[EMAIL PROTECTED]
--
###I feel the Need, the Need for
Sir:
I would like to know the detailed steps in installing PHP4. I downloaded
php-4.0b3 but i experienced difficulties in installing it. After I
installed it, my php script dont show up in the browser.
Thanks...
Manny C. Cabido
=
Sir,
I encountered a problem when my postgres 6.5.3 stop running. I
attempted to run the postmaster but an error was displayed on my screen
which goes like this:
[root@hindang bin]# /etc/rc.d/init.d/postgresql restart
Stopping postgresql service: [FAILED]
C
Hi Manuel,
If security is an issue then it is a good idea to keep the part of the
application that accesses the database on a secure system. Because a lot of
bad things are possible if the entire application runs on an uncontrolled
client and is given great authority and direct access to the data
Sir:
I working on an application that needs to access the postgresql
database using a web page. Java was suggested to me as a very good
platform. Can anyone give me some ideas where i can obtain some components
like the database components available to delphi or visual basic which i
can use in
Well, try to look at your pg_hda.conf file in PG_DATA.
this file contains all the ip address that can access your backend.
try to edit it.
ian
On Thu, 11 Nov 1999, Manuel Cabido wrote:
> Sir:
>
> I installed postgresql version 6.5.3 on my linux box using red hat linux
> 6.0 for i386. I
Sir:
I installed postgresql version 6.5.3 on my linux box using red hat linux
6.0 for i386. I want to connect to my postgres backend using borland
database engine through postgres odbc driver which i already installed. I
encountered problem connecting my frontend application to my postgres
back
dear sirs,
How to stop the "pgsql_general_digest"
thanks
rongjainwei
Aug. 26 1999
>> Hmm a very interesing theoretical topic...
>> Wouldnt make sense to tie this in with the implementation of a Foriegn
Key?
>> So when the foriegn key is defined you create anoter index that stores
all
>> the relevant child to parent relationships and can be used to speed up
that
>> access s
From: Randy Dees <[EMAIL PROTECTED]>
Subject:Access database from PostgreSQL?
I have just read the wonderful concise directions for accessing a
PostgreSQL database from MS Access, and just wondered: does anyone have a
procedure for accessing the Access database from Postgres? I'm no
76 matches
Mail list logo
