supabase tail command for logs about cli HOT 10 CLOSED

Hi @user72356, yes we have just released supabase/logflare docker image. We will be testing integration on self-hosted and CLI in the next few weeks.

from cli.

Hi @plmwd , the local postgres logs are stored inside the postgres container, timestamped by the hour.

$ docker exec -it supabase_db_supabase-dev ls -la /var/log/postgresql
total 228
drwxrwxr-t 1 root     postgres   4096 Sep  2 05:54 .
drwxr-xr-x 1 root     root       4096 Jan 27  2022 ..
-rw-r----- 1 postgres postgres 216553 Sep  2 05:55 server_0500_UTC.csv
-rw-r----- 1 postgres postgres    406 Sep  2 05:54 server_0500_UTC.log

We are actively looking into exposing logs explorer in local studio so that it's as easier view and filter Postgres logs. For other services like Kong, the currently supported way is to tail via docker logs.

docker logs -f supabase_kong_supabase-dev

from cli.

It seems that the pgsql logs have been disabled. Those are not generated anymore :(

We have changed the postgres logs settings back to stdout so you should be able to get the local postgres logs by docker logs command:

docker logs -f supabase_db_<project>

If you have a long running local development setup and the logs become too much for docker to handle, you can enable logflare to store the logs on BigQuery.

from cli.

Just re-enabling the pgsql logs in the docker container would make our lives much easier. Is it a problem to do so while waiting for better options with logflare?

from cli.

How do you even view db logs?

from cli.

Any updates on this?

from cli.

Hi @plmwd , the local postgres logs are stored inside the postgres container, timestamped by the hour.

$ docker exec -it supabase_db_supabase-dev ls -la /var/log/postgresql
total 228
drwxrwxr-t 1 root     postgres   4096 Sep  2 05:54 .
drwxr-xr-x 1 root     root       4096 Jan 27  2022 ..
-rw-r----- 1 postgres postgres 216553 Sep  2 05:55 server_0500_UTC.csv
-rw-r----- 1 postgres postgres    406 Sep  2 05:54 server_0500_UTC.log

We are actively looking into exposing logs explorer in local studio so that it's as easier view and filter Postgres logs. For other services like Kong, the currently supported way is to tail via docker logs.

docker logs -f supabase_kong_supabase-dev

@sweatybridge are you guys still looking at exposing the local logs in the studio?

from cli.

It seems that the pgsql logs have been disabled. Those are not generated anymore :(

from cli.

Hi @user72356, yes we have just released supabase/logflare docker image. We will be testing integration on self-hosted and CLI in the next few weeks.

How is this coming along? I saw some docs stating I have to have a Google Cloud account just to see the local logs? Did I understand that correctly?

from cli.

I saw some docs stating I have to have a Google Cloud account just to see the local logs? Did I understand that correctly?

Yes, at its current stage logflare does require a GCP account which is rather counter intuitive for local development.

That said, the logflare team is working on supporting postgres as the storage backend. But it's gonna take some time because we have to rework the BigQuery queries as well. You can follow the logflare repo for more status updates.

from cli.