> On Aug 10, 2018, at 7:21 PM, Benedict Holland
> wrote:
>
> Oh this is an easy one. There are simpler solutions for PITR. Also, a PITR is
> a very specific case of a database use, if it even uses one. Generally
> speaking, you would not want to keep encrypted data within a database. There
Oh this is an easy one. There are simpler solutions for PITR. Also, a PITR
is a very specific case of a database use, if it even uses one. Generally
speaking, you would not want to keep encrypted data within a database.
There simply isn't a need for it. Just use a file or a folder. You can't do
On 08/10/2018 02:49 PM, Christoph Berg wrote:
> plv8 will work for anyone willing to go through that. It's just not
> feasible to support it from a packager perspective.
Hm. Gotta wonder if running this:
https://github.com/clkao/docker-postgres-plv8/blob/master/10-2/Dockerfile
and copying
> On Aug 6, 2018, at 10:45 AM, Bear Giles wrote:
>
> then it's reasonable to ask if storing the information in a relational
> database is the best approach.
Why? Just because its encrypted doesn’t mean it shouldn’t be stored in the
database. What about PITR, how would that be handled? You
The short answer I will provide from my experience is that you can't do it.
Your DBA will have access to just about anything across all tables and
databases.
The longer answer are ones that others have pointed out. If a DBA should be
restricted from tables, they probably shouldn't be your DBA.
Re: Bruce Momjian 2018-08-10 <20180810194407.ge7...@momjian.us>
> Wow, OK. That's bad news. So PL/v8 is no longer a viable stored
> procedure language?
It is bad news, the plv8 upstream is very pleasant to work with.
But now building plv8 means building v8 first, which means something
like
On Fri, Aug 10, 2018 at 09:41:44PM +0200, Christoph Berg wrote:
> Re: Bruce Momjian 2018-08-10 <20180810192205.gc7...@momjian.us>
> > Uh, who is building PL/v8 currently, and for what operating systems? No
> > one?
>
> No one is likely correct.
Wow, OK. That's bad news. So PL/v8 is no longer
Re: Bruce Momjian 2018-08-10 <20180810192205.gc7...@momjian.us>
> Uh, who is building PL/v8 currently, and for what operating systems? No one?
No one is likely correct.
Christoph
On Mon, Aug 6, 2018 at 06:19:55AM -0700, David G. Johnston wrote:
> On Monday, August 6, 2018, wrote:
>
>
> I have a request for revoking the access to user's data from DBA-user.
> I think the request is right because users should be the only ones can
> access their data.
>
>
>
On Fri, Aug 3, 2018 at 10:30:51AM +0200, Pavel Raiskup wrote:
> On Friday, August 3, 2018 8:08:55 AM CEST Devrim Gündüz wrote:
> > On Thu, 2018-08-02 at 16:26 +0300, Alexandru Lazarev wrote:
> > > What about 3rd party libraries like plv8 - Who and How (based on which
> > > criteria, which
On Fri, Jul 20, 2018 at 05:31:40PM -0700, Adrian Klaver wrote:
> JD sit down, I am going to agree with you:) The documentation as it stands
> is very good, though it requires some fore knowledge to successfully
> navigate. On pages with a lot of content it often is not evident, to many,
> that
Achilleas thanks for your answer
A query, the only possible way out is the postgres log?
I would like to be able to throw the audit output to a different place so
that I can not access the file
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
On 10/08/2018 17:01, dangal wrote:
Dear, I would like to ask you to see what you recommend
I manage a production database with a nominated user with the same
permissions as the postgres user SUPERUSER INHERIT CREATEDB CREATEROLE
REPLICATION
The client is asking us for an audit about this
Dear, I would like to ask you to see what you recommend
I manage a production database with a nominated user with the same
permissions as the postgres user SUPERUSER INHERIT CREATEDB CREATEROLE
REPLICATION
The client is asking us for an audit about this nominated user, could you
recommend any
On 08/10/2018 03:12 AM, Torsten Förtsch wrote:
Hi,
if I read https://www.postgresql.org/docs/9.6/static/sql-insert.html
correctly there can be only one conflict target or none at all.
What if I have a table with 3 unique constraints? If the first one is
violated by the insert I want to do
On Thu, Aug 9, 2018 at 3:51 PM Tom Lane wrote:
> Also, if you're using libpq, see PQserverVersion() which
> (a) avoids a round trip to the server, and (b) works further back
> than server_version_num, though that issue is probably academic
> to most folk at this point (server_version_num appeared
Adrien NAYRAT wrote:
> On 08/08/2018 04:09 PM, czezz wrote:
> > Hi everyone,
> > I want to aks if anyone knows is there a way to search for specific
> > "value" throughout list of tables OR all tables in databse?
> >
> > Cheers,
> > czezz
>
> Hello,
>
> Maybe this article by Daniel
On 08/08/2018 04:09 PM, czezz wrote:
Hi everyone,
I want to aks if anyone knows is there a way to search for specific
"value" throughout list of tables OR all tables in databse?
Cheers,
czezz
Hello,
Maybe this article by Daniel could help you :
Hello all,
I am trying to implement a C function that accepts a date ("date" in
the sense of a type of information, not a postgres datatype) as
parameter (among others) and returns a certain point in time. (The
background is to calculate the time of dawn and dusk at the given
date.) Ideally,
19 matches
Mail list logo