Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-21 Thread Saksham Joshi
Hi David, We have tried granting it with our admin user also but no avail. On Mon, 22 Apr 2024, 10:50 David G. Johnston, wrote: > On Sunday, April 21, 2024, Saksham Joshi wrote: > >> Hi, >> I am afraid that's not the case with postgresql 16 since we also tested >&

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-21 Thread Saksham Joshi
error message 'permission denied to grant role "pg_signal_backend".Also,In postgre 16 only the current users of the database are able to close the connections.Can you help on this please? On Fri, 19 Apr 2024, 19:50 Adrian Klaver, wrote: > On 4/18/24 22:48, Saksham Joshi wrote: >

Not able to grant access on pg_signal_backend on azure flexible server

2024-04-18 Thread Saksham Joshi
Hi, We have created an azure postgresql flexible server and we have added an ad admin as a user and Created our database using this admin user.However,When are running this command: 'Grant pg_signal_backend To adminUser' we are getting an error that says 'permission denied to grant role "pg_signal_

Getting wrong datetime in database using insert into table query.

2024-04-02 Thread Saksham Joshi
OS: Windows 10 Psycopg version: 2.9.9 Python version: 3.11.6 PostgreSQL version: 11 pip version : 24.0 1: what you did We are using 'psycopg2-binary' library to connect to my postgresql hosted on Azure.We have created a table named 'apilog' to store our api logs using 'Insert Into table' query.We h