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