[Postgres-xl-developers] postgres-xl upgrage but pgadmin connection error

Pavan Deolasee pavan.deolasee at gmail.com
Mon Aug 1 00:44:48 PDT 2016


On Sun, Jul 31, 2016 at 7:33 AM, zoujb at primb.com <zoujb at primb.com> wrote:

>          Hi,
>          I have upgraded postgres-xl version to up-to-date XL9_5_STABLE
> from XL9_5_R1_1,no error when I connect to XL with psql,but I faced some
> errors when connect to XL with pgadmin Ⅲ 1.22.0.
>          Below are the errors:
>
> “ERROR:could not open relation with OID 0”
>
> “Column not found in pgSet:usecreatedb”
>
> “Column not found in pgSet:usesuper”
>
> “Column not found in pgSet:usesince”
>
> “Column not found in pgSet:confloadedsince”
>
> “Column not found in pgSet:inrecovery” ……
>
>           environment :
>
> OS:  CentOS 7
>
> DB Cluster Config:192.168.137.3--------1 gtm 、1 gtm proxy、1 coordinator、1
> datanode
>
>                                   192.168.137.4--------1 gtm standby 、1
> gtm proxy、1 coordinator、1 datanode
>
>            Here are my upgrade method:
>
> ./configure --prefix=/opt/pgxl         ###/opt/pgxl directory is also
> XL9_5_R1_1's installation directory.
>
> make world
>
> make install world
>
>
>
>            My question is:
>
> What causes the errors?Is it my upgrade method?
>
>
>
Can you please share all the steps you did during upgrade? How do you
stop/start various components? Can you share the logs on all the
datanode/coordinator servers?

Thanks,
Pavan

-- 
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20160801/f9055619/attachment.htm>


More information about the Postgres-xl-developers mailing list