Re: How different is AWS-RDS postgres?

> On May 26, 2021, at 4:37 PM, Ian Harding wrote: > >  > There is an option to send the logs to cloudwatch which makes it less awful > to look at them. I have that but precious little of interest there. Lots of autovac, a smattering of hints to increase wal size!? I have yet to spot anythi

Re: How different is AWS-RDS postgres?

There is an option to send the logs to cloudwatch which makes it less awful to look at them. On Wed, May 26, 2021, 11:52 AM Ron wrote: > On 5/26/21 1:24 PM, Rob Sargent wrote: > > > My question is: > Should I be surprised that the initial bulk loaded table is nowhere to be > seen, given the thum

Re: Setting up replication

That is helpful, thanks Vijay. I will wade in and give it a go. For some reason I had it in my head that it was a good idea to run pg_basebackup frequently, e.g. once a day, but it looks like it's only necessary once for the initial transfer to the replica. Oliver On Wed, 26 May 2021 at 20:37, V

Re: Setting up replication

core ref: PostgreSQL: Documentation: 13: Part III. Server Administration although this is a lot verbose, but you would keep coming back to this to tune your setup. to understand basic setups. some are How to Set Up Streaming Replication in PostgreSQ

Re: How different is AWS-RDS postgres?

On 5/26/21 1:24 PM, Rob Sargent wrote: My question is: Should I be surprised that the initial bulk loaded table is nowhere to be seen, given the thumbs up from the logs?  Is this frailty inherent in AWS/RDS infrastructure? Since this is an academic exorcise, I have minimal AWS support, whic

Re: How different is AWS-RDS postgres?

My question is: Should I be surprised that the initial bulk loaded table is nowhere to be seen, given the thumbs up from the logs?  Is this frailty inherent in AWS/RDS infrastructure? Since this is an academic exorcise, I have minimal AWS support, which has yet to chime in on this matter. M

Re: How different is AWS-RDS postgres?

On 5/26/21 12:50 PM, Rob Sargent wrote: I have what purports to be Postgres 12 ( PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit ) running on RDS.  I testing a new release of my service with an admittedly large data set (which may be my sw

Setting up replication

Hi, We currently have an app with the database on the same server as the app itself. I'd like to transition to a system where 1) in the short term, the db replicates to a different server. This will allow us to take the daily pg_dump backups from the replica rather than the primary server. They'r

How different is AWS-RDS postgres?

I have what purports to be Postgres 12 ( PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit ) running on RDS.  I testing a new release of my service with an admittedly large data set (which may be my swamping AWS bandwidth).  But my app logs

Re: An exception about comparison operators

On Wed, 2021-05-26 at 17:15 +0800, 张元超 wrote: > I encountered a problem when using PostgreSQL's comparison operators. The > problem is as follows: > Problem Description: > When I use the comparison operator "!=" as the query condition, such as > "select * from t1 where c1 !=-1", the database retu

An exception about comparison operators

Hi，everyone, I encountered a problem when using PostgreSQL's comparison operators. The problem is as follows: Problem Description: When I use the comparison operator "!=" as the query condition, such as "select * from t1 where c1 !=-1", the database returns an error: "!=-operator does not exist"

Re: Null database entry in pg_stat_database on pg-12 version

On Wed, May 26, 2021 at 9:20 AM RAJAMOHAN wrote: > > Hello all, > > Today I came across this null database entry with oid as 0 in > pg_stat_database on postgresql-12 version. > > Any particular use case is there for this? It also has some column values, > how it is gathering those data and whic

Null database entry in pg_stat_database on pg-12 version

Hello all, Today I came across this null database entry with oid as 0 in *pg_stat_database* on *postgresql-12* version. Any particular use case is there for this? It also has some column values, how it is gathering those data and which database is responsible for this? I am not seeing this in t