Re: [pgadmin-support] SQL tab - DDL syntax

2017-03-29 Thread Murtuza Zabuawala
pgAdmin4 is open source so there is nothing to disclose :) you can refer the source code https://www.pgadmin.org/development/git.php -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Mar 29, 2017 at 6:21 PM, matshyeq wrote: > Hell

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread marcelo
Near exactly the problems I confronted. I don't know why this complex and troublesome build process. Thank you, Rich. On 29/03/17 19:33, Rich Shepard wrote: On Wed, 29 Mar 2017, Rich Shepard wrote: Now on to the config file. Copied the config_local.py from the README to that filename in v

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
On Wed, 29 Mar 2017, Rich Shepard wrote: Now on to the config file. Copied the config_local.py from the README to that filename in /opt/pgAdmin4/web/. Then cd'd to /opt/pgAdmin4/runtime/ and ran qmake. Despite having python3-3.6.0 and Qt5-5.5.1 installed, and all the requirements install

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
On Wed, 29 Mar 2017, Rich Shepard wrote: Within that environment I ran pip3 as in step 4, but since installation of many of the tools requires root privileges I ran [root@salmo ~]# pip install -r /opt/pgadmin4-1.3/requirements.txt. This failed because it was looking for python-2.x rather than 3.

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
On Thu, 30 Mar 2017, Ashesh Vashi wrote: Within that environment I ran pip3 as in step 4, but since installation of ... Please try pip3 (on some system, for python 3, it uses pip3). Ashesh, Please see above line in original message. Rich -- Sent via pgadmin-support mailing list (pgadm

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Ashesh Vashi
On Thu, Mar 30, 2017 at 2:33 AM, Rich Shepard wrote: > On Wed, 29 Mar 2017, marcelo wrote: > > Please, tell the list the new building process results. I cannot follow it >> without errors and strange errors. >> > > Marcelo, > > One question I had asked a while ago has been anwered: one needs to

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
On Wed, 29 Mar 2017, marcelo wrote: Please, tell the list the new building process results. I cannot follow it without errors and strange errors. Marcelo, One question I had asked a while ago has been anwered: one needs to install the python web framework, flask, and SQLAlchemy even if the

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread marcelo
Hi Rich Please, tell the list the new building process results. I cannot follow it without errors and strange errors. TIA Marcelo On 29/03/17 15:14, Rich Shepard wrote: On Wed, 29 Mar 2017, Rich Shepard wrote: I'll go to the web site and try again. Downloaded the 1.3 tarball and the R

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
On Wed, 29 Mar 2017, Rich Shepard wrote: I'll go to the web site and try again. Downloaded the 1.3 tarball and the README file is 310 lines long. I'm sure the required information is in there. Thanks, Dave, Rich -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
On Wed, 29 Mar 2017, Dave Page wrote: There's a large section entitled: "Configuring the Python Environment", followed by another one describing how to configure the two parts to work together. Dave, OK. The README I downloaded with pgAdmin-4.1.1 is 84 lines long, separated into four sectio

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Dave Page
On Wed, Mar 29, 2017 at 12:46 PM, Rich Shepard wrote: > On Wed, 29 Mar 2017, Dave Page wrote: > >> What about the Python parts? > > > Dave, > > Other than Python-2.6 or more recent I don't see other python parts in the > README. Installed here are: > > python-2.7.13 > python-dateutil > python3-3

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
On Wed, 29 Mar 2017, Dave Page wrote: What about the Python parts? Dave, Other than Python-2.6 or more recent I don't see other python parts in the README. Installed here are: python-2.7.13 python-dateutil python3-3.6.0 python3-PyQt5-5.6 python3-sip-4.18 Please show me what I'm missing.

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Dave Page
On Wed, Mar 29, 2017 at 12:19 PM, Rich Shepard wrote: > On Wed, 29 Mar 2017, Dave Page wrote: > >> Have you followed the instructions in the README? > > > Dave, > > Yes. in the section titled, Building. > > "To build the runtime, the following packages must be installed: > > - QT 4.6 or above (o

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
On Wed, 29 Mar 2017, Dave Page wrote: Have you followed the instructions in the README? Dave, Yes. in the section titled, Building. "To build the runtime, the following packages must be installed: - QT 4.6 or above (older versions may work, but haven't been tested). - Python 2.6 or above.

Re: [pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Dave Page
On Wed, Mar 29, 2017 at 10:51 AM, Rich Shepard wrote: > I want to build pgAdmin4 runtime only; no browser interface, but ... > > When I built the executable following the directions for the runtime > version and invoked pgAdmin4 it displays a dialog box asking for the python > and application

[pgadmin-support] Building runtime-only pgAdmin4

2017-03-29 Thread Rich Shepard
I want to build pgAdmin4 runtime only; no browser interface, but ... When I built the executable following the directions for the runtime version and invoked pgAdmin4 it displays a dialog box asking for the python and application paths: $ pgAdmin4 Python path: "/usr/bin/python2" Python Ho

[pgadmin-support] How to set connection timeout for pgAdmin 4 (postgres 9.6)

2017-03-29 Thread Gutfreund, Yechezkal
I have read the article listed here many times http://dba.stackexchange.com/questions/97534/is-there-a-timeout-option-for-remote-access-to-postgresql-database but I still have no idea where one sets the config parameter for connection_timeout. I am connecting from a local host to a local host, s

[pgadmin-support] SQL tab - DDL syntax

2017-03-29 Thread matshyeq
Hello, I need to automate comparison of schemas between DBs. I've found that pg_dump produces different order of tables etc.. so can't directly compare that but on the other hand I see pgAdmin brings up really neat syntax (and different from pg_dump) Could you guys disclose if the logic to get SQ