Re: pgadmin4 error

2021-10-27 Thread Dave Page 
Hi

On Wed, Oct 27, 2021 at 6:38 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi João,
>
> v4.29 is quite an old version and we do not support it. pgAdmin is
> available only in 64 bit installers.
>
> On Wed, Oct 27, 2021 at 6:01 AM João Holanda 
> wrote:
>
>>
>> I opened the link and clicked on version v4.29 and it gave "page not
>> found". What do I do to get the 32-bit version?
>>
>
That's my fault - I purged old versions from the main download site, and
forgot to do the same with the metadata the website uses. Sorry about that.

You can download all old versions from
https://pgadmin-archive.postgresql.org/pgadmin4/index.html



>
>>
>>
>> --
>> *De:* Aditya Toshniwal 
>> *Enviado:* terça-feira, 26 de outubro de 2021 05:50
>> *Para:* João Holanda 
>> *Cc:* pgadmin-support@lists.postgresql.org <
>> pgadmin-support@lists.postgresql.org>
>> *Assunto:* Re: pgadmin4 error
>>
>> Hi João,
>>
>> As per https://www.pgadmin.org/download/pgadmin-4-windows/, pgAdmin
>> v4.29 had the last 32 bit installer.
>>
>> On Tue, Oct 26, 2021 at 2:04 PM João Holanda 
>> wrote:
>>
>>
>> So, my windows has 32 bit architecture and I can't find a pgadmin4
>> version to download for this model, only 64 bit. Can you send me a 32bit
>> version of pgadmin for me to download?
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
>>  Livre
>> de vírus. www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>.
>>
>> <#m_-2240588654296998666_m_-7644476103255841875_x_m_-6952837903114314872_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>>
>>
>> --
>> Thanks,
>> Aditya Toshniwal
>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>> <http://edbpostgres.com>
>> "Don't Complain about Heat, Plant a TREE"
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>


-- 
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

Re: pgadmin4 error

2021-10-26 Thread Aditya Toshniwal 
Hi João,

v4.29 is quite an old version and we do not support it. pgAdmin is
available only in 64 bit installers.

On Wed, Oct 27, 2021 at 6:01 AM João Holanda 
wrote:

>
> I opened the link and clicked on version v4.29 and it gave "page not
> found". What do I do to get the 32-bit version?
>
>
> --
> *De:* Aditya Toshniwal 
> *Enviado:* terça-feira, 26 de outubro de 2021 05:50
> *Para:* João Holanda 
> *Cc:* pgadmin-support@lists.postgresql.org <
> pgadmin-support@lists.postgresql.org>
> *Assunto:* Re: pgadmin4 error
>
> Hi João,
>
> As per https://www.pgadmin.org/download/pgadmin-4-windows/, pgAdmin v4.29
> had the last 32 bit installer.
>
> On Tue, Oct 26, 2021 at 2:04 PM João Holanda 
> wrote:
>
>
> So, my windows has 32 bit architecture and I can't find a pgadmin4 version
> to download for this model, only 64 bit. Can you send me a 32bit version of
> pgadmin for me to download?
>
>
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
>  Livre
> de vírus. www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>.
>
> <#m_-7644476103255841875_x_m_-6952837903114314872_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

Re: pgadmin4 error

2021-10-26 Thread Aditya Toshniwal 
Hi João,

As per https://www.pgadmin.org/download/pgadmin-4-windows/, pgAdmin v4.29
had the last 32 bit installer.

On Tue, Oct 26, 2021 at 2:04 PM João Holanda 
wrote:

>
> So, my windows has 32 bit architecture and I can't find a pgadmin4 version
> to download for this model, only 64 bit. Can you send me a 32bit version of
> pgadmin for me to download?
>
>
> 
>  Livre
> de vírus. www.avast.com
> .
> <#m_-6952837903114314872_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"

Re: pgadmin4 error

2020-10-28 Thread Aditya Toshniwal 
Hi Levente,

Please try installing from pgAdmin team built installer -
https://www.pgadmin.org/download/pgadmin-4-rpm/

On Wed, Oct 28, 2020 at 4:10 PM Levente Birta  wrote:

>
> Hello,
>
> I use pgadmin4 with server installation, on Centos7, installed from
> official postgresql yum repo.
>
> I'm on 4.27 now, but since v4.24, IIRC, I got error when I try to
> visualize the SQL for a table:
> INTERNAL SERVER ERROR ... expected token 'end of statement block', got  '.'
>
> For views, foreign tables or any other stuff is working ...
>
> Any ideas?
> Thanks
> Levi
>
>
> The apache error log:
>
> [Thu Oct 08 10:29:05.260331 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] 2020-10-08 10:29:05,259: ERROR\tflask.app:\texpected
> token 'end of statement block', got '.'
> [Thu Oct 08 10:29:05.260347 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] Traceback (most recent call last):
> [Thu Oct 08 10:29:05.260350 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1813,
> in full_dispatch_request
> [Thu Oct 08 10:29:05.260352 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] rv = self.dispatch_request()
> [Thu Oct 08 10:29:05.260353 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1799,
> in dispatch_request
> [Thu Oct 08 10:29:05.260361 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] return
> self.view_functions[rule.endpoint](**req.view_args)
> [Thu Oct 08 10:29:05.260363 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/views.py", line 88,
> in view
> [Thu Oct 08 10:29:05.260365 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] return self.dispatch_request(*args, **kwargs)
> [Thu Oct 08 10:29:05.260367 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/utils.py",
> line 313, in dispatch_request
> [Thu Oct 08 10:29:05.260369 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] return method(*args, **kwargs)
> [Thu Oct 08 10:29:05.260371 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
>
> line 158, in wrap
> [Thu Oct 08 10:29:05.260373 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] return f(*args, **kwargs)
> [Thu Oct 08 10:29:05.260374 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py",
>
> line 1388, in sql
> [Thu Oct 08 10:29:05.260376 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] self, did=did, scid=scid, tid=tid,
> main_sql=main_sql, data=data)
> [Thu Oct 08 10:29:05.260378 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
>
> line 770, in get_reverse_engineered_sql
> [Thu Oct 08 10:29:05.260380 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] self._get_resql_for_table(did, scid, tid, data,
> json_resp, main_sql)
> [Thu Oct 08 10:29:05.260382 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
>
> line 495, in _get_resql_for_table
> [Thu Oct 08 10:29:05.260383 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] data=data, conn=self.conn, is_sql=True)
> [Thu Oct 08 10:29:05.260385 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/templating.py",
> line 134, in render_template
> [Thu Oct 08 10:29:05.260387 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] return
> _render(ctx.app.jinja_env.get_or_select_template(template_name_or_list),
> [Thu Oct 08 10:29:05.260388 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
> line 851, in get_or_select_template
> [Thu Oct 08 10:29:05.260390 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] return self.get_template(template_name_or_list,
> parent, globals)
> [Thu Oct 08 10:29:05.260392 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
> line 812, in get_template
> [Thu Oct 08 10:29:05.260393 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105] return self._load_template(name,
> self.make_globals(globals))
> [Thu Oct 08 10:29:05.260395 2020] [wsgi:error] [pid 1047] [remote
> ip.ad.re.ss:53105]   File
>

Re: PgAdmin4 Error 5 opening SQL file

2018-02-05 Thread Murtuza Zabuawala 
Hello,

Unfortunately I did not find any error in the logs but from the screenshot
it seems like pgAdmin4 is running with different user permissions which do
not have access to Z: drive.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Mon, Feb 5, 2018 at 3:27 PM, Harper Ian <ian.har...@vaisala.com> wrote:

> Here are the two things you asked for, Z: drive is a network mounted drive
> and in windows explorer I can bury down through it with no issues.
>
>
>
> Ian
>
>
>
>
>
> *From:* Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com]
> *Sent:* Thursday, 01 February, 2018 14:14
> *To:* Harper Ian <ian.har...@vaisala.com>
> *Cc:* pgadmin-support@lists.postgresql.org
> *Subject:* Re: PgAdmin4 Error 5 opening SQL file
>
>
>
>
>
>
>
> On Thu, Feb 1, 2018 at 2:50 PM, <ian.har...@vaisala.com> wrote:
>
> PgAdmin v 4.2.1 on Windows 10 running in Desktop mode
>
>
>
> I am trying to open an sql fie in the query tool which is located on a
> network drive.
>
>
>
> If I try to file open it mainly  shows the attached physical drives and
> not the network drives, sometimes it does show the network drives but then
> when you start to go into them it pops up with an Error 5.
>
> ​Could you provide us screenshot of error & pgAdmin4.log file with debug
> mode on?
>
> Ref: https://www.pgadmin.org/faq/#8
>
> ​
>
>
>
>
>
> This occurs when running PgAdmin4 as Administrator and as ordinary user.
>
>
>
> If I use windows explorer and go to the file and select to run it using
> pgadmin 4 desktop runtime, it pops up with the main screen of PgAdmin and
> does nothing.
>
>
>
> Any help would be appreciated.
>
>
>