Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Closing the Query-Tool Tabs with a User which password has been expired during the session results into failed login attempts at the postgresql database #8183

Open
acc-koen opened this issue Nov 27, 2024 · 4 comments
Open

Closing the Query-Tool Tabs with a User which password has been expired during the session results into failed login attempts at the postgresql database #8183

acc-koen opened this issue Nov 27, 2024 · 4 comments
Assignees
@acc-koen
Labels
Bug

Comments

@acc-koen
Copy link

Describe the bug

If a user has been used with open query-tool tabs, which passwords expires during the session, results to failed login events on the postgresql during the closing of the query-tool tabs or pgadmin browser tab itself.

To Reproduce

Create a DB user with the valid until option.
Login with the User through PGAdmin to the database.
Open some query tabs and do some pseudo queries.
Wait until the "valid until" option has expired the user password.
Close single query-tabs or pgadmin browser tab.
See log messages about failed login attempts.

Expected behavior

No login attempts, if the query-tabs or pgadmin will be closed.
@acc-koen acc-koen added the Bug label Nov 27, 2024
@khushboovashi
Copy link
Contributor

Hi,

Please share the screenshots and logs.

@acc-koen
Copy link
Author

acc-koen commented Dec 3, 2024 •
edited
Loading

Here to start test environment with docker-compose:

`
networks:
default:
name: pgadmin
external: false

services:
postgresql:
image: postgres:15.10brew install docker
ports:
- 5432:5432
environment:
- PGUSER=postgres
- POSTGRES_USER=postgres
- POSTGRES_PASSWORD=postgres
- POSTGRES_DB=postgres
healthcheck:
test: ["CMD-SHELL", "pg_isready", "-d", "db_prod"]
interval: 10s
timeout: 10s
retries: 120

pgadmin:
image: dpage/pgadmin4:8.13
ports:
- "5050:80"
environment:
- PGADMIN_DEFAULT_EMAIL=[email protected]
- PGADMIN_DEFAULT_PASSWORD=[email protected]
healthcheck:
test: ["CMD-SHELL", "curl -s http://localhost:80/misc/ping"]
interval: 10s
timeout: 10s
retries: 120
`

What I did:

  • Started postgresql and pgadmin with docker-compose up.
  • Logged in to pgadmin with [email protected].
  • created Postgres server configuration using the postgres user.
  • created demo user and added VALID UNTIL option

CREATE USER demo WITH PASSWORD 'demo';
ALTER ROLE demo VALID UNTIL '2024-12-03 10:27:00'

  • created demo server configuration using the demo user.
  • opened query-tool with demo server and user
  • passed "login with demo before password expiry;" to mark it within the postgresql logs.
  • waited after expiry hit.
  • closed query-tool of demo user.
  • error message appears in logs
  • closed query-tool of Postgres user.
  • kill running docker container from docker-compose.

Logs:
❯ docker-compose up
[+] Running 3/3
✔ Network pgadmin Created 0.0s
✔ Container pgadmin-postgresql-1 Created 0.1s
✔ Container pgadmin-pgadmin-1 Created 0.1s
Attaching to pgadmin-1, postgresql-1
pgadmin-1 | email config is {'CHECK_EMAIL_DELIVERABILITY': False, 'ALLOW_SPECIAL_EMAIL_DOMAINS': []}
postgresql-1 | The files belonging to this database system will be owned by user "postgres".
postgresql-1 | This user must also own the server process.
postgresql-1 |
postgresql-1 | The database cluster will be initialized with locale "en_US.utf8".
postgresql-1 | The default database encoding has accordingly been set to "UTF8".
postgresql-1 | The default text search configuration will be set to "english".
postgresql-1 |
postgresql-1 | Data page checksums are disabled.
postgresql-1 |
postgresql-1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
postgresql-1 | creating subdirectories ... ok
postgresql-1 | selecting dynamic shared memory implementation ... posix
postgresql-1 | selecting default max_connections ... 100
postgresql-1 | selecting default shared_buffers ... 128MB
postgresql-1 | selecting default time zone ... Etc/UTC
postgresql-1 | creating configuration files ... ok
postgresql-1 | running bootstrap script ... ok
postgresql-1 | performing post-bootstrap initialization ... ok
postgresql-1 | initdb: warning: enabling "trust" authentication for local connections
postgresql-1 | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
postgresql-1 | syncing data to disk ... ok
postgresql-1 |
postgresql-1 |
postgresql-1 | Success. You can now start the database server using:
postgresql-1 |
postgresql-1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
postgresql-1 |
postgresql-1 | waiting for server to start....2024-12-03 10:20:08.943 UTC [48] LOG: starting PostgreSQL 15.10 (Debian 15.10-1.pgdg120+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
postgresql-1 | 2024-12-03 10:20:08.944 UTC [48] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgresql-1 | 2024-12-03 10:20:08.947 UTC [51] LOG: database system was shut down at 2024-12-03 10:20:08 UTC
postgresql-1 | 2024-12-03 10:20:08.950 UTC [48] LOG: database system is ready to accept connections
postgresql-1 | done
postgresql-1 | server started
postgresql-1 |
postgresql-1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
postgresql-1 |
postgresql-1 | waiting for server to shut down...2024-12-03 10:20:09.080 UTC [48] LOG: received fast shutdown request
postgresql-1 | .2024-12-03 10:20:09.081 UTC [48] LOG: aborting any active transactions
postgresql-1 | 2024-12-03 10:20:09.082 UTC [48] LOG: background worker "logical replication launcher" (PID 54) exited with exit code 1
postgresql-1 | 2024-12-03 10:20:09.083 UTC [49] LOG: shutting down
postgresql-1 | 2024-12-03 10:20:09.083 UTC [49] LOG: checkpoint starting: shutdown immediate
postgresql-1 | 2024-12-03 10:20:09.087 UTC [49] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB
postgresql-1 | 2024-12-03 10:20:09.089 UTC [48] LOG: database system is shut down
postgresql-1 | done
postgresql-1 | server stopped
postgresql-1 |
postgresql-1 | PostgreSQL init process complete; ready for start up.
postgresql-1 |
postgresql-1 | 2024-12-03 10:20:09.196 UTC [1] LOG: starting PostgreSQL 15.10 (Debian 15.10-1.pgdg120+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
postgresql-1 | 2024-12-03 10:20:09.197 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
postgresql-1 | 2024-12-03 10:20:09.197 UTC [1] LOG: listening on IPv6 address "::", port 5432
postgresql-1 | 2024-12-03 10:20:09.198 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgresql-1 | 2024-12-03 10:20:09.201 UTC [62] LOG: database system was shut down at 2024-12-03 10:20:09 UTC
postgresql-1 | 2024-12-03 10:20:09.204 UTC [1] LOG: database system is ready to accept connections
pgadmin-1 | NOTE: Configuring authentication for SERVER mode.
pgadmin-1 |
pgadmin-1 | pgAdmin 4 - Application Initialisation
pgadmin-1 | ======================================
pgadmin-1 |
pgadmin-1 | postfix/postlog: starting the Postfix mail system
pgadmin-1 | [2024-12-03 10:20:22 +0000] [1] [INFO] Starting gunicorn 22.0.0
pgadmin-1 | [2024-12-03 10:20:22 +0000] [1] [INFO] Listening at: http://[::]:80 (1)
pgadmin-1 | [2024-12-03 10:20:22 +0000] [1] [INFO] Using worker: gthread
pgadmin-1 | [2024-12-03 10:20:22 +0000] [128] [INFO] Booting worker with pid: 128
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET / HTTP/1.1" 302 213 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /login?next=/ HTTP/1.1" 200 2389 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/vendor/require/require.min.js?ver=81300 HTTP/1.1" 200 6770 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/js/generated/pgadmin_commons.js?ver=81300 HTTP/1.1" 200 4970 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/js/generated/style.css?ver=81300 HTTP/1.1" 200 94122 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/js/generated/vendor.react.js?ver=81300 HTTP/1.1" 200 109696 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/js/generated/vendor.main.js?ver=81300 HTTP/1.1" 200 154294 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/js/generated/vendor.sqleditor.js?ver=81300 HTTP/1.1" 200 316885 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/js/generated/vendor.others.js?ver=81300 HTTP/1.1" 200 978330 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/js/generated/fonts/Roboto-Regular..ttf HTTP/1.1" 200 0 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/js/generated/security.pages.js?ver=81300 HTTP/1.1" 200 121598 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /favicon.ico?ver=81300 HTTP/1.1" 302 245 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /static/favicon.ico?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /browser/js/endpoints.js?ver=81300 HTTP/1.1" 200 15329 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:20:57 +0000] "GET /tools/translations.js?ver=81300 HTTP/1.1" 200 321 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "POST /authenticate/login HTTP/1.1" 302 205 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /browser/ HTTP/1.1" 200 2785 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /browser/browser.css?ver=81300 HTTP/1.1" 200 6562 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /static/js/generated/browser_nodes.js?ver=81300 HTTP/1.1" 200 23679 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /static/js/generated/app.bundle.js?ver=81300 HTTP/1.1" 200 400478 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /browser/js/endpoints.js?ver=81300 HTTP/1.1" 200 3234 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /browser/js/messages.js?ver=81300 HTTP/1.1" 200 848 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /tools/translations.js?ver=81300 HTTP/1.1" 200 321 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /browser/server/supported_servers.js?ver=81300 HTTP/1.1" 200 290 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /static/js/pgadmin.js?ver=81300 HTTP/1.1" 200 1545 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /static/js/gettext.js?ver=81300 HTTP/1.1" 200 552 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /browser/js/utils.js?ver=81300 HTTP/1.1" 200 2040 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:14 +0000] "GET /user_management/current_user.js?ver=81300 HTTP/1.1" 200 307 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /browser/check_corrupted_db_file HTTP/1.1" 200 61 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /misc/bgprocess/ HTTP/1.1" 200 2 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /preferences/get_all HTTP/1.1" 200 9987 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /settings/get_tree_state/ HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /static/js/generated/fonts/fa-solid-900..woff2 HTTP/1.1" 200 0 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /browser/nodes/ HTTP/1.1" 200 273 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /static/js/generated/fonts/SourceCodePro-Regular..ttf HTTP/1.1" 200 0 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "POST /browser/master_password HTTP/1.1" 200 166 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /static/js/generated/fonts/fa-regular-400..woff2 HTTP/1.1" 200 0 "http://localhost:5050/login?next=/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:15 +0000] "GET /browser/server_group/static/img/server_group.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:16 +0000] "GET /misc/upgrade_check HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:18 +0000] "GET /browser/server_group/children/1 HTTP/1.1" 200 61 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:21 +0000] "GET /browser/server_group/nodes/ HTTP/1.1" 200 242 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:21 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:21 +0000] "GET /browser/server/static/img/server.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:45 +0000] "POST /settings/save_tree_state/ HTTP/1.1" 200 63 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:45 +0000] "GET /settings/get_tree_state/ HTTP/1.1" 200 2 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:54 +0000] "POST /browser/server/obj/1/ HTTP/1.1" 200 274 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:54 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:54 +0000] "GET /browser/server_group/children/1 HTTP/1.1" 200 354 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:54 +0000] "GET /browser/server_group/nodes/ HTTP/1.1" 200 242 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:54 +0000] "GET /browser/server/connect/1/1 HTTP/1.1" 200 315 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:54 +0000] "GET /browser/server/static/img/pg.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:54 +0000] "GET /dashboard/dashboard_stats/1?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 252 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:54 +0000] "GET /dashboard/dashboard_stats/1?chart_names= HTTP/1.1" 200 2 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:56 +0000] "GET /browser/server/children/1/1 HTTP/1.1" 200 233 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:56 +0000] "GET /browser/database/static/img/coll-database.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:56 +0000] "GET /browser/role/static/img/coll-role.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:56 +0000] "GET /browser/tablespace/static/img/coll-tablespace.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/database/nodes/1/1/ HTTP/1.1" 200 397 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/database/static/img/database.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/database/children/1/1/5 HTTP/1.1" 200 422 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /dashboard/dashboard_stats/1/5?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 239 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/cast/static/img/coll-cast.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/event_trigger/static/img/coll-event_trigger.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/catalog/static/img/coll-catalog.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/extension/static/img/coll-extension.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/foreign_data_wrapper/static/img/coll-foreign_data_wrapper.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/language/static/img/coll-language.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/publication/static/img/coll-publication.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/subscription/static/img/coll-subscription.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /browser/schema/static/img/coll-schema.svg?ver=81300 HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:21:58 +0000] "GET /dashboard/dashboard_stats/1/5?chart_names= HTTP/1.1" 200 2 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "POST /sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres HTTP/1.1" 200 2172 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "GET /browser/browser.css?ver=81300 HTTP/1.1" 200 6562 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "GET /static/js/generated/sqleditor.js?ver=81300 HTTP/1.1" 200 292748 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "GET /browser/js/endpoints.js?ver=81300 HTTP/1.1" 200 3234 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "GET /browser/server/supported_servers.js?ver=81300 HTTP/1.1" 200 290 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "GET /browser/js/messages.js?ver=81300 HTTP/1.1" 200 848 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "GET /user_management/current_user.js?ver=81300 HTTP/1.1" 200 307 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "GET /tools/translations.js?ver=81300 HTTP/1.1" 200 321 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:00 +0000] "GET /browser/js/utils.js?ver=81300 HTTP/1.1" 200 2275 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:01 +0000] "POST /sqleditor/initialize/sqleditor/6709007/1/1/5 HTTP/1.1" 200 102 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:01 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:03 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:05 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:07 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:15 +0000] "POST /settings/save_tree_state/ HTTP/1.1" 200 63 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:15 +0000] "GET /settings/get_tree_state/ HTTP/1.1" 200 214 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:24 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:22:54 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:23:24 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:23:54 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:23:55 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:23:57 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:23:57 +0000] "POST /sqleditor/query_tool/start/6709007 HTTP/1.1" 200 138 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:23:57 +0000] "GET /sqleditor/poll/6709007 HTTP/1.1" 200 463 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:23:57 +0000] "POST /sqleditor/query_history/6709007 HTTP/1.1" 200 90 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:23:59 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:24:01 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:24:24 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:24:54 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:04 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:06 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:08 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
postgresql-1 | 2024-12-03 10:25:09.298 UTC [60] LOG: checkpoint starting: time
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:10 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:11 +0000] "POST /sqleditor/query_tool/start/6709007 HTTP/1.1" 200 138 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:11 +0000] "GET /sqleditor/poll/6709007 HTTP/1.1" 200 462 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:11 +0000] "POST /sqleditor/query_history/6709007 HTTP/1.1" 200 90 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:12 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
postgresql-1 | 2024-12-03 10:25:13.969 UTC [60] LOG: checkpoint complete: wrote 48 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.652 s, sync=0.007 s, total=4.672 s; sync files=16, longest=0.005 s, average=0.001 s; distance=255 kB, estimate=255 kB
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:14 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:16 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:16 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:18 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:20 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:22 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:24 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:24 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:26 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:28 +0000] "POST /browser/server/obj/1/ HTTP/1.1" 200 498 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:28 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:28 +0000] "GET /browser/server_group/nodes/ HTTP/1.1" 200 242 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:28 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:30 +0000] "GET /browser/server/children/1/2 HTTP/1.1" 200 233 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:30 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:32 +0000] "GET /browser/database/nodes/1/2/ HTTP/1.1" 200 398 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:32 +0000] "GET /browser/database/children/1/2/5 HTTP/1.1" 200 423 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:32 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:34 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:34 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:34 +0000] "POST /sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres HTTP/1.1" 200 2171 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "GET /browser/browser.css?ver=81300 HTTP/1.1" 200 6562 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "GET /browser/js/messages.js?ver=81300 HTTP/1.1" 200 848 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "GET /browser/js/endpoints.js?ver=81300 HTTP/1.1" 200 3234 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "GET /tools/translations.js?ver=81300 HTTP/1.1" 200 321 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "GET /user_management/current_user.js?ver=81300 HTTP/1.1" 200 307 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "GET /browser/server/supported_servers.js?ver=81300 HTTP/1.1" 200 290 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "GET /browser/js/utils.js?ver=81300 HTTP/1.1" 200 2283 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "POST /sqleditor/initialize/sqleditor/4625860/1/2/5 HTTP/1.1" 200 102 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:35 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:36 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:37 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:38 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:39 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:40 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:41 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:42 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:43 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:44 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:45 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:46 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
postgresql-1 | 2024-12-03 10:25:47.482 UTC [335] ERROR: syntax error at or near "login" at character 1
postgresql-1 | 2024-12-03 10:25:47.482 UTC [335] STATEMENT: login with demo before password expiry;
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:47 +0000] "POST /sqleditor/query_tool/start/4625860 HTTP/1.1" 200 138 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | 2024-12-03 10:25:47,483: ERROR pgadmin: Failed to execute query (execute_async) for the server #2 - CONN:4226793(Query-id: 2140711):
pgadmin-1 | Error Message:ERROR: syntax error at or near "login"
pgadmin-1 | LINE 1: login with demo before password expiry;
pgadmin-1 | ^
pgadmin-1 |
pgadmin-1 | SQL state: 42601
pgadmin-1 | Character: 1
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:47 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:47 +0000] "GET /sqleditor/poll/4625860 HTTP/1.1" 500 244 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:47 +0000] "POST /sqleditor/query_history/4625860 HTTP/1.1" 200 90 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:48 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:49 +0000] "POST /settings/save_tree_state/ HTTP/1.1" 200 63 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:49 +0000] "GET /settings/get_tree_state/ HTTP/1.1" 200 428 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:49 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:50 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:51 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:25:54 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:26:15 +0000] "POST /misc/cleanup HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:26:25 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:27:07 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:27:45 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:28:54 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:05 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:05 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:07 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:07 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:09 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:09 +0000] "GET /sqleditor/status/4625860 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:11 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
postgresql-1 | 2024-12-03 10:29:11.720 UTC [512] FATAL: password authentication failed for user "demo"
postgresql-1 | 2024-12-03 10:29:11.720 UTC [512] DETAIL: User "demo" has an expired password.
postgresql-1 | Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:11 +0000] "DELETE /sqleditor/close/4625860 HTTP/1.1" 200 74 "http://localhost:5050/sqleditor/panel/4625860?is_query_tool=true&sgid=1&sid=2&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:15 +0000] "GET /dashboard/dashboard_stats/2/5?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 242 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:21 +0000] "GET /dashboard/dashboard_stats/2/5?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 242 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:24 +0000] "POST /misc/heartbeat/log HTTP/1.1" 200 91 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:25 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:26 +0000] "GET /dashboard/dashboard_stats/2/5?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 242 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:27 +0000] "GET /sqleditor/status/6709007 HTTP/1.1" 200 156 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:27 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:29 +0000] "POST /settings/store HTTP/1.1" 200 77 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:29 +0000] "DELETE /sqleditor/close/6709007 HTTP/1.1" 200 74 "http://localhost:5050/sqleditor/panel/6709007?is_query_tool=true&sgid=1&sid=1&did=5&database_name=postgres" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
pgadmin-1 | ::ffff:172.18.0.1 - - [03/Dec/2024:10:29:31 +0000] "GET /dashboard/dashboard_stats/2/5?chart_names=session_stats,tps_stats,ti_stats,to_stats,bio_stats HTTP/1.1" 200 242 "http://localhost:5050/browser/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.1.1 Safari/605.1.15"
Gracefully stopping... (press Ctrl+C again to force)
[+] Stopping 2/2
✔ Container pgadmin-pgadmin-1 Stopped 1.5s
✔ Container pgadmin-postgresql-1 Stopped

@yogeshmahajan-1903
Copy link
Contributor

Can you please share screen recording for the same? We are not able to reproduce the issue.

@acc-koen
Copy link
Author

acc-koen commented Dec 6, 2024

Hi,

there is nothing to be seen on the pgadmin browser screen. It just closes the query-tab without any issues or hints of not being able to relogin.
The issue is, that the occurrence of the failed logins triggers our alerting.
For example someone opens 100 Querytabs for some kind of reasons, it will trigger 100 failed login attempts if the 100 tabs are closed individually or by closing the pgadmin browser tab itself.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@acc-koen acc-koen

Labels
Bug
Projects
Not Refined
Status: No status
Milestone
No milestone
Development

No branches or pull requests
3 participants
@khushboovashi @yogeshmahajan-1903 @acc-koen