to really configure it to
their requirements.
Thanks again for your help.
On Thu, Mar 19, 2020 at 7:19 PM Tom Lane wrote:
> Dave Hughes writes:
> > I have a requirement to set some password complexity for our database
> such
> > as length of password, upper case, lower cas
t;how" to set up
specific requirements?
Thanks in advance,
Dave Hughes
Oh okay! I wasn't aware of the pg_settings system view. Thanks for all
the info!
On Thu, Nov 21, 2019 at 1:36 PM Joe Conway wrote:
> On 11/21/19 1:27 PM, Dave Hughes wrote:
> > Thank you so much for all your help! I found out my issue on accident
> > actually. I b
set those settings back, it's working perfectly
now.
Thanks again for helping me getting this thing setup and working!
On Thu, Nov 21, 2019 at 10:15 AM Joe Conway wrote:
> On 11/20/19 5:54 PM, Dave Hughes wrote:
> > Thanks for the tips Joe! After fighting with this all day, I rea
On Wed, Nov 20, 2019 at 9:46 AM Joe Conway wrote:
> On 11/20/19 8:09 AM, Dave Hughes wrote:
> > Hey,
> > Thanks for reaching out. It looks like I have that parameter set as
> > well. Here is a list of settings I have turned on in postgresql.conf
> > since I
19, 2019 at 4:27 PM Rajni Baliyan wrote:
> Hello Dave,
> What I can see is you missed to include pgAudit extension in
> shared_preload_libraries parameter (*shared_preload_libraries='pgaudit'*
> ).
>
> Thanks
> Rajni
>
> On Wed, Nov 20, 2019 at 7:39 AM Dave
creen and not in
the log file. At this point I restarted the database again and now when I
run the command: show pgaudit.log; it defaulted back to 'Role' (vs. ddl).
Can someone please help me see what it is i'm doing incorrectly?
Thanks in advance,
Dave Hughes
Mantzios <
ach...@matrix.gatewaynet.com> wrote:
> On 18/11/19 9:56 μ.μ., Dave Hughes wrote:
> > Hello,
> > I'm using PostgreSQL 10.5 on Linux (RHEL). I'm new to administering
> PostgreSQL and recently installed pgaudit. I believe I have it installed
> correctl
my main PostgreSQL directory (/work/PostgreSQL/10)I do have a file
called "logfile", but there are no entries from today. When I go into the
pgaudit sub-directory (/work/PostegreSQL/10/pgaudit) I don't see any log
file in there either?
Can someone point me in the right direction?
Thanks,
Dave Hughes
instances.
Thanks again for pointing me in the right direction.
On Fri, Nov 15, 2019 at 11:44 AM Christoph Moench-Tegeder <
c...@burggraben.net> wrote:
> ## Dave Hughes (dhughe...@gmail.com):
>
> > However when I try to log in now, via command line, I receive the error:
> &g
Hello,
We're currently using PostgreSQL version 10.5 in a Linux environment. We
were wanting to change the password authentication from MD5 to
SCRAM-SHA-256. I performed these steps to do so:
1) Modified the postgresql.conf and changed the password_encryption entry
from "md5" to "scram-sha-256".
We have one database with several schemas. We have several groups of
developers that have the need to be able to collaborate including creating
and dropping tables.
I noticed it became difficult to manage because when one developer creates
a table, he is now the owner. All the other developers n
I recently noticed that my default superuser "postgres" cannot create
tables in new schemas I create, but can in some existing ones.
So as the postgres user I ran:
afleads=# create schema mytest;
CREATE SCHEMA
afleads=# create table mytest.test (col1 int);
ERROR: permission denied for schema myte
13 matches
Mail list logo
