pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgrade not excluding system tables in EPAS
4+ messages / 3 participants
[nested] [flat]
* pg_upgrade not excluding system tables in EPAS
@ 2021-05-14 19:37 Tim <timfosho@gmail.com>
2021-05-14 19:47 ` Re: pg_upgrade not excluding system tables in EPAS Tom Lane <tgl@sss.pgh.pa.us>
2021-05-14 20:03 ` Re: pg_upgrade not excluding system tables in EPAS Bruce Momjian <bruce@momjian.us>
0 siblings, 2 replies; 4+ messages in thread
From: Tim @ 2021-05-14 19:37 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello Gentlemen,
I am currently performing an upgrade of EPAS12 => EPAS13 via pg_upgrade...
which I've done on a few clusters already with no issues, but this most
recent run has me running into a problem.
It fails the check with this message:
- fatal
- Your installation contains system-defined composite type(s) in user
tables.
And the output shows that it thinks sys.callback_queue_table.user_data is a
user defined table. Which it is not, and cannot be dropped or altered. As I
understand it should be excluding the sys schema that EPAS has. But for
some reason it is not?
I've checked all the system settings I can find, and can't figure why now
it is having this issue. Am I missing something? Is there a way to define
the system tables somewhere in postgres?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_upgrade not excluding system tables in EPAS
2021-05-14 19:37 pg_upgrade not excluding system tables in EPAS Tim <timfosho@gmail.com>
@ 2021-05-14 19:47 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 2021-05-14 19:47 UTC (permalink / raw)
To: Tim <timfosho@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Tim <timfosho@gmail.com> writes:
> I am currently performing an upgrade of EPAS12 => EPAS13 via pg_upgrade...
You really ought to be discussing this with EDB Support, not here.
> It fails the check with this message:
> - Your installation contains system-defined composite type(s) in user
> tables.
Hmm. That is a new check in 13.3 ...
> And the output shows that it thinks sys.callback_queue_table.user_data is a
> user defined table. Which it is not, and cannot be dropped or altered.
... and I'm not sure what user_data is, but it's not present in community
Postgres. My guess as to what is happening here is that that pg_upgrade
test needs to be tweaked to understand which of the types that EPAS adds
are safe or not safe in this context. Anyway, you gotta talk to them.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_upgrade not excluding system tables in EPAS
2021-05-14 19:37 pg_upgrade not excluding system tables in EPAS Tim <timfosho@gmail.com>
@ 2021-05-14 20:03 ` Bruce Momjian <bruce@momjian.us>
2021-05-14 20:14 ` Re: pg_upgrade not excluding system tables in EPAS Tim <timfosho@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2021-05-14 20:03 UTC (permalink / raw)
To: Tim <timfosho@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Fri, May 14, 2021 at 03:37:18PM -0400, Tim wrote:
> Hello Gentlemen,
>
> I am currently performing an upgrade of EPAS12 => EPAS13 via pg_upgrade...
> which I've done on a few clusters already with no issues, but this most recent
> run has me running into a problem.
>
> It fails the check with this message:
>
> • fatal
> • Your installation contains system-defined composite type(s) in user tables.
>
> And the output shows that it thinks sys.callback_queue_table.user_data is a
> user defined table. Which it is not, and cannot be dropped or altered. As I
> understand it should be excluding the sys schema that EPAS has. But for some
> reason it is not?
>
> I've checked all the system settings I can find, and can't figure why now it is
> having this issue. Am I missing something? Is there a way to define the system
> tables somewhere in postgres?
As far as community Postgres is concerned,
sys.callback_queue_table.user_data is not part of the community
distribution. You need to ask EDB about this.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_upgrade not excluding system tables in EPAS
2021-05-14 19:37 pg_upgrade not excluding system tables in EPAS Tim <timfosho@gmail.com>
2021-05-14 20:03 ` Re: pg_upgrade not excluding system tables in EPAS Bruce Momjian <bruce@momjian.us>
@ 2021-05-14 20:14 ` Tim <timfosho@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Tim @ 2021-05-14 20:14 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin@lists.postgresql.org
Thanks for the quick response!
Yes that seems to be definitely it, didn't realize 13.3 was literally
released yesterday. I will follow up with the EDB regarding getting this
bug resolved.
On Fri, May 14, 2021 at 4:03 PM Bruce Momjian <bruce@momjian.us> wrote:
> On Fri, May 14, 2021 at 03:37:18PM -0400, Tim wrote:
> > Hello Gentlemen,
> >
> > I am currently performing an upgrade of EPAS12 => EPAS13 via
> pg_upgrade...
> > which I've done on a few clusters already with no issues, but this most
> recent
> > run has me running into a problem.
> >
> > It fails the check with this message:
> >
> > • fatal
> > • Your installation contains system-defined composite type(s) in user
> tables.
> >
> > And the output shows that it thinks sys.callback_queue_table.user_data
> is a
> > user defined table. Which it is not, and cannot be dropped or altered.
> As I
> > understand it should be excluding the sys schema that EPAS has. But for
> some
> > reason it is not?
> >
> > I've checked all the system settings I can find, and can't figure why
> now it is
> > having this issue. Am I missing something? Is there a way to define the
> system
> > tables somewhere in postgres?
>
> As far as community Postgres is concerned,
> sys.callback_queue_table.user_data is not part of the community
> distribution. You need to ask EDB about this.
>
> --
> Bruce Momjian <bruce@momjian.us> https://momjian.us
> EDB https://enterprisedb.com
>
> If only the physical world exists, free will is an illusion.
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-05-14 20:14 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-05-14 19:37 pg_upgrade not excluding system tables in EPAS Tim <timfosho@gmail.com>
2021-05-14 19:47 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-05-14 20:03 ` Bruce Momjian <bruce@momjian.us>
2021-05-14 20:14 ` Tim <timfosho@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox