Re: [GENERAL] pg_upgrade & tablespaces

2013-12-26 Thread Joseph Kregloh
As suggested I did a couple more experiments. This time I installed Postgres 9.0 in it's defauls location. I then installed Postgres 9.3 in /opt. Tested that both version booted up and ran independently of each other. First test, Postgres 9.0 just after an initdb, so it's all clean. It completed s

[GENERAL] pgbench and GP

2013-12-26 Thread GR Vishwanath
I am very eager to test our GP4.2/PG 8.2 with pgworkbench. Is it simply (??) a matter of running the test against all the individual segments, or maybe an individual representative segment (aka PG instance)? Thanks GR

Re: [GENERAL] pg_upgrade & tablespaces

2013-12-26 Thread Adrian Klaver
On 12/26/2013 08:31 AM, Joseph Kregloh wrote: As suggested I did a couple more experiments. This time I installed Postgres 9.0 in it's defauls location. I then installed Postgres 9.3 in /opt. Tested that both version booted up and ran independently of each other. First test, Postgres 9.0 just af

Re: [GENERAL] pg_upgrade & tablespaces

2013-12-26 Thread Joseph Kregloh
> > Here is the message on --hackers that explains the above: > > http://www.postgresql.org/message-id/20130214052952.ga10...@momjian.us > > Let me read into this. > > >> While the upgrade was successful, I find it unusable and leaving me with >> a lot of manual labor ahead of me. Because it leav

Re: [GENERAL] FATAL: index contains unexpected zero page at block

2013-12-26 Thread Sergey Konoplev
On Mon, Dec 23, 2013 at 7:48 AM, wrote: > WARNING: page 1 of relation base/37706/11821 is uninitialized > CONTEXT: xlog redo vacuum: rel 1663/37706/11821; blk 2, lastBlockVacuumed > 0 > PANIC: WAL contains references to invalid pages > CONTEXT: xlog redo vacuum: rel 1663/37706/11821;

[GENERAL] postgresql-common breaks logrotate

2013-12-26 Thread Steve Crawford
People who have attempted to install PGDG versions of PostgreSQL on recent Ubuntu releases have run into the cascading problem of postgresql wanting to destroy Ubuntu. Based on the packaging: postgresql depends on postgresql-common postgresql-common breaks logrotate (>3.8) ubuntu-standard depen

Re: [GENERAL] pg_upgrade & tablespaces

2013-12-26 Thread Adrian Klaver
On 12/26/2013 01:06 PM, Joseph Kregloh wrote: Here is the message on --hackers that explains the above: http://www.postgresql.org/__message-id/20130214052952.__ga10...@momjian.us Let me read into this. No