Re: [pgadmin-support] pgAdmin 4: "PostgreSQL Binary Path"?
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 Landauerwrote: 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"?
On Tue, Sep 6, 2016 at 11:39 AM, Thomas Landauerwrote: > 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
On Tue, Sep 6, 2016 at 11:41 AM, Michal Kozusznikwrote: > 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
On 6.9.2016 11:51, Dave Page wrote: On Tue, Sep 6, 2016 at 10:47 AM, Attila Sokiwrote: 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"?
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
On Tue, Sep 6, 2016 at 10:47 AM, Attila Sokiwrote: > 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
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"
Thanks - logged here: https://redmine.postgresql.org/issues/1669 On Tue, Sep 6, 2016 at 2:39 AM, Jan Rösslerwrote: > 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"
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