Hi,
I'm trying to install PostgreSQL database on my personal laptop that is
running on Windows 10 Home 64-bit operating system.
I found the s/w @ https://www.postgresql.org/download/windows/
The webpage shows that PostgreSQL v10 (latest is v12) is available for
Windows 10 64-bit, but it doesn't t
On 26-May-20 10:20, Stephen Frost wrote:
[...]
"out of sync" is a bit of an odd concept, but having a replica fall
behind a long way is certainly something that can happen and may require
a rebuild from a backup (or from a new sync off of the primary in some
other way, as you suggest below). In
Hi Prashanth,
On Wed, May 27, 2020 at 8:59 AM Prashanth Talla
wrote:
> Hi,
> I'm trying to install PostgreSQL database on my personal laptop that is
> running on Windows 10 Home 64-bit operating system.
>
> I found the s/w @ https://www.postgresql.org/download/windows/
>
> The webpage shows that
Hi Team,
Thanks for your support.
Could someone please suggest the process to *sync the data from PROD DB to
the Staging environment* with minimal manual intervention or automatically.
Thanks & Regards,
Postgann.
Hi Postgann,
How frequently do you sync *hourly/daily/weekly*? Do you have other
processes writing data into Staging env?
Regards,
On Wed, May 27, 2020 at 5:56 PM postgann2020 s
wrote:
> Hi Team,
>
> Thanks for your support.
>
> Could someone please suggest the process to *sync the data from P
Hi Team,
Thanks for your support.
Currently, we are using tomcat for scheduling and want to replace it with
DB specific schedulers.
Could someone please suggest the Schedular for application activities
instead of creating tomcat schedulers.
Also scheduler for DB specific activities as well inste
Hi Luan,
Thanks for your email.
How frequently do you sync *hourly/daily/weekly*? > looking for a daily
basis.
Do you have other processes writing data into Staging env? > Yes, we have
old PROD data.
Thanks & Regards,
Postgann.
On Wed, May 27, 2020 at 9:33 PM Luan Huynh wrote:
> Hi Postgann
Thank you Olivier for your reply. It's just for me to practice.
Thank you,
Prashanth.
On Wed, May 27, 2020, 2:12 AM Olivier Gautherot
wrote:
> Hi Prashanth,
>
> On Wed, May 27, 2020 at 8:59 AM Prashanth Talla
> wrote:
>
>> Hi,
>> I'm trying to install PostgreSQL database on my personal laptop
On Wed, May 27, 2020 at 8:56 AM postgann2020 s
wrote:
> Could someone please suggest the process to *sync the data from PROD DB
> to the Staging environment* with minimal manual intervention or
> automatically.
>
Read up on the general purpose "bash" scripting language, the PostgreSQL
"pg_dump"
Thanks, David,
Please find the environment details.
Environment:
PROD:
OS: RHEL 7.1
Postgres: 9.5.15
Staging:
OS: RHEL 7.1
Postgres: 9.5.15
Thanks&Regards,
PostgAnn.
On Wed, May 27, 2020 at 9:51 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, May 27, 2020 at 8:56 AM postga
Hi Team,
Thanks for your support.
Environment Details:
OS: RHEL 7.2
Postgres: 9.5.15
Master-Slave with Streaming replication
We are planning to implement the monitoring tool for our environment.
Could someone please suggest the Monitoring Tool based on your experience.
We are looking to cover
On Wed, May 27, 2020 at 10:15:49PM +0530, postgann2020 s wrote:
> Environment Details:
> OS: RHEL 7.2
> Postgres: 9.5.15
> Master-Slave with Streaming replication
>
> We are planning to implement the monitoring tool for our environment.
>
> Could someone please suggest the Monitoring Tool based on
On RDS (thus, no superuser) we are trying to drop a user. The only remaining
item that the user owns is an "empty" default permissions entry, but we can't
seem to get rid of it so that the user can be dropped:
I'm sure I'm missing something obvious!
Logged in as xyuser:
db=> \ddp+
On Wed, May 27, 2020 at 9:31 AM postgann2020 s
wrote:
> Thanks, David,
>
> Please find the environment details.
>
> Environment:
> PROD:
> OS: RHEL 7.1
> Postgres: 9.5.15
>
> Staging:
> OS: RHEL 7.1
> Postgres: 9.5.15
>
Ok...not particularly helpful though I do see you are not keeping up with
mi
You can try nagios
Sent from my iPhone
> On 27-May-2020, at 10:16 PM, postgann2020 s wrote:
>
>
> Hi Team,
>
> Thanks for your support.
>
> Environment Details:
> OS: RHEL 7.2
> Postgres: 9.5.15
> Master-Slave with Streaming replication
>
> We are planning to implement the monitoring tool
If possible you can connect staging server as asynchronous slave node to one of
the asynchronous node already in production
Sent from my iPhone
On 27-May-2020, at 9:26 PM, postgann2020 s wrote:
Hi Team,
Thanks for your support.
Could someone please suggest the process to sync the data from
Hi all,
I have a high traffic database, where I'm interested in changing the
wal segment size to a larger value. I haven't found much
documentation about how to change the segment size of an existing
database. The obvious, safe solution would be to create a new
database cluster and dump/reload.
On 5/27/20 10:06 AM, Christophe Pettus wrote:
On RDS (thus, no superuser) we are trying to drop a user. The only remaining item that
the user owns is an "empty" default permissions entry, but we can't seem to get
rid of it so that the user can be dropped:
I'm sure I'm missing something obviou
On 5/27/20 9:06 AM, postgann2020 s wrote:
Hi Team,
Thanks for your support.
Currently, we are using tomcat for scheduling and want to replace it
with DB specific schedulers.
Could someone please suggest the Schedular for application activities
instead of creating tomcat schedulers.
Also sc
Hi Marc,
You can sign content with pgsodium:
https://github.com/michelp/pgsodium
On Tue, May 26, 2020 at 12:21 PM Marc Munro wrote:
> On Tue, 2020-05-26 at 12:04 -0700, Adrian Klaver wrote:
> > On 5/26/20 12:01 PM, Marc Munro wrote:
> > > I need to be able to cryptographically sign objects in
As it's not well documented yet (sorry) I'm following up to add signing is
done with `crypto_sign()` and `crypto_sign_open()`
https://github.com/michelp/pgsodium/blob/master/test.sql#L73
On Wed, May 27, 2020 at 2:42 PM Michel Pelletier
wrote:
> Hi Marc,
>
> You can sign content with pgsodium:
>
Hi
I also suggest Nagios (for immediate monitoring) layered with OPM (longer term
and historical analysis), followed by PGBadger for stats snapshots (if your
logging format policy permits), and also PG_activity for the Operations team
(if security policies permit), the latter is great when hand
I've ran into a bit of a head scratching situation and was hoping that
someone with more knowledge that I could help me understand the
behaviour I'm seeing.
I'm running on PostgreSQL 12.2.
I have a SELECT query that returns different results depending on
whether statistics for the table have been
On Wed, May 27, 2020 at 8:09 PM James Brauman
wrote:
> -- Run select query (involving several CTEs).
> SELECT ...;
>
> I haven't generated a minimal test case yet, but I did notice that if
> all CTEs in the SELECT query are defined using AS NOT MATERIALIZED the
> results are always the same regar
Thanks for the help David, the query was missing a column in a
PARTITION BY expression.
On Thu, May 28, 2020 at 1:14 PM David G. Johnston
wrote:
>
> On Wed, May 27, 2020 at 8:09 PM James Brauman
> wrote:
>>
>> -- Run select query (involving several CTEs).
>> SELECT ...;
>>
>> I haven't generate
On Wed, 2020-05-27 at 10:06 -0700, Christophe Pettus wrote:
> On RDS (thus, no superuser) we are trying to drop a user. The only remaining
> item that the user owns is an "empty" default permissions entry, but we can't
> seem to get rid of it so that the user can
> be dropped:
>
> I'm sure I'm
26 matches
Mail list logo
