[pgadmin-support] bug of import data into table in pgadminIII 1.20.0

[YuanyuanLiu]

Hello!

I think I find a bug of import in pgadmin III 1.20.0 . 
OS: win10
version: pgadminIII 1.20.0 (I intall it by an Graphical installer)

I set my pgadminIII in Chinese, then I use Import.
it failed:

 

And I view pgadmin's log :
2016-03-09 16:52:25 QUERY  : Query result: 
2016-03-09 16:52:33 QUERY  : COPY query (localhost:5432): COPY
public.pg_audit_trail_logs FROM STDIN (FORMAT '文本')
2016-03-09 16:52:33 ERROR  : 错误:  没有识别COPY命令的格式"文本"
2016-03-09 16:52:34 ERROR  : no COPY in progress

I find the format name in copy statement is wrong. Then I change
the language of pgadmin into English, then it successed.
 
and the log is：
2016-03-09 17:04:43 QUERY  : COPY query (localhost:5432): COPY
public.pg_audit_trail_logs FROM STDIN (FORMAT 'text')

I think it maybe a bug, and I don't know whether it has been fixed.
So I send this to you, please have a look!
Thanks and regards!

Holiday Liu 











--
View this message in context: 
http://postgresql.nabble.com/bug-of-import-data-into-table-in-pgadminIII-1-20-0-tp5891518.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


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

Re: [pgadmin-support] How to setup Active Directory users in Postgres 9.3.11

[Raymond O'Donnell]

On 08/03/2016 17:56, Wyatt Sanford wrote:
> Hi,
> 
>  
> 
> I have recently been tasked with installing Postgres 9.3.11 on a Windows
> 2012 R2 server on Active Directory and restoring backups from a Linux
> server running Postgres 9.3.11.  I have all of the databases restored to
> the windows server and now I need to set up access for users on Active
> Directory.  I’ve read a few things online, but did not find any good

Hi there,

You'd be better off asking on the pgsql-general mailing list. This one
is dedicated to PgAdmin, the PostgreSQL administration tool.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie


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

[pgadmin-support] pgAdmin install on mac - does not work

[Shailesh Doshi]

Hello


Trying to get pgAdmin3 installed  on my mac (16G i7 4 core CPU,  OSX
10.11). I have tried 1.20 and 1.22 and 1.22.1
When I try to install, it goes up to a point of showing me the pgAdmin elephant
but then my CPU shoots up to 100% and stays there.
There is background window that opens up
/usr/local/greenplum-clients-4.3.5.1-buid1 pops up when I click on the
pgAdmin screen icon.

I had nothing else running (activity monitor would show 100% CPU 4 threads).
Online research did not yield anything. Another colleague of mine has exact
same issue.

Thanks in advance.

Re: [pgadmin-support] pgAdmin install on mac - does not work

[Dave Page]

On Wed, Mar 9, 2016 at 12:07 PM, Shailesh Doshi  wrote:
> Hello
>
>
> Trying to get pgAdmin3 installed  on my mac (16G i7 4 core CPU,  OSX 10.11).
> I have tried 1.20 and 1.22 and 1.22.1
> When I try to install, it goes up to a point of showing me the pgAdmin
> elephant but then my CPU shoots up to 100% and stays there.
> There is background window that opens up
> /usr/local/greenplum-clients-4.3.5.1-buid1 pops up when I click on the
> pgAdmin screen icon.
>
> I had nothing else running (activity monitor would show 100% CPU 4 threads).
> Online research did not yield anything. Another colleague of mine has exact
> same issue.

Hi

If you move the Greenplum clients directory out of the way
temporarily, does that resolve the issue?


-- 
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: [pgadmin-support] pgAdmin install on mac - does not work

[Shailesh Doshi]

Bingo.  Removing the client directory fixed the issue.
Thanks a bunch Dave.



On Wed, Mar 9, 2016 at 8:03 AM, Dave Page  wrote:

> On Wed, Mar 9, 2016 at 12:07 PM, Shailesh Doshi  wrote:
> > Hello
> >
> >
> > Trying to get pgAdmin3 installed  on my mac (16G i7 4 core CPU,  OSX
> 10.11).
> > I have tried 1.20 and 1.22 and 1.22.1
> > When I try to install, it goes up to a point of showing me the pgAdmin
> > elephant but then my CPU shoots up to 100% and stays there.
> > There is background window that opens up
> > /usr/local/greenplum-clients-4.3.5.1-buid1 pops up when I click on the
> > pgAdmin screen icon.
> >
> > I had nothing else running (activity monitor would show 100% CPU 4
> threads).
> > Online research did not yield anything. Another colleague of mine has
> exact
> > same issue.
>
> Hi
>
> If you move the Greenplum clients directory out of the way
> temporarily, does that resolve the issue?
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



-- 
*Shailesh Doshi | Data Engineering | Pivotal*
*Mobile: 513-604-9746 **| Email **: **sdo...@pivotal.io*

Big Data - Scale out & Open Source

Re: [pgadmin-support] How to setup Active Directory users in Postgres 9.3.11

[Wyatt Sanford]

Thanks,

I'll do that.

Wyatt Sanford
Database Administrator

-Original Message-
From: Raymond O'Donnell [mailto:r...@iol.ie]
Sent: Wednesday, March 09, 2016 4:54 AM
To: Wyatt Sanford; 'pgadmin-support@postgresql.org'
Subject: Re: [pgadmin-support] How to setup Active Directory users in Postgres 
9.3.11

On 08/03/2016 17:56, Wyatt Sanford wrote:
> Hi,
>
>
>
> I have recently been tasked with installing Postgres 9.3.11 on a
> Windows
> 2012 R2 server on Active Directory and restoring backups from a Linux
> server running Postgres 9.3.11.  I have all of the databases restored
> to the windows server and now I need to set up access for users on
> Active Directory.  I've read a few things online, but did not find any
> good

Hi there,

You'd be better off asking on the pgsql-general mailing list. This one is 
dedicated to PgAdmin, the PostgreSQL administration tool.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie


DISCLAIMER : This e-mail transmission is intended for the use of the individual 
or entity addressed and may contain protected confidential information. If you 
are not the intended recipient or the employee or agent responsible for 
delivering the transmission to the intended recipient, any dissemination, 
forwarding, printing, distribution, copying or use of this transmission is 
strictly prohibited. If you have received this transmission in error, please 
notify the sender and delete this transmission.


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