Re: SELECT query results are different depending on whether table statistics are available.

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

Re: SELECT query results are different depending on whether table statistics are available.

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

SELECT query results are different depending on whether table statistics are available.

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

Re: Suggestion to Monitoring Tool

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

Re: GPG signing

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:

Re: GPG signing

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

Re: Suggest the Schedular for activities

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

Re: Can't remove default permissions entry

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

Changing wal segment size on existing database cluster

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.

Re: suggestion the process to sync the data from PROD DB to Staging environment

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

Re: Suggestion to Monitoring Tool

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

Re: suggestion the process to sync the data from PROD DB to Staging environment

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

Can't remove default permissions entry

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+

Re: Suggestion to Monitoring Tool

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

Suggestion to Monitoring Tool

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

Re: suggestion the process to sync the data from PROD DB to Staging environment

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, 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 postgann2020

Re: suggestion the process to sync the data from PROD DB to Staging environment

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"

Re: Install PostgreSQL on windows 10 home 64-bit machine

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

Re: suggestion the process to sync the data from PROD DB to Staging environment

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

Suggest the Schedular for activities

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

Re: suggestion the process to sync the data from PROD DB to Staging environment

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

suggestion the process to sync the data from PROD DB to Staging environment

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.

Re: Install PostgreSQL on windows 10 home 64-bit machine

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

Re: pg_basebackup + delta base backups

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).

Install PostgreSQL on windows 10 home 64-bit machine

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