Unable to save queries

version 4.6-1.pgdg100+1 on Debian with Firefox Quantum 66.0.5 (64-bit). I had to close the tab and lost my query. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap

Not able to connect to server (solved - at least this time)

in ~/.pgadmin. I suspect the last did not make a difference. Anyhow now I succeeded in getting pgadmin4 to run again. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie

Re: Unable to launch PgAdmi 4

I already tried to > run it as an administrator but it doesn’t work neither. Could please help me > or give me a link where I can find support? Same problem here. I (for now) have given up on trying to use pgadmin4 on Debian. Regards. Johann -- Johann SpiesTe

Re: PgAdmin4 stopped working: "The application server could not be contacted."

CM-SHA384, bits: 256, compression: off) Type "help" for help. localhost js@wos=# ---------- Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691

PgAdmin4 stopped working: "The application server could not be contacted."

he job. I sometimes just look for functionality available in pgadmin3 and pgadmin4 that is not available in the others. Unless the reliability of pgadmin4 improves a lot, I will probably, for my own peace of mind, take a decision to not try it out again. Regards Johann -- Jo

History of queries

With pgadmin3 I could find the past n queries in ~/.pgadmin_histoqueries and configure the number of queries kept there. Where do I find something similar in pgadmin4? Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks

Re: Desktop-mode on Debian

it now and now I can see the icon I could not find. Maybe this must be in the documentation: "If you are using XFCE4 on Debian, install the 'indicator' plugin." Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager

Re: Desktop-mode on Debian

ephant in any systray. Until I can figure this out, I will use a combination of pgadmin3, datagrip and omnidb-app. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wet

Desktop-mode on Debian

Since the availability of 4.2 on Debian (pgdg-version) I could use pgadmin4 in the desktop-mode. Today I have upgraded to 4.3 and now I am back in the web browser - which I do not want. Do I have to reconfigure the system every time there is a new Debian package? Regards Johann -- Johann Spies

Re: able column headings PgAmin4

I have created a github repository. The script to create a PostgreSQL dumpfile from a csv is available at https://github.com/johannspies/csv_to_sql.jl . Initial tests seems to indicate that it is working now. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Da

Re: able column headings PgAmin4

write the script in Python3. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Uni

Re: able column headings PgAmin4

It creates an SQL-file from a csv similar to the output of a pg_dump of a table. Then I can run 'psql -f sqlfile.sql' and it will create and populate the table. I have attached the script. You need to have Julia on your computer (which is a good thing :) Regards.

Re: pgAdmin4 from apt.postgresql.org

rces.list to a newer version of debian before getting "apt-get -f install" to get all the dependencies. Or just upgrade to a newer version of Debian :) I am not sure whether the method I mentioned will work. Be careful not to break your Jessie. Regards Johann -- Johann Spies

Re: pgAdmin4 from apt.postgresql.org

it using "dpkg -i" which will through a lot of dependency-missing errors. Then try apt-get -f install. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetens

Re: Fwd: pgAdmin4 2.1 on apt.postgresql.org

gadmin.org/) is now also available via the > Debian and Ubuntu repository https://apt.postgresql.org/. The > previously not yet packaged Python modules have all been converted to > proper Debian packages by credativ. Thank you for this. Regards Johann -- Johann Spies

No module named 'logging'

ready for production use. It is wasting my time. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Sc

Output format of explain

as I could figure out) not an option to change the format. Or is there? Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on

Re: F5 - irritating behaviour

On Thu, Nov 02, 2017 at 09:44:27AM +, Dave Page wrote: > On Thu, Nov 2, 2017 at 9:35 AM, Johann Spies wrote: > > > It sounds like Firefox is grabbing the keypress. That shouldn't happen as > long as the query tool has focus. Is that the case? Yes. After editing the quer

F5 - irritating behaviour

happens. I am just getting a bit fed-up with this behaviour. Is there a way to get Ctl-E back as it was on pgadmin3? Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie

Export as csv

just not available. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit

Re: Installation failure on Debian

On Tue, Oct 17, 2017 at 05:56:16PM +0530, Murtuza Zabuawala wrote: > Already answered here https://stackoverflow.com/questions/46707935/oserror-errno-13-permission-denied-var-lib-pgadmin> Thanks. Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder /

Installation failure on Debian

gadmin/setup/data_directory.py", line 15, in _create_directory_if_not_exists os.mkdir(_path) PermissionError: [Errno 13] Permission denied: '/var/lib/pgadmin' Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum

Re: pgAdmin 4 v2.0 Release Candidate 2

tended to be a carbon copy. This remark seems to me a bit mischievous. You seem to intentionally distort Melvyn's complains - much like politicians do. He has got valid arguments. Try and listen to him please. Regards Johann -- Johann SpiesTelefoon: 0

Re: Query tool - file browser

he original problem but I could not get the desktop version to work which I prefer to work with. As long as the installation causes so much effort to get it going, it is not worth while. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / D

Re: Query tool - file browser

Debian. I will try again in a few months time. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and

Re: Query tool - file browser

es not find my home directory. The gui seems to start at /. Why? > After deleting the database in ~/pgadmin and restarting pgadmin4 and reconfiguring the settings I can now open files and the server seems to find my filesystem. Earlier it told me that my home directory did not exist. Regards J

Query tool - file browser

ery time I want to use a pre-existing query. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and

Re: pgAdmin 4 v1.6 Released!

re is a new version just to get it working. Fortunately I have seen somewhere there is a promise of a package for Debian. I will wait for it. Making the installation process (or at least the update process) easier should be a prioirity. Regards Johann -- Johann Spies