Re: Writing WAL files

On Sunday, October 4, 2020, Robert Inder wrote: > than shipping an empty file every few minutes? > The file is not empty. We’re talking 16 megabytes in a default setup... David J.

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

On 2/10/20 2:08 π.μ., tutilu...@tutanota.com wrote: On Thu, Sep 24, 2020 at 10:40 PM mailto:tutilu...@tutanota.com>> wrote: Well not partial as in incremental. Instead dump only some portion of the schema with or without its associated data. It's funny tha

Re: Can't query system tables during transaction

Hi, On Sun, Oct 4, 2020 at 3:30 PM Tom Lane wrote: > > Igor Korot writes: > > I'm trying to execute following: > > > SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace > > AND c.relname = 'foo' AND n.nspname = public; > > I suppose you meant to put quotes around 'public'? I s

Re: Can't query system tables during transaction

Igor Korot writes: > I'm trying to execute following: > SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace > AND c.relname = 'foo' AND n.nspname = public; I suppose you meant to put quotes around 'public'? > I'm getting the following error: > ERROR: current transaction is ab

Re: Can't query system tables during transaction

On 10/4/20 1:14 PM, Igor Korot wrote: Hi, ALL, I'm trying to execute following: SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND c.relname = 'foo' AND n.nspname = public; inside the transaction. I'm getting the following error: ERROR: current transaction is aborted,

Can't query system tables during transaction

Hi, ALL, I'm trying to execute following: SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND c.relname = 'foo' AND n.nspname = public; inside the transaction. I'm getting the following error: ERROR: current transaction is aborted, commands ignored until end of transactio

Re: Writing WAL files

On Sun, 4 Oct 2020 at 20:52, Alvaro Herrera wrote: > > This is on purpose; archiving WAL files that contain nothing is pure > wastage of good electrons. Seriously? Oh, holy > I suggest that in PG12 you can monitor the > "lag" of a standby server more directly by looking at columns write_

Re: Writing WAL files

Hello Robert On 2020-Oct-04, Robert Inder wrote: > One of the things I like about the old PGSQL 9 setup is that it generates > and ships a WAL file every few minutes, even if nothing has happened in the > database. > I find it re-assuring to be able to see WAL files arriving and being > processed

Re: Writing WAL files

On 10/4/20 10:30 AM, Robert Inder wrote: On Sun, 4 Oct 2020 at 18:01, Adrian Klaver > wrote: On 10/4/20 9:54 AM, Robert Inder wrote: > I am moving a database from PSQL 9 (!) on CentOS 6 to PSQL 12 on CentOS 7 It would help to know what the x

Re: Writing WAL files

On 10/4/20 10:30 AM, Robert Inder wrote: On Sun, 4 Oct 2020 at 18:01, Adrian Klaver > wrote: On 10/4/20 9:54 AM, Robert Inder wrote: > I am moving a database from PSQL 9 (!) on CentOS 6 to PSQL 12 on CentOS 7 It would help to know what the x

Re: Writing WAL files

On Sun, 4 Oct 2020 at 18:01, Adrian Klaver wrote: > On 10/4/20 9:54 AM, Robert Inder wrote: > > I am moving a database from PSQL 9 (!) on CentOS 6 to PSQL 12 on CentOS 7 > > It would help to know what the x in 9.x is? Before version 10 of > Postgres, the second number denoted a major version. >

Re: Writing WAL files

On 10/4/20 9:54 AM, Robert Inder wrote: I am moving a database from PSQL 9 (!) on CentOS 6 to PSQL 12 on CentOS 7 It would help to know what the x in 9.x is? Before version 10 of Postgres, the second number denoted a major version. I have a pair of servers -- one live, one standby. The liv

Writing WAL files

I am moving a database from PSQL 9 (!) on CentOS 6 to PSQL 12 on CentOS 7 I have a pair of servers -- one live, one standby. The live server defines an archive_command as "rsync" to shift WAL files to the standby server, The standby server uses "pg_standby" to monitor and process incoming WAL