Request Support with getting Postgresql 4.8 to run.

2024-04-18 Thread Joseph Haas
sp.reflect_table( File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\python\lib\site-packages\sqlalchemy\engine\reflection.py", line 1538, in reflect_table raise exc.NoSuchTableError(table_name) sqlalchemy.exc.NoSuchTableError: user_old During handling of the above exception, another exception occurred: Traceback (most recent call last): File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgAdmin4.py", line 103, in app = create_app() File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app run_migration_for_sqlite() File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 432, in run_migration_for_sqlite upgrade_db() File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 391, in upgrade_db backup_db_file() File "C:\Users\jchaa\AppData\Local\Programs\pgAdmin 4\web\pgadmin\__init__.py", line 368, in backup_db_file os.rename(SQLITE_PATH, backup_file_name) PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\jchaa\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\jchaa\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20240418103518' Any suggestions would be appreciated. Thank you Joseph Haas

Who thought this was a good idea

2024-03-06 Thread joseph gipson
The pgadmin installer creates a .tmp file in the users’ appdata folder that’s blocked by Applocker. There is no way to whitelist .tmp files. So I have users that are having to have IT manually install updates for them. Is that something that can be rectified in future releases?

RE: Cannot login to pgAdmin4 Web

2021-06-28 Thread O'Connor, Joseph
I'm pretty sure I'm responding to the correct thread since it's the only pgadmin thread I'm currently involved in. I was asked to revert back to the default pgadmin httpd config to see if that fixed the issue, which it didn't. I posted the config I used and included some additional info in the

RE: Cannot login to pgAdmin4 Web

2021-06-25 Thread O'Connor, Joseph
I reconfigured the httpd config and re-setup pgadmin but received the same result. LoadModule wsgi_module modules/mod_wsgi.so WSGIDaemonProcess pgadmin processes=1 threads=25 python-home=/usr/pgadmin4/venv WSGIScriptAlias /pgadmin4 /usr/pgadmin4/web/pgAdmin4.wsgi WSGIProcessGroup

Cannot login to pgAdmin4 Web

2021-06-23 Thread O'Connor, Joseph
When attempting to login to pgadmin server I get the message "Incorrect username or password". At first I figured I just forgot my password so I deleted the pgadmin directories and packages and reran the setup-web.sh and reentered credentials but I still get the same "Incorrect username or

RE: Varying Character comparison

2021-01-06 Thread Joseph Ruffino
Rik, Is there a user list I can send this too? It is cast, “as barcode” in line 2, but it will not accept it when I do barcode != 2111300. I have tried adding quotes around ‘2111300’, and it has been running for 30+ minutes. Do you know if another way to cast it? Joseph A. Ruffino Gail

Varying Character comparison

2021-01-06 Thread Joseph Ruffino
| NULLIF(pn.middle_name, ''), ''), pr.ptype_code ASC, pr.activity_gmt DESC Joseph A. Ruffino Gail Borden Public Library District Web Programmer 270 N. Grove Ave. Elgin, IL 60120 Phone: (847) 429-5986 Fax: (847) 608-5201 http://www.gailborden.info PLEASE NOTE: Pursuant to Illinois State Law, e-mail communication t

Persisting Query tabs/contents over restart

2020-06-08 Thread Joseph
Looks like the last time this might have been mentioned is 2016? Or not, don't know; I just started following this list. I don't *think*, but I could very well be totally wrong, that it would be hard to persist the arrangement and contents of query tabs across sessions. There are several local

pgadmin 4.15 panel borders

2019-11-18 Thread JOSEPH RIMBACK
[MacBook Pro (desktop only); PostgreSQL12; PGAdmin 4.15] After struggling with missing or poorly defined light blue panel borders in the 4.13 Query Tool for the last several weeks, I installed 4.15 three days age. Well-defined (sepia colored) borders showed up which were perfect. Yesterday I

pgAdmin 4 / PostgreSQL 10 Won't Open

2018-01-17 Thread Joseph Gutierrez
My name is Joseph. I am a university student that is using Lynda.com to learn how to use PostgreSQL. So I have installed PostgreSQL 10 and it came along with pgAdmin 4. Upon doing so, a dialog box comes up with the message “Fatal Error: The application server could not be contacted.” I have