Re: apache virtualhost

2021-01-06 Thread Aditya Toshniwal
Hi, You need to provide the python-home as well. Refer - https://www.pgadmin.org/docs/pgadmin4/4.29/server_deployment.html#apache-httpd-configuration-linux-unix On Sat, Jan 2, 2021 at 1:20 PM Abdeldjalil FELLAH wrote: > on centos8 and apache2.4 I installed postgres13 and pgadmin4 and a php > ap

Re: CSRF Tokens Do Not Match - Kubernetes Deployment via LoadBalancer

2021-01-06 Thread Aditya Toshniwal
Hi Chris, Try setting PGADMIN_CONFIG_ENHANCED_COOKIE_PROTECTION=False in docker env vars. On Wed, Jan 6, 2021 at 6:56 PM Chris Nicholas wrote: > Hi, > > I’ve deployed PGadmin4 via Docker container into our Kubernetes Cluster - > TLS enabled and exposed via AWS LoadBalancer. > > Service boots fi

Re: Varying Character comparison

2021-01-06 Thread Jack Royal-Gordon
Joseph, What you quoted “as barcode” is NOT a “cast”, that is an alias, which is about naming a value in order to facilitate referencing it elsewhere. A “cast” is about stating explicitly what type you want the value converted to. For example cast(barcode as int) takes the “varchar” barcode and

Re: Varying Character comparison

2021-01-06 Thread Rob Richardson
You could try reddit.com/r/sql RobR On Wednesday, January 6, 2021, 01:55:23 PM EST, Joseph Ruffino wrote: #yiv6276017970 #yiv6276017970 -- _filtered {} _filtered {}#yiv6276017970 #yiv6276017970 p.yiv6276017970MsoNormal, #yiv6276017970 li.yiv6276017970MsoNormal, #yiv6276017970 div.yiv6

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 Borde

Re: Varying Character comparison

2021-01-06 Thread richard coleman
Joseph, This is really an SQL question, not something specific to PostgreSQL or pgAdmin. That being said, it looks like your e.index_entry field is of type varchar (character varying) and you are trying to compare it to an int. If that is the case you will need to either cast the e.index_entry f

Varying Character comparison

2021-01-06 Thread Joseph Ruffino
Hi, I am not sure if this is how I add a question, but I cannot find anything on lists.postgesql.org. I am having a problem with a SQL that I am running in pgAdmin 4.27. The SQL is being used to check for duplicates in our PostgreSQL DB. I am trying to edit out the barcode (e.index_entry) whe

Re: pgadmin4 executable file

2021-01-06 Thread Rahul Shirsat
Hi Francis, You can find the executable pgadmin4 dmg file, just follow the simple steps given below: Head towards the Download section - https://www.pgadmin.org/download/pgadmin-4-macos/ Here you will see the latest version like - pgAdmin 4 v4.29 (released Dec. 10, 2020) Click on it. This will

pgadmin4 executable file

2021-01-06 Thread Francis Figuerres
Hello Pgadmin Support, I'm looking to download the executable file for pgadmin4 for MacOS. However, I can't seem to find that file under the downloads tab. Can you please assist? -- Best, Francis Figuerres

CSRF Tokens Do Not Match - Kubernetes Deployment via LoadBalancer

2021-01-06 Thread Chris Nicholas
Hi, I’ve deployed PGadmin4 via Docker container into our Kubernetes Cluster - TLS enabled and exposed via AWS LoadBalancer. Service boots fine and I can get to the login page, but I get failed login with “CSRF Tokens Do Not Match” error. Standard config.py. Any pointers? Thanks in advance!