Franck Pachot

> GIN index is not used by PostgreSQL in any queries below. > So let's use the first one just because it is first. I'm not sure I understand this...

For all who are interested, now Oracle provides the official images: [https://hub.docker.com/r/gvenzl/oracle-xe](https://hub.docker.com/r/gvenzl/oracle-xe)

I think this should be implemented in PostgreSQL rather than YugabyteDB, to have `pg_dump` skip the non-standard access method (`lsmtree` here) and index options (`hash` here). You can have the...

@ghaskins, I see you had bad performance when testing with YugabyteDB YSQL. YugabyteDB's default configuration may not be appropriate. For example, all indexes are hash-sharded, which is not helpful for...

Here is my docker-compose with a lengthy command to overcome this issue and others. It is only one service definition, using `yugabyted`, that can be scaled to more replicas: https://github.com/FranckPachot/yb-compose...

@nlflint great question. It seems that I removed the `rm` thinking it is not needed: ``` -bash-4.2# docker run -d yugabytedb/yugabyte:2024.1.1.0-b137 yugabyted start --background=false 55f910cf4a6188092b64528417d1a73d6a70b5696a04c9d11f4ff3f0e2f52989 -bash-4.2# find / -name ".s.PGSQL.5433"...

Error encountered when trying Puppet: ``` 2023-09-08 10:16:28.550 UTC [739] LOG: execute : BEGIN 2023-09-08 10:16:28.566 UTC [644] ERROR: ACCESS EXCLUSIVE not supported yet at character 33 2023-09-08 10:16:28.566 UTC...

Hey @zeinali-ali, for Docker, you can remove `--advertise_address=0.0.0.0`. Without it, Docker listens to the hostname interface, which is the correct one to be exposed by `ports`. If you run `ysqlsh`...

@alberk8 Thanks, that's the correct way. We need to `--advertise_address` with the hostname (and not the IP address which is the default if we don't set it explicitly) so that...

> Guys thanks for help, but sometime(s) we need access to db out of docker by exporting port(s), without `--advertise_address=0.0.0.0` I'm not able to access to db out of docker...