Re: PostgreSQL - How to login with my Linux user account

On 7/27/23 17:19, Amn Ojee Uw wrote: I'd like to log into my newly installed PostgreSQL [ PostgreSQL 12.15 (Debian 12.15-1.pgdg120+1) ] using my linux account. In trying to do that this web page suggest that I enter :

Re: PostgreSQL - How to login with my Linux user account

On Thu, Jul 27, 2023 at 5:19 PM Amn Ojee Uw wrote: > However, that command requires a database_name (mydb), and PosgreSQL 12.15 > being so freshly installed does not yet > have any database created by me. > > So create some. Otherwise the only useful database name to specify would be

PostgreSQL - How to login with my Linux user account

I'd like to log into my newly installed PostgreSQL [ PostgreSQL 12.15 (Debian 12.15-1.pgdg120+1) ] using my linux account. In trying to do that this web page suggest that I enter : psql -d mydb -U myuser -W However,

Re: password error in batch script

On 7/27/23 1:17 PM, Atul Kumar wrote: Hi, I have a password Vl=SO*CIz%A83FQF that is working fine like that in the command prompt but when it is being used in a batch file it is giving me an error of wrong password, the password is something looks like that in batch script. set

Re: How to improve the performance of my SQL query？

Hi "gzh", Based on the info you provided I'm assuming you are trying to use the TBL_SHA primary key to do an index-only scan as in you mentioned above you have: > TBL_SHA > ms_cd character(6) NOT NULL -- PRIMARY KEY > et_cd character(8) > etrys character(8) Assuming a composed index here by

password error in batch script

Hi, I have a password Vl=SO*CIz%A83FQF that is working fine like that in the command prompt but when it is being used in a batch file it is giving me an error of wrong password, the password is something looks like that in batch script. set "PGPASSWORD=Vl=SO*CIz%A83FQF" Could you please help me

Re: Create DB privilege is not inherited

On Thu, 27 Jul 2023 06:09:28 -0700 "David G. Johnston" wrote: > On Thursday, July 27, 2023, Ben Hancock wrote: > > > > > > Should the CREATEDB privilege be inherited when granting the 'admins' > > role to a user, or is another step required? > > > > Or (quite possibly) have I misunderstood

Re: Create DB privilege is not inherited

On Thursday, July 27, 2023, Ben Hancock wrote: > > > Should the CREATEDB privilege be inherited when granting the 'admins' > role to a user, or is another step required? > > Or (quite possibly) have I misunderstood something else? > Docs say:

Create DB privilege is not inherited

Hi folks, I've created a role 'admins' and conferred the CREATEDB and CREATE ROLE privileges to this role. I'd like to be able to add users to this role in order to easily manage group permissions. This doesn't seem to be working the way I understand it should, though: postgres=# CREATE ROLE

Re: Bogus temp file reporting?

Thanks for the clarification. Also, I was wrong about the temp_* columns in the pg_stat_database view in that they report the overall temp file usage since the last stats reset and not the “current” usage. Regards, Kiriakos Georgiou > On Jul 27, 2023, at 11:31 AM, Kyotaro Horiguchi >

Re: Bogus temp file reporting?

At Thu, 27 Jul 2023 10:30:41 +0300, kg.postgre...@olympiakos.com wrote in > Hello, > > Is there a known issue with temp file reporting? I have a > production db that is reporting 231TB of temp space usage, which > can’t be true. temp_blks_written in pg_stat_statements sort of > confirms this,

Re: How to improve the performance of my SQL query？

Thank you for your suggestion. The database is hosted on AWS RDS, with the instance having vCPU=2 and RAM=4GB. Could the low performance be due to the low configuration of AWS RDS? We are considering trying a higher configuration instance. At 2023-07-27 11:36:20, "David Rowley" wrote:

Bogus temp file reporting?

Hello, Is there a known issue with temp file reporting? I have a production db that is reporting 231TB of temp space usage, which can’t be true. temp_blks_written in pg_stat_statements sort of confirms this, as the reported queries show just a few MB of temp space usage. I suspect a reboot