pgadmin4 error

2020-10-08 Thread Levente Birta 

Hello,

I use pgadmin4 with server installation, on Centos7, installed from 
official postgresql yum repo.


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 
"/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py", 
line 786, in _load_template
[Thu Oct 08 10:29:05.260397 2020] [wsgi:error] [pid 1047] [remote 
ip.ad.re.ss:53105] template = self.loader.load(self, name, globals)
[Thu Oct 08 10:29:05.260398 2020] [wsgi:error] [pid 1047] [remote 
ip.ad.re.ss:53105]   File 
"/usr/lib/

pg_cron question

2020-12-02 Thread Levente Birta 

Hi all

Is there a way to run pg_cron job only once?
Or can I get somehow inside the cronjob the ID of a running job to 
unschedule?


Thanks
Levi

Power loss test

2022-03-02 Thread Levente Birta 

Hello

For many years when I get a new server every time I tested the storage 
system with diskchecker.pl for power loss.


I'm just curious if there is any other/newer tool to test ?

Thanks
Levi

Recommended storage hardware

2022-01-06 Thread Levente Birta 

Hi all

What storage is recommended nowdays?

Currently I'm using two of SSD DC P3700 Series add in card 
(SSDPEDMD400G4) in soft raid 1, but it's pretty old and I have to 
replace the whole server.


Before, I used Intel too and I'm very satisfied, but now that intel sold 
the ssd business looks like I have to choose something else.


Or how about the optane? Is worth it?

Thanks
Levi

Update to postgresql 14.14

2024-11-20 Thread Levente Birta 

Hi

I'm trying to update postgresql 14.13->14.14, but there is a libllvm 
18.1 dependency.
I have enabled the pgdg-centos8-sysupdates repo, but as I see there is 
no llvm 18, only 16/17.

Is something that I miss?

All this on rocky linux 8, up to date.

Thanks
Levi

Re: Update to postgresql 14.14

2024-11-21 Thread Levente Birta 




On 20/11/2024 18:15, Adrian Klaver wrote:

On 11/20/24 06:26, Levente Birta wrote:

Hi

I'm trying to update postgresql 14.13->14.14, but there is a libllvm 
18.1 dependency.
I have enabled the pgdg-centos8-sysupdates repo, but as I see there 
is no llvm 18, only 16/17.

Is something that I miss?


See:

https://yum.postgresql.org/news/rocky-9-8-llvm-repo-is-available/


Exactly. I have enabled the repo, but there is no llvm18 in the repo.