Re: [pgadmin-support] pgAdmin 4: "PostgreSQL Binary Path"?

[Thomas Landauer]

Hi Dave,

thanks!!

I think I've discovered a bug:
I started the restore, and since then I have this message in the lower 
right corner of the screen (see attached screenshot). I've already 
restarted the computer twice, but the timer still keeps counting.


The restore did create 24 of my 30+ tables, but didn't enter any data yet.
The entire .backup-file is less than 1 MB - so that's nothing that could 
take 20.000 seconds ;-)



About the initial question:
I was thinking I was supposed to enter a single .exe-file, not an entire 
directory. So if it's not possible to figure it out automatically (like 
pgAdmin 3 did), please rephrase the label of the field from "PostgreSQL 
Binary Path" to "Directory containing the PostgreSQL binaries".


Thanks!

Thomas

Am 06.09.2016 um 12:49 schrieb Dave Page:

On Tue, Sep 6, 2016 at 11:39 AM, Thomas Landauer  wrote:

Hi,

which binary (on Windows) is supposed to go in the field "Paths > Binary
paths > PostgreSQL Binary Path"?


Details:
I have PostgreSQL 9.6 RC 1 (i.e. pgAdmin 4 1.0-rc1), downloaded from
http://www.enterprisedb.com/products-services-training/pgdownload#windows
running on Windows 10 x64.

And when I'm trying to restore a database backup, I get the error message
"Please configure the PostgreSQL Binary Path in the Preferences dialog."


The directory containing the pg_dump/pg_restore/pg_dumpall that you
want to use (it's the same as in pgAdmin 3).


-- 
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 4: "PostgreSQL Binary Path"?

[Dave Page]

On Tue, Sep 6, 2016 at 11:39 AM, Thomas Landauer  wrote:
> Hi,
>
> which binary (on Windows) is supposed to go in the field "Paths > Binary
> paths > PostgreSQL Binary Path"?
>
>
> Details:
> I have PostgreSQL 9.6 RC 1 (i.e. pgAdmin 4 1.0-rc1), downloaded from
> http://www.enterprisedb.com/products-services-training/pgdownload#windows
> running on Windows 10 x64.
>
> And when I'm trying to restore a database backup, I get the error message
> "Please configure the PostgreSQL Binary Path in the Preferences dialog."

The directory containing the pg_dump/pg_restore/pg_dumpall that you
want to use (it's the same as in pgAdmin 3).

-- 
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] pgadmin4 rc1 query tool performance

[Dave Page]

On Tue, Sep 6, 2016 at 11:41 AM, Michal Kozusznik
 wrote:
> On 6.9.2016 11:51, Dave Page wrote:
>>
>> On Tue, Sep 6, 2016 at 10:47 AM, Attila Soki  wrote:
>>>
>>> Hi,
>>>
>>> i testing pgadmin4 (rc1) and noticed that the query tool is significantly
>>> slower than the query tool in pgadmin3.
>>> i am not sure if this occurs only on my computer or only under os x
>>> (10.10.5) or is this a known behavior.
>>
>> It's a natural consequence of it being a web application.
>
>
> Indeed It is, but not to the extent shown by OP.
> Or in other words, it should be considered as show stopper for tool like
> pgAdmin.
>
> I really cannot imaging daily work with such slow tool. I still hope in
> significant improvement in this area.

Patches are welcome.

-- 
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] pgadmin4 rc1 query tool performance

[Michal Kozusznik]

On 6.9.2016 11:51, Dave Page wrote:

On Tue, Sep 6, 2016 at 10:47 AM, Attila Soki  wrote:

Hi,

i testing pgadmin4 (rc1) and noticed that the query tool is significantly 
slower than the query tool in pgadmin3.
i am not sure if this occurs only on my computer or only under os x (10.10.5) 
or is this a known behavior.

It's a natural consequence of it being a web application.


Indeed It is, but not to the extent shown by OP.
Or in other words, it should be considered as show stopper for tool like 
pgAdmin.


I really cannot imaging daily work with such slow tool. I still hope in 
significant improvement in this area.


MK

<>
-- 
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 4: "PostgreSQL Binary Path"?

[Thomas Landauer]

Hi,

which binary (on Windows) is supposed to go in the field "Paths > Binary 
paths > PostgreSQL Binary Path"?



Details:
I have PostgreSQL 9.6 RC 1 (i.e. pgAdmin 4 1.0-rc1), downloaded from 
http://www.enterprisedb.com/products-services-training/pgdownload#windows 
running on Windows 10 x64.


And when I'm trying to restore a database backup, I get the error 
message "Please configure the PostgreSQL Binary Path in the Preferences 
dialog."


Thanks!!


Cheers,
Thomas


--
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] pgadmin4 rc1 query tool performance

[Dave Page]

On Tue, Sep 6, 2016 at 10:47 AM, Attila Soki  wrote:
> Hi,
>
> i testing pgadmin4 (rc1) and noticed that the query tool is significantly 
> slower than the query tool in pgadmin3.
> i am not sure if this occurs only on my computer or only under os x (10.10.5) 
> or is this a known behavior.

It's a natural consequence of it being a web application.


-- 
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

[pgadmin-support] pgadmin4 rc1 query tool performance

[Attila Soki]

Hi,

i testing pgadmin4 (rc1) and noticed that the query tool is significantly 
slower than the query tool in pgadmin3.
i am not sure if this occurs only on my computer or only under os x (10.10.5) 
or is this a known behavior.


how to repeat:
create table test1 (a int, t text);
insert into test1 (select generate_series(0,25000,1),'Lorem ipsum');

create table test2 (a int, t text);
insert into test2 (select generate_series(0,25000,1),'Lorem ipsum dolor sit 
amet, consectetur adipiscing elit. Praesent sit amet auctor lectus. Nulla 
condimentum maximus mauris, ac mattis leo blandit eget.');


select * from test1;
pgadmin3: Total query runtime: 518 msec
25001 rows retrieved.

pgadmin4 1.0 rc1:
Total query runtime: 2 secs.
25001 rows retrieved.

select * from test2;
pgadmin3:
Total query runtime: 2.8 secs
25001 rows retrieved

pgadmin4 1.0 rc1:
Total query runtime: 14 secs.
25001 rows retrieved.

client: os x 10.10.5
server: debian jessie in vmware, pg9.6-rc1

(sorry for crossposting, i send this e-mail accidentally to pgsql-generat first)

thanks,

Attila



-- 
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] pgAdmin4 1.0-RC1 - Cannot remove nor change length definition on column in "The Table Dialog"

[Dave Page]

Thanks - logged here: https://redmine.postgresql.org/issues/1669

On Tue, Sep 6, 2016 at 2:39 AM, Jan Rössler  wrote:
> Hello,
>
> it currently seems to be impossible to change or remove "length" from a
> column's definition.
>
> How to reproduce:
> 1. CREATE TABLE test(string character varying(1));
> 2. In sidebar, right click on "test" table and select "Properties"
> 3. Select "Columns"
> 4. Press the edit icon on column "string"
> 5. Go to the "Definition" tab
> 6. Delete the "Length" value
> 7. Press "Save" button
>
> The inline value of length will change by itself to NaN and an error message
> saying "can't execute an empty query" is returned when trying to save. When
> I try to delete the length value inline, same error message is also returned
> upon save. Meanwhile the SQL tab only shows "--modified SQL", instead of the
> needed ALTER statement.
>
> When I want to just edit the length to a different value, it doesn't work
> either. In this case some SQL does get generated, but it is not a valid
> statement (at least not on version 9.3).
> The error message is: ERROR: syntax error at or near "," LINE 2: ALTER
> COLUMN string TYPE character varying (11, None);
>
> Tested on: pgAdmin4 1.0-RC1 Desktop, Windows 7 x64, Server: PostgreSQL 9.3.4
>
>
> Regards,
> Jan Rössler



-- 
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

[pgadmin-support] pgAdmin4 1.0-RC1 - Cannot remove nor change length definition on column in "The Table Dialog"

[Jan Rössler]

Hello,

it currently seems to be impossible to change or remove "length" from a
column's definition.

How to reproduce:
1. CREATE TABLE test(string character varying(1));
2. In sidebar, right click on "test" table and select "Properties"
3. Select "Columns"
4. Press the edit icon on column "string"
5. Go to the "Definition" tab
6. Delete the "Length" value
7. Press "Save" button

The inline value of length will change by itself to NaN and an error
message saying "can't execute an empty query" is returned when trying to
save. When I try to delete the length value inline, same error message is
also returned upon save. Meanwhile the SQL tab only shows "--modified SQL",
instead of the needed ALTER statement.

When I want to just edit the length to a different value, it doesn't work
either. In this case some SQL does get generated, but it is not a valid
statement (at least not on version 9.3).
The error message is: ERROR: syntax error at or near "," LINE 2: ALTER
COLUMN string TYPE character varying (11, None);

Tested on: pgAdmin4 1.0-RC1 Desktop, Windows 7 x64, Server: PostgreSQL 9.3.4


Regards,
Jan Rössler