DiffKit 0.8.2 introduces support for PostgreSQL
DiffKit is Free and Open Source Software (FOSS).
http://www.diffkit.org
DiffKit is an application, and a framework, for comparing two tables
of data, field-by-field. The tables can come from any of a number of
sources, such as an RDBMS or CSV file,
ON LEVEL SERIALIZABLE;');
cursor.execute(query_1, (param1,))
rs1 = cursor.fetchall()
cursor.execute(query_2, (param2,))
rs2 = cursor.fetchall()
cursor.execute('commit;');
Hope that helps,
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
All
timestamps are converted into the local time of the computer querying the
database (seems to be a .Net System.DateTime limitation rather than
anything else).
Hope it goes well.
Joe Healy
---(end of broadcast)---
TIP 8: explain analyze is your friend
ndows port, e.g., PATH
settings and installation?
Joe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
that starts the
postmaster and then sits and waits for a signal to shutdown the service?
Joe
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tom Lane wrote:
Joe <[EMAIL PROTECTED]> writes:
I see there's a pgsql-cygwin list and a pgsql-hackers-win32 list, but
no pgsql-win32 list. I browsed through the pgsql-novice and
pgsql-general archives and only saw a few Windows-related posts.
Which of those two lists is most appr
o if I were to
append it, it would still not find the PostgreSQL version. This again may
indicate the tech-savvy expected of PostgreSQL users.
Joe
---(end of broadcast)---
TIP 8: explain analyze is your friend
greSQL trying to break beyond its traditional user base? Or do
Pervasive, SRA, etc., provide their own documentation, geared more to users who
may be, say, more "business oriented"?
Joe
---(end of broadcast)---
TIP 3: if posting/reading
to *use* the programs. I can easily figure out by inspection after
the install, that all/most of the executables ended up in the 'bin' directory so
I need to add it to my PATH. Nevertheless, I still expect a README, FAQ or the
manuals to point this out for completeness, i.e., regar
tables or views. For example, a database that occupied 50 GB would be
considered large even it had a dozen tables (most likely with a few of those
having millions of rows). Conversely, a database with 500 tables but occupying
only 1/2 GB would likely be considered small or medium.
Joe
else? AFAICT, the application does not
directly do any arithmetic on these columns, but the identifier and code types
are used as indices into PHP arrays. The month/day values are formatted into
dates for display (and the month also servers as an index into a month-name array).
BTW, i
er than it being shorter
to type :-) or is it just the "usual Postgres way"?
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
supporting
NCHAR/NVARCHAR, aka NATIONAL character data? Wouldn't UCS-16 be needed to
support multi-locale clusters (as someone as inquiring about recently)?
Joe
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Alvaro Herrera wrote:
On Tue, Jul 12, 2005 at 05:37:32PM -0400, Joe wrote:
If it stored character data in Unicode (UCS-16) it would always take
up two-bytes per character.
Really? We don't support UCS-16, for good reasons (we'd have to rewrite
several parts of the code in order
erprets the
zero day of month as the former). Any suggestions (aside from designing a new
datatype)?
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
nto three columns and that's rather ugly.
Thanks for the feedback.
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
\330k!\244\301\216w\366\000m\300\333
They numbers after the NOTICE: section are apparently random.
Any idea what these are / what they mean?
-Joe
P.S. please CC me since I am not subscribed to this list.
---(end of broadcast)---
TIP 2: you can get
any plans to
deprecate or disallow the former at some point)? Are other UNIX/Linux
ports in the same boat, or does any Linux port offer users a choice in
this matter? Would any change to the build/install procs have to be
done through the current port maintainer or are they somewhere in the
Po
x27;d have to patch them any time I fetched a port update.
So I guess the port procedures are not controlled by the Development Group?
Joe
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscri
7;pgsql' user invokes psql without specifying a database, there's no
'pgsql' database to be found.
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
one bit. This is trivially done by altering the ~pgsql/.profile file
and adding PGUSER=postgres and exporting that variable. Do this *before*
you init the DB, then run initdb with this comand:
su - pgsql -c 'initdb -U postgres'
From now on, any upgrades you do will no longer be so pain
Leaving directory `/ufs/gnu/postgresql-7.1.2/src'
make: *** [all] Error 2
Any ideas?
Installing postgresql has so far been both painfull and a learning
experiance.
Joe
Childrens Hospital of Pittsburgh
---(end of broadcast)---
TIP 3: if posting/
Is there a way to synchronize data between postgresql on a local machine
and postgresql on a remote web server? Maybe use the TCP/IP Connection
with SSH somehow? Anyone done this or have any good ideas? Thanks a lot,
Joe
Anything that can be done without waiting for erserver? I need to find a
solution asap. Any ideas at all would be great. I don't even know where
to really begin. Thanks,
Joe
the remote
server, and rename the temp one to the name of the one I dropped (make
sense?). I'm sure there are some major flaws with my theory (I'm fairly
new to postgresql)...please let me know. Thanks,
Joe
This seems like a simple enough thing, and I'm sure it's been answered,
but I couldn't find anything that helped in the archives. Basically, I
have a column in my table that was, once upon a time, large enough, but
now, I need to increase the site of the column. How can I do that?
Thanks,
Joe
ows the new column. Did I miss a step? Thanks,
Joe
Len Morgan wrote:
> >I have a column in my table that was, once upon a time, large enough, but
> >now, I need to increase the site of the column. How can I do that?
>
> Basically, you can't. What you need to do is dump th
ly, but isn't this what you want?
8<---
create table t2(a text);
insert into t2 values('abc,def'),('abcd');
show lc_collate;
lc_collate
-
en_US.UTF-8
(1 row)
select a from t2 order by a;
a
-
abcd
abc,def
(2 rows)
select a from t2 or
27;ll find
> direct for second variable we don't know where it's end with -
>
> i.e ,
> i need to find second postition of the variable between the '-'
Are you looking for the position or the actual variable? If you really
want the latter you can do:
select spl
y ideas...?
Just a guess, but if indeed ssl.h is located in
/usr/local/ssl/include/openssl
based on the error message I would try:
--with-includes=/usr/local/ssl/include
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, &am
On 10/30/2015 10:27 AM, rajan wrote:
> The function is created as postgres user.
>
> And I get a permission denied error.
If you want help solving this, I suggest you post a minimal, self
contained test case (i.e. SQL statements) which anyone can run to
reproduce your issue.
o find the patch that fixed a good bit of the slowness and
backport it to the older version so we could successfully run pg_upgrade
(in something like 14 hours instead of 7+ days).
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
something to try. Thanks!
I'd recommend you also look at pgbackrest:
https://github.com/pgbackrest/pgbackrest
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
T STABLE SECURITY DEFINER;
CREATE POLICY account_ownership ON accounts FOR SELECT
USING (owner_id = get_owner_id(current_user));
CREATE ROLE foo;
SET ROLE foo;
SELECT * FROM accounts;
id | name | owner_id
+--+--
1 | foo |1
2 | bar |1
(2 rows)
8<
On 12/17/2016 01:01 PM, Simon Charette wrote:
> Thanks a lot Joe, that seems to work!
Good to hear.
> I suppose this works because PostgreSQL cannot introspect the
> get_owner_id procedure to detect it's querying the "accounts" table
> and thus doesn't warn a
On 12/17/2016 02:04 PM, Stephen Frost wrote:
> Note that RLS won't be applied for the table owner either (unless the
> relation has 'FORCE RLS' enabled for it), so you don't have to have
> functions which are run as superuser to use the approach Joe
> recommende
ironment as seen by the OS user the postmaster runs
under)?
See: http://www.postgresql.org/docs/9.4/static/libpq-envars.html
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
On 12/16/2015 04:53 PM, James Sewell wrote:
> No it is not.
>
> Just in case I tried setting it to 'postgres', logged in without -U
> (doesn't work without PGUSER set) and tried the operation again.
> > DETAIL: FATAL: role "PRDSWIDEGRID01$" does not exist
That "PRDSWIDEGRID01$" is comi
On 12/16/2015 06:10 PM, James Sewell wrote:
> Oops left off the list.
Me too -- response repeated below...
> -- Forwarded message --
> From: *James Sewell* <mailto:james.sew...@lisasoft.com>>
> Date: Thursday, 17 December 2015
> Subject: dblink_connec
y will finish quickly and have minimal
impact.
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
, the next query will return an
> error like CONNECTION_BAD. there's no possible privilege elevation.
+1
I think you can call this one "Applicable -- Inherently Meets"
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
ed definition will not be dumped by
pg_dump. Such a change is usually only sensible if you concurrently
make the same change in the extension's script file."
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
itrary queries, just one very specific one. See
http://www.postgresql.org/docs/9.5/interactive/sql-createfunction.html
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
d require to that thread.
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
On 03/02/2016 11:53 AM, Joshua D. Drake wrote:
> On 03/02/2016 11:37 AM, Joe Conway wrote:
>
>> http://www.postgresql.org/message-id/flat/CA+Tgmoa=4vti1hb1hta0+qbzlojkpjbd5dkvw3zmp-kdwje...@mail.gmail.com#CA+Tgmoa=4vti1hb1hta0+qbzlojkpjbd5dkvw3zmp-kdwje...@mail.gmail.com
>>
&
On 03/02/2016 12:14 PM, Julien Rouhaud wrote:
> On 02/03/2016 20:56, Joe Conway wrote:
>> I thought there was once a link somewhere on the mail archives to get a
>> specific email resent, but for the life of me I cannot find it today :-/
>>
>
> It's only available
end can be used by
your PL. There is not a lot of documentation other than in the source
code itself. Look at examples, see what they do, emulate it.
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
ter answer than before: grep and/or read source
for other PLs.
FWIW here are examples from PL/R for incoming (argument) and outgoing
(result) conversions of scalar values:
https://github.com/jconway/plr/blob/master/pg_conversion.c#L632
https://github.com/jconway/plr/blob/master/pg_conversion.c#L100
ct throw_notice('hello');
8. Return to gdb session, debug away...
HTH,
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
nd I'm sure there are HMAC functions available that
could be used in PL/Perl and/or PL/Python.
Joe
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
th simulation such as this you can answer
your own question...
Joe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
d be great.
Thanks,
Joe
Sick sense of humor? Visit Yahoo! TV's
Comedy with an Edge to see what's on, when.
http://tv.yahoo.com/collections/222
t, as I already have one that works.
Thanks,
Joe
Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for
today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow
(1 row)
or this:
select array['1'::varchar]::int[];
array
---
{1}
(1 row)
or this:
select array(select '1'::varchar)::int[];
int4
--
{1}
(1 row)
or maybe this:
select ('{}'::varchar[] || '1'::varchar)::int[];
int4
--
{1}
(1 row)
| 0 | 98.
A| 2 | 98.
An alternative way to get the output below, would be to feed your
aggregate query above to the crosstab() function in contrib/tablefunc.
Joe
=> select code, round(avg(case when subset = '0' then value else null
end),0) as v0,
rou
Ow Mun Heng wrote:
On Thu, 2007-09-06 at 20:19 -0700, Joe Conway wrote:
An alternative way to get the output below, would be to feed your
aggregate query above to the crosstab() function in contrib/tablefunc.
I just looked at it and seems like the
...
row_name and value must be of type
Hi,
Is there a way to get the oracle's rank() over partition by queries in
postgresql? For example if I have a query like
Select Col1, Col2, RANK() OVER(PARTITION BY Col1 order by Col3 desc) as rank
from table1
Thanks in advance
Hi,
Im a newbie to postgres. Can you explain what pgpool is ?
Thanks
Hi,
Does pgpool II support foreign key constraints on partitions? If so, how?
Thanks
tgres IS in the same directory as initdb
8.1 installed OK on my Etch server so I tried that on sid
Same result
Anyone any ideas?
--
Regards, Joe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
Tom Lane wrote:
so it's trying to pstrdup a null result from SPI_getvalue.
Obviously it shouldn't crash, but I'm not sure what it *should* do in
this case. Joe?
The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to
Tom Lane wrote:
Jorge Godoy <[EMAIL PROTECTED]> writes:
Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu:
The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to skip those rows entirely. Of
course you could argue I suppose t
Tom Lane wrote:
Jorge Godoy <[EMAIL PROTECTED]> writes:
Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu:
The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to skip those rows entirely. Of
course you could argue I suppose t
ems that evaluate good.
I haven't played with it myself, but it seems to me that you could do
this with an inner join of two crosstabs -- one on t_data and one on the
filters (i.e. you join on the columns of the filter crosstab to the
matching ones in the t_data crosstab).
Joe
Reg Me Please wrote:
Il Wednesday 21 November 2007 20:22:46 Joe Conway ha scritto:
Reg Me Please wrote:
The meaning is that an entity called by the value of "item" has a number
of properties called by "property" with value "prop_value".
So, for a single &quo
o fix it.
>
> regards, tom lane
Hi Guys,
You can usually get pre-built versions of Postgres for HP-UX here:
http://hpux.connect.org.uk/hppd/cgi-bin/search?package=on&description=on&term=postgres&Search=Search
Only 9.0 there at the moment, but they are usual
into the
> first available column. If you want the value columns to correspond to
> specific categories of data, and some groups might not have data for
> some of the categories, that doesn't work well. The two-parameter form
> of crosstab handles this case by providing an explicit
"object graph" not
> "image representation of data".
Analysis of graphs is available via PL/R as well. See:
http://cran.r-project.org/web/views/gR.html
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
++----
a || 1.23
b| 2.34 |
(2 rows)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
in the app code.
>
> Any advice or clues? I need the app to work on both platforms.
Just a guess, but maybe DNS lookup time? Try using IP address instead of
FQDN.
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Con
M clause
>> rowtype
> Hmm. I can reproduce this in 8.4 too, but it seems OK in 9.0. The only
> one of the 9.0 commits that seems likely to be relevant is
> http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=56cbb611ec749ba867a4cfc09c8b7df0f4446620
> which looks a
.org/index.php -- is
bidirectionally linked with sipx-us...@list.sipfoundry.org
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
owdt::date, temperature FROM mytable ORDER BY 1$$,
$$VALUES('2003-03-01'),('2003-03-02'),('2003-03-03')$$
)
AS
(
rowid text,
"2003-03-01" int,
"2003-03-02" int,
"2003-03-03" int
);
rowid | 2003-03-01 | 2003-03-02 | 2003-03-03
--
mperature FROM
mytable WHERE 1 = 1 ORDER BY
1,2','VALUES($v$2003-03-01$v$),($v$2003-03-02$v$),($v$2003-03-03$v$)')
AS (rowid
contrib_regression(# text,"2003-03-01" int,"2003-03-02" int,"2003-03-03"
int);
rowid | 2003-03-01 | 2003-03-02 | 2003-03-03
---+--
27; quote '"';
select * from testcsv;
id | f1| f2 | f3
+---------+-+
1 | testing 123,456 | hello world | 42
(1 row)
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
)
I would've thought that the "right thing" would have involved prepending
the schema to the constraint name, e.g.,
product.product_product_code_key as is done for the table names in the
\d output. Is this a bug or does regclass only do the "right thing" for
tables and not for constraints?
Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Tom,
On 03/18/2011 12:17 AM, Tom Lane wrote:
Joe Abbate writes:
I'm using this to validate a tool I'm building and I get an error on the
following query:
autodoc=> SELECT conname::regclass FROM pg_constraint
autodoc->WHERE contype = '
HI Tom,
On 03/18/2011 12:42 AM, Joe Abbate wrote:
For my immediate needs, the query was actually the target of a NOT IN
subquery of a query against pg_index (trying to exclude tuples of
indexes for UNIQUE constraints) and I've solved that by using conrelid
in the subquery (and indrelid i
e = int[]
);
select grp, pairwise_sum(a) from regres group by grp;
grp | pairwise_sum
- -+--
1 | {14,16,19}
2 | {11,13,15}
(2 rows)
HTH,
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consu
pful"
http://no0p.github.io/postgresql/2014/09/06/benchmarking-postgresql-btrfs-zlib.html
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-BEGIN PGP SIGNATURE---
hibit hall, all Saturday/Sunday speaker tracks, and evening events
(excludes the Linux Training Class).
Schedule:
http://www.socallinuxexpo.org/scale11x/schedule/friday
Register:
https://reg.socallinuxexpo.org/reg6/
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general
nting the paging transparently beneath the
dataframe object, but have not gotten around to it. Apparently the
Oracle connector to R is able to do that, so I'm sure it is a SMOP.
Joe
- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Servi
i.e. work on one
group at a time) or use the SPI cursor functionality within the PL/R
function and page your data using a cursor. Not all forms of analysis
lend themselves to these approaches, but perhaps yours does.
Ultimately I would like to implement a form of R data.frame that does
the pa
ontrib_regression set search_path to foobar;
select * from pg_db_role_setting ;
setdatabase | setrole | setconfig
- -+-+--
0 | 16401 | {search_path=bar}
16384 | 0 | {search_path=foobar}
(2 rows)
Is that what you are looking for?
HTH
y talk
slide-decks:
https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
about to test it too), but while this is in
> beta I need a solution to keep up with my architecture... I can't stay
> with a single server and no backup (except a snapshot of the disk made
> on a daily basis... but that's no real backup) waiting for Cloud SQL to
>
ch file or directory\n\tIs the server running
>> locally and
>> accepting\n\tconnections on Unix domain socket
>> "/tmp/.s.PGSQL.5432"? in /httpd/iliffe/testfcgi.php on line
>> 121
This might be a silly question, but is PHP running on
On 04/08/2017 06:31 AM, John Iliffe wrote:
> On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote:
>> On 04/07/2017 07:45 PM, Joe Conway wrote:
>> > On 04/07/2017 05:35 PM, Adrian Klaver wrote:
>> >> On 04/07/2017 05:03 PM, John Iliffe wrote:
>> >&g
ot;5432"
8<-
That will try to use a tcp connection on localhost instead of a unix socket.
Another question I don't believe has been asked is, what does your
pg_hba.conf look like?
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consul
On 04/09/2017 11:33 AM, John Iliffe wrote:
> On Saturday 08 April 2017 18:10:35 Joe Conway wrote:
>> On 04/08/2017 01:23 PM, John Iliffe wrote:
>> > On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote:
>> >> So what if you change the connection to use -h localh
On 04/09/2017 12:37 PM, John Iliffe wrote:
>> > Thanks Joe. I Changed the pg_connect line in the script to:
>> > $db_handle = pg_connect('dbname=yrarc host=192.168.1.6 port=5432
>> > user= password=xx');
> If I may be permitted a rant at
at this is not the case.
See set_user for a possible solution: https://github.com/pgaudit/
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
On 06/09/2017 08:56 AM, Ken Tanzer wrote:
> On Fri, Jun 9, 2017 at 6:42 AM, Joe Conway wrote:
> See set_user for a possible solution: https://github.com/pgaudit/
>
> Thanks! Looking at the README, it seems like the intended use case is
> the opposite (escalating privil
ons will be
> blocked. If set to "off," the log statement setting is left unchanged.
Sounds good, will make that change or something similar -- thanks for
the feedback.
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature
y against the system catalogs though to loop through
the members of the group and execute this statement against each one.
Maybe rerun it periodically.
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
#x27;
>AND g.rolname = 'module_dm;'
> ORDER BY 1, 2;
The problem with that query is is you have more than one level of
nesting. E.g.:
Role name | Attributes| Member of
+---------
bly.
Does anyone have other suggestions for how best to achieve a performant query?
Thanks,
-Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
bly.
Does anyone have other suggestions for how best to achieve a performant query?
Thanks,
-Joe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 10/20/2017 02:10 PM, Tom Lane wrote:
> "David G. Johnston" writes:
>> On Fri, Oct 20, 2017 at 1:12 PM, rakeshkumar464
>> wrote:
>>> How do I know beforehand where the dir path is ?
>
>> I think pg_config (
>> https://www.postgresql.org/docs/current/static/app-pgconfig.html ) is what
>> you ar
lications?
If you still need more control over what Postgres allows, see the
ssl_ciphers configuration setting here:
https://www.postgresql.org/docs/current/static/runtime-config-connection.html#GUC-SSL
HTH,
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterp
1 - 100 of 518 matches
Mail list logo
