Обсуждение: help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1

Поиск
Список
Период
Сортировка

help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1

От
Andy Hsu
Дата:
<div class="WordSection1"><p class="MsoNormal">We are currently using pgAdmin 3 v 1.10 to connect to Greenplum database
(4.3.7.1).We do not like the slowness on the connection attempts and are looking for replacement.<p
class="MsoNormal"> <pclass="MsoNormal">We found that pgAdmin 4 v 1.1 does not work for us because we failed to connect
todatabase with parameter error. <p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"Arial","sans-serif";color:#A94442;border:nonewindowtext
1.0pt;padding:0in;background:#F7F7F9">ERROR:unrecognized configuration parameter "bytea_output"</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""></span><p class="MsoNormal"> <p class="MsoNormal">If
theresomething we can set up local to ignore the error and continue to the login process?<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">Version is pgAdmin 4 v1.1<p class="MsoNormal">OS is Windows 7 64 bit<p
class="MsoNormal">OnDesktop<p class="MsoNormal">Server is RHEL 6 kernel 2.6.32-504.8.1.el6.x86_64<p
class="MsoNormal">Python2.6.2 on Greenplum database server (Linux)<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal"style="line-height:14.0pt;mso-line-height-rule:exactly"><b><span
style="font-size:12.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-US">Andy
Hsu</span></b></div><pre>******************************************************************************
This communication (including any attachments) may contain privileged or
confidential information intended for a specific individual and purpose,
and is protected by law.  If you are not the intended recipient, you should
delete this communication and/or shred the materials and any attachments and
are hereby notified that any disclosure, copying, or distribution of this
communication, or the taking of any action based on it, is strictly prohibited.

Thank you.
</pre>

Re: help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1

От
Dave Page
Дата:
On Wed, Nov 16, 2016 at 11:35 PM, Andy Hsu <Andy.Hsu@unionbank.com> wrote:
> We are currently using pgAdmin 3 v 1.10 to connect to Greenplum database
> (4.3.7.1). We do not like the slowness on the connection attempts and are
> looking for replacement.
>
>
>
> We found that pgAdmin 4 v 1.1 does not work for us because we failed to
> connect to database with parameter error.
>
> ERROR: unrecognized configuration parameter "bytea_output"
>
>
>
> If there something we can set up local to ignore the error and continue to
> the login process?

Greenplum is not currently supported I'm afraid.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



Re: help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1

От
Sathesh S
Дата:

I don't think there any workarounds for this.
FYIP.., Greenplum support is looking in to this connection issue.

Thanks,
Sathesh



On Thu, Nov 17, 2016 at 2:34 PM +0530, "Dave Page" <dpage@pgadmin.org> wrote:

On Wed, Nov 16, 2016 at 11:35 PM, Andy Hsu <Andy.Hsu@unionbank.com> wrote:
> We are currently using pgAdmin 3 v 1.10 to connect to Greenplum database
> (4.3.7.1). We do not like the slowness on the connection attempts and are
> looking for replacement.
>
>
>
> We found that pgAdmin 4 v 1.1 does not work for us because we failed to
> connect to database with parameter error.
>
> ERROR: unrecognized configuration parameter "bytea_output"
>
>
>
> If there something we can set up local to ignore the error and continue to
> the login process?

Greenplum is not currently supported I'm afraid.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1

От
Andy Hsu
Дата:

Sathesh,

 

Can an option provided to user to ignore the error returned during setting parameters and continue to the next step?

 

We will test gpAdmin 3 v1.22 for now.

 

Andy

 

From: Sathesh S [mailto:sathesh.sundaram@hotmail.com]
Sent: Thursday, November 17, 2016 1:54 AM
To: Dave Page; Andy Hsu
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1

 

I don't think there any workarounds for this.
FYIP.., Greenplum support is looking in to this connection issue.

Thanks,
Sathesh



On Thu, Nov 17, 2016 at 2:34 PM +0530, "Dave Page" <dpage@pgadmin.org> wrote:

On Wed, Nov 16, 2016 at 11:35 PM, Andy Hsu <Andy.Hsu@unionbank.com> wrote:
> We are currently using pgAdmin 3 v 1.10 to connect to Greenplum database
> (4.3.7.1). We do not like the slowness on the connection attempts and are
> looking for replacement.
>
>
>
> We found that pgAdmin 4 v 1.1 does not work for us because we failed to
> connect to database with parameter error.
>
> ERROR: unrecognized configuration parameter "bytea_output"
>
>
>
> If there something we can set up local to ignore the error and continue to
> the login process?

Greenplum is not currently supported I'm afraid.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

******************************************************************************
This communication (including any attachments) may contain privileged or
confidential information intended for a specific individual and purpose, 
and is protected by law.  If you are not the intended recipient, you should
delete this communication and/or shred the materials and any attachments and
are hereby notified that any disclosure, copying, or distribution of this
communication, or the taking of any action based on it, is strictly prohibited.

Thank you.

Re: help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1

От
Sathesh S
Дата:

Hi Andy,

I'm not sure about the option. Dave would be the best person to suggest on this.

What I expect is, Greenplum support will roll out a fix for this in future Greenplum releases.

Thanks,
Sathesh



On Thu, Nov 17, 2016 at 8:19 PM +0530, "Andy Hsu" <Andy.Hsu@unionbank.com> wrote:

Sathesh,

 

Can an option provided to user to ignore the error returned during setting parameters and continue to the next step?

 

We will test gpAdmin 3 v1.22 for now.

 

Andy

 

From: Sathesh S [mailto:sathesh.sundaram@hotmail.com]
Sent: Thursday, November 17, 2016 1:54 AM
To: Dave Page; Andy Hsu
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1

 

I don't think there any workarounds for this.
FYIP.., Greenplum support is looking in to this connection issue.

Thanks,
Sathesh



On Thu, Nov 17, 2016 at 2:34 PM +0530, "Dave Page" <dpage@pgadmin.org> wrote:

On Wed, Nov 16, 2016 at 11:35 PM, Andy Hsu <Andy.Hsu@unionbank.com> wrote:
> We are currently using pgAdmin 3 v 1.10 to connect to Greenplum database
> (4.3.7.1). We do not like the slowness on the connection attempts and are
> looking for replacement.
>
>
>
> We found that pgAdmin 4 v 1.1 does not work for us because we failed to
> connect to database with parameter error.
>
> ERROR: unrecognized configuration parameter "bytea_output"
>
>
>
> If there something we can set up local to ignore the error and continue to
> the login process?

Greenplum is not currently supported I'm afraid.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

******************************************************************************
This communication (including any attachments) may contain privileged or
confidential information intended for a specific individual and purpose, 
and is protected by law.  If you are not the intended recipient, you should
delete this communication and/or shred the materials and any attachments and
are hereby notified that any disclosure, copying, or distribution of this
communication, or the taking of any action based on it, is strictly prohibited.

Thank you.