Hi.
I had to implement something similar some time ago. Basically, a group of
database servers (postgres) geographically distributed, with each one having a
group of servers in each datacenter, and each server preferring the nearest
database server, but allowing connections to a further one if
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
Simon Windsor schrieb am 21.01.2017 um 21:26:
I was wondering if there is another option that will allow me to
spool all ALTER|CREATE|DELETE|DROP|INSERT|UPDATE commands to all
nodes, and SELECTs to any of the connected nodes. The apllication can
actually handle separate READ|WRITE nodes from how
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
Hi
Thanks for the reply. We were not planning to use pgPools connection
pool mode, but its replication mode.
Our tests with pgPool allow us to install a backup db via pgPool to each
node, and tests loads overnight of 10+GB of inserts/updates/deletes all
work fine, with only a slight loss of
Simon,
* Simon Windsor (simon.wind...@cornfield.me.uk) wrote:
> My employer wants to move from an in house Oracle solution to a
> cloud based Postgres system. The system will involve a number of
> data loaders running 24x7 feeding several Postgres Databases that
> will be used by internal applicat
Hi
My employer wants to move from an in house Oracle solution to a cloud
based Postgres system. The system will involve a number of data loaders
running 24x7 feeding several Postgres Databases that will be used by
internal applications and external customer applications.
For the record, inte
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
Amitabh Kant writes:
> command: "/var/tmp/pgbin.SPOsRj4D/bin/pg_ctl" -w -l "pg_upgrade_server.log"
> -D "/usr/local/pgsql/data91" -o "-p 50432 -b -c listen_addresses='' -c
> unix_socket_permissions=0700 -c unix_socket_directory='/usr/local/pgsql'"
Note the unix_socket_directory parameter, which
Just share the slides/video in this thread friend.
On Sat, Jan 21, 2017 at 10:57 AM, Seref Arikan
wrote:
> Any chance this will be recorded? The content looks great and would be of
> interest to many.
>
> Cheers
> Seref
>
>
> On Sat, Jan 21, 2017 at 8:55 AM, Chris Travers
> wrote:
>
>> Hi;
>>
>
Hi
I am trying to upgrade an exisitng Postgresql cluster from 9.1 to 9.5 on
FreeBSD. pg_upgrade fails with the following error:
[Verbose Output: http://pastebin.com/YhR8vD03]
==
$ /usr/local/bin/pg_upgrade -k -d /usr/local/pgsql/data91 -D
/usr/local/pgsql/data --old-bindir=/var/tmp/pgbin.SPOsRj4
Any chance this will be recorded? The content looks great and would be of
interest to many.
Cheers
Seref
On Sat, Jan 21, 2017 at 8:55 AM, Chris Travers
wrote:
> Hi;
>
> I have been asked to deliver a seminar on use of PostgreSQL in large data
> environments. I have decided to send this to the
Hi;
I have been asked to deliver a seminar on use of PostgreSQL in large data
environments. I have decided to send this to the general list as well
because I think it may be of general interest here,
We will be talking about how problems and solutions for PostgreSQL when
using it to manage 10-12
17 matches
Mail list logo
