On 1/21/2017 1:37 PM, Stephen Frost wrote:
* PAWAN SHARMA (er.pawanshr0...@gmail.com) wrote:
So, there is no solution for my first question, we need if users enter the
wrong password more than 5 times than their account gets locked and then
only DBA will unlock this account.
I understood the qu
* Thomas Kellerer (spam_ea...@gmx.net) wrote:
> Stephen Frost schrieb am 21.01.2017 um 22:37:
> >>So, there is no solution for my first question, we need if users enter the
> >>wrong password more than 5 times than their account gets locked and then
> >>only DBA will unlock this account.
> >
> >I u
Stephen Frost schrieb am 21.01.2017 um 22:37:
So, there is no solution for my first question, we need if users enter the
wrong password more than 5 times than their account gets locked and then
only DBA will unlock this account.
I understood the question and there is an answer- use PAM.
What
Pawan,
Please be sure to include the mailing list on replies, so others can
benefit from the discussion. Also, please reply in-line, as I do below,
instead of top-posting.
* PAWAN SHARMA (er.pawanshr0...@gmail.com) wrote:
> So, there is no solution for my first question, we need if users enter t
Pawan,
* PAWAN SHARMA (er.pawanshr0...@gmail.com) wrote:
> 1. How can we set user account block feature after max number of
> invalid password entries?
There are ways to accomplish this, but they're unfortunately
complicated. In the past, I've implemented these kinds of requirments
by using the
On Sun, Jan 22, 2017 at 12:32:21AM +0530, PAWAN SHARMA wrote:
> I have few question regarding Postgres security.
>
> 1. How can we set user account block feature after max number of
> invalid password entries?
> 2. How can we use SSL encryption in Postgres on Linux environment?
> 3. How can we
Hi All,
I have few question regarding Postgres security.
1. How can we set user account block feature after max number of
invalid password entries?
2. How can we use SSL encryption in Postgres on Linux environment?
3. How can we transparent data encryption in Postgres?
Thanks
Em 21-10-2016 13:48, Adrian Klaver escreveu:
On 10/21/2016 08:09 AM, Edilmar LISTAS wrote:
Hi,
I have 4 PG servers where each one runs many databases.
Now, I would like to create just one PG backup server to replicate all
the databases from 4 PG servers, is it possible? Or Do I need to create
On 10/21/2016 08:09 AM, Edilmar LISTAS wrote:
Hi,
I have 4 PG servers where each one runs many databases.
Now, I would like to create just one PG backup server to replicate all
the databases from 4 PG servers, is it possible? Or Do I need to create
4 PG backup servers?
More information is nee
Hi.
You mean one and only one big cluster with all databases from your 4 PG
servers ?
What about running 4 clusters (different ports) in your backup server and
each taking replication from your master servers.
Regards,
Walter
On Fri, Oct 21, 2016 at 12:09 PM, Edilmar LISTAS
wrote:
> Hi,
>
> I h
Hi,
I have 4 PG servers where each one runs many databases.
Now, I would like to create just one PG backup server to replicate all
the databases from 4 PG servers, is it possible? Or Do I need to create
4 PG backup servers?
And if some PG server goes down, how to recovery the system from PG
Thanks Rakesh.
Let me explain my reason to have a replica server.
We run odoo server 7.x with ubuntu 14.
But we are working on a BI system right now(Pentaho), them we want to
run those heavy reports on the replica and let the current production
system on the master.
This is why I was thinking o
>Other thing, with bucardo what is the difference between in a
>master-master replica vs master-slave, at the end in both ways the
>user has a 2nd DB with R/W permission?
I think in a M-M mode, updates from both dbs will be replicated to the other db.
In other words they will be eventually consist
Thanks Rosser for your answer.
Other thing, with bucardo what is the difference between in a
master-master replica vs master-slave, at the end in both ways the
user has a 2nd DB with R/W permission?
Thanks.
On Thu, Oct 13, 2016 at 9:40 PM, Rosser Schwarz
wrote:
> On Thursday, October 13, 2016,
tify
the sender by
phone or email immediately and delete it!
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayadevan M
Sent: 30 March 2014 20:45
To: pgsql-general@postgresql.org
Subject: [GENERAL] Doubts on startup costs
Hi,
A few academic
Hi,
A few academic questions related PostgreSQL query planner and output -
In the output of EXPLAIN for SQL statements I have seen so far, the startup
cost for the innermost node/leaf has been 0. Are there situations where it
may be non-zero?
The startup costs for outer nodes will always be equa
On Thu, Feb 27, 2014 at 7:39 AM, Vinay Gupta wrote:
> 1078769 s/d/r:1663/1228184/5263108,insert_leaf:
> 1155642 s/d/r:1663/1228184/5263105,insert:
> 1181241 s/d/r:1663/1228184/5263107,insert_leaf:
>
> Is dere any better way where i can analyse who is contributing most in my
> pgxlog file generat
Hi,
Is dere any better way we can understand the contents of pg_xlog files. I
am using xlogdump for analysing my xlog contents. Sometimes in my database
server in some particular hours, the pgxlog files generation exceeded than
the expected counts almost 3X than the normal count.
*--- Size of 1
On Thu, Feb 18, 2010 at 11:08 PM, Scott Marlowe wrote:
> Oracle and postgres are definitely different here. There's really no
> equivalent to rowid in pgsql. oid has no special optimizations. An
> indexed PK of a serial is about as good as it gets, possibly
> clustered.
access by CTID is the f
Jayadevan M escribió:
> I am an Oracle guy who is learning PostgreSQL. oid sounded a lot like
> rowid in Oracle. In Oracle, access by rowid is expected to be the fastest
> way of accessing a record, faster than even an index access followed by
> table access using the primary key. That was why
Hi,
> Even in Oracle, I don't believe rowid bypasses
> indexes, its more like an implicit SERIAL PRIMARY KEY field.
Well, I understand the point is not very relevant, since oid is not
similar to rowid. In Oracle, index scans are bypassed if we use rowid.
1)Access by unique index
SQL> select *
Jayadevan M wrote:
Hi,
> The primary question that needs to be asked is what do you want to
do with them?
> It is not so much a performance issue as an admin issue. OIDs where
created for
> Postgres internal system use and leaked out to user space. As a
result they
> have some shortcomings as
On Thu, Feb 18, 2010 at 8:46 PM, Jayadevan M
wrote:
>
> Hi,
> > The primary question that needs to be asked is what do you want to do with
> > them?
> > It is not so much a performance issue as an admin issue. OIDs where created
> > for
> > Postgres internal system use and leaked out to user spa
Hi,
> The primary question that needs to be asked is what do you want to do
with them?
> It is not so much a performance issue as an admin issue. OIDs where
created for
> Postgres internal system use and leaked out to user space. As a result
they
> have some shortcomings as detailed in the ab
On Wednesday 17 February 2010 8:13:51 pm Jayadevan M wrote:
> Hi,
> I was reading about oid and default configuration of PostgreSQL. A couple
> of doubts
> 1) Why is use of OIDS considered deprecated? Is there something else that
> can be used in place of oids for user tables?
Sequences:
http://w
Hi,
I was reading about oid and default configuration of PostgreSQL. A couple
of doubts
1) Why is use of OIDS considered deprecated? Is there something else that
can be used in place of oids for user tables?
2) Is there a performance impact if we keep the default default_with_oids
to ON?
Googli
sangeetha k.s wrote:
> hello,
>
> postgresql uses bitmap indexing for indexing in databases.
> *Is there any technique used*
> * used to compress the bitmap indices in postgresql*,like oracle that uses
> Byte Aligned bitmap compression to compress bitmaps.
Postgres does not support
hello,
postgresql uses bitmap indexing for indexing in databases.
*Is there any technique used*
* used to compress the bitmap indices in postgresql*,like oracle that uses
Byte Aligned bitmap compression to compress bitmaps.
regards,
sangeetha.
28 matches
Mail list logo
