Re: [GENERAL] Old pg_clog files

2017-10-29 Thread Ron Johnson
On 10/29/2017 03:37 PM, David G. Johnston wrote: On Sunday, October 29, 2017, Ron Johnson > wrote: Hi, v8.4.17 http://www.postgresql-archive.org/pg-clog-questions-td2080911.html

Re: [GENERAL] Old pg_clog files

2017-10-29 Thread David G. Johnston
On Sunday, October 29, 2017, Ron Johnson wrote: > Hi, > > v8.4.17 > > http://www.postgresql-archive.org/pg-clog-questions-td2080911.html > > According to this old thread, doing a VACUUM on every table in the > postgres, template1 and TAPd databases should remove old pg_clog files. > > > However,

[GENERAL] Old pg_clog files

2017-10-29 Thread Ron Johnson
Hi, v8.4.17 http://www.postgresql-archive.org/pg-clog-questions-td2080911.html According to this old thread,  doing a VACUUM on every table in the postgres, template1 and TAPd databases should remove old pg_clog files. postgres=# SELECT datname, age(datfrozenxid) FROM pg_database;   datname 

[GENERAL] Fwd: SPI_palloc problem

2017-10-29 Thread Aron Widforss
I mailed this from my main email address instead of the one I'm subscribed to pgsql-general with. So, here goes. - Original message - From: Aron Widforss To: pgsql-general@postgresql.org Subject: SPI_palloc problem Date: Sun, 29 Oct 2017 19:35:30 +0100 Good evening, I'm really new to Po