Re: pgbench without dbname worked differently with psql and pg_dump

2025-02-14 Thread Ashutosh Bapat
On Wed, Jan 22, 2025 at 7:24 AM Hayato Kuroda (Fujitsu) wrote: > > ``` > > Thanks for the confirmation. I found below executables seem to have the same > logic to decide the dbname: > > - pg_amcheck The documentation just says "If no such options are present, the default database will be checked.

RE: pgbench without dbname worked differently with psql and pg_dump

2025-01-21 Thread Hayato Kuroda (Fujitsu)
Dear David, > As none of those programs "create" a database the wording "The default is to > create a database" seems quite a poor choice to standardize on. Oh, I misunderstood. Sorry. I wanted to suggest like below: ``` The default is to connect to a database with the same name as the current s

Re: pgbench without dbname worked differently with psql and pg_dump

2025-01-21 Thread David G. Johnston
On Tue, Jan 21, 2025 at 6:54 PM Hayato Kuroda (Fujitsu) < kuroda.hay...@fujitsu.com> wrote: > > IIUC createdb has the good description [1] and it can be re-used > everywhere. > As none of those programs "create" a database the wording "The default is to create a database" seems quite a poor choic

RE: pgbench without dbname worked differently with psql and pg_dump

2025-01-21 Thread Hayato Kuroda (Fujitsu)
Dear Ashutosh, > I see the same behaviour. The code in pgbench which decided the > database to connect to, looks similar to the relevant code in > createdb. But createdb documentation is in agreement with the code. > [1] > ``` > dbname > > Specifies the name of the database to be created. The nam

Re: pgbench without dbname worked differently with psql and pg_dump

2025-01-21 Thread Ashutosh Bapat
On Tue, Jan 21, 2025 at 12:33 PM Hayato Kuroda (Fujitsu) wrote: > > Dear hackers, > > Recently the 'd' option of pgbench is unified with other applications like > psql and pg_dump, > but I found further difference. pgbebch uses an OS user as the dbanme even > when the '-U' is > specified. Please