Command line session and running queries

Hello,I've run an update query inside command line tool (psql) then I've exit the tool (closing the window). When I re-logged in, I've noticed in pg_stat_activity that my query was still running.I used the command pg_cancel_backend with the right PID, but it returned "f" few seconds later.I re-c

Re: upgrading from pg 9.3 to 10

Hi Stephen, thanks for the feedback, it is much appreciated! On Mon, Aug 20, 2018 at 12:15 PM Stephen Frost wrote: > * bricklen (brick...@gmail.com) wrote: > > Using pg_upgrade, it is definitely possible to upgrade 9.3 to 10 in one > > jump. We did this in production earlier this year for 1500 P

Re: Can Pg somehow recognize/honor linux groups to control user access ?

Joshua D. Drake writes: > On 08/22/2018 08:56 AM, David Gauthier wrote: >> Hi: >> >> The title says it all. I need to be control who can gain access to a >> DB based on a linux user group. I can set up a generic role and >> password, but also want to prevent users who are not in a specific >

Re: Can Pg somehow recognize/honor linux groups to control user access ?

On 08/22/2018 05:17 PM, Tim Cross wrote: > > I hope your not suggesting that multiple users use the same login > credentials to access the database? A database role is effectively a "shared account" with "shared password" so I'm not sure what your point is. It's just not a "computer login" shared

Re: Can Pg somehow recognize/honor linux groups to control user access ?

Dimitri Maziuk writes: > On 08/22/2018 11:38 AM, Ravi Krishna wrote: >> >> In fact DBAs don't even need to get involved when a new user needs DB >> access. Sysadmin had to just add that user in a group and we are done. > > How is that different from giving your grants to a database role and >

Re: Can Pg somehow recognize/honor linux groups to control user access ?

On 08/22/2018 12:54 PM, Ravi Krishna wrote: >> >> How is that different from giving your grants to a database role and >> just telling the new user the name and password of that role to connect as? > > Well here I have to do some work, with the groups approach, it is outsourced > to devops. Seco

Re: Can Pg somehow recognize/honor linux groups to control user access ?

On 08/22/2018 11:38 AM, Ravi Krishna wrote: > > In fact DBAs don't even need to get involved when a new user needs DB access. > Sysadmin had to just add that user in a group and we are done. How is that different from giving your grants to a database role and just telling the new user the name

Re: Can Pg somehow recognize/honor linux groups to control user access ?

On Wed, Aug 22, 2018 at 9:38 AM, Ravi Krishna wrote: > I am not sure this is the same what I was thinking about. For example, in > db2, connect privilege can be granted to a group and so is grant privilege > as in > GRANT SELECT ON TABLE SCHEMA.TABLE TO GROUP ABC; > GRANT CONNECT ON DATABASE TO

Re: Can Pg somehow recognize/honor linux groups to control user access ?

> On Aug 22, 2018, at 12:08 , David G. Johnston > wrote: > > On Wed, Aug 22, 2018 at 8:58 AM, Ravi Krishna > wrote: > AFAIK PG does not support it , as yet. IMO this should be implemented as a > priority. > > It does not support it natively, no. What it does su

Re: Can Pg somehow recognize/honor linux groups to control user access ?

On 08/22/2018 08:56 AM, David Gauthier wrote: Hi: The title says it all.  I need to be control who can gain access to a DB based on a linux user group.  I can set up a generic role and password, but also want to prevent users who are not in a specific linux group from accessing the DB.  For c

Re: Can Pg somehow recognize/honor linux groups to control user access ?

On Wed, Aug 22, 2018 at 8:58 AM, Ravi Krishna wrote: > AFAIK PG does not support it , as yet. IMO this should be implemented as a > priority. > It does not support it natively, no. What it does support is PAM which I'm led to believe (haven't used it myself) can be configured to accommodate thi

Re: Can Pg somehow recognize/honor linux groups to control user access ?

AFAIK PG does not support it , as yet. IMO this should be implemented as a priority.

Can Pg somehow recognize/honor linux groups to control user access ?

Hi: The title says it all. I need to be control who can gain access to a DB based on a linux user group. I can set up a generic role and password, but also want to prevent users who are not in a specific linux group from accessing the DB. For code that works with the DB, this is easy (just chmo

Re: "checkpointer process" is consuming more memory. How to control it?

22.08.2018 16:43, Raghavendra Rao J S V wrote: We have a database cluster as "db1_data". Under this cluster we have two databases. one is *db1 *and other is *qovr*. I surprised to see as "checkpointer process" is consuming 8.73GB of memory(RSS value as 9158892). Why "checkpointer process" is c

Re: "checkpointer process" is consuming more memory. How to control it?

On 08/22/2018 06:43 AM, Raghavendra Rao J S V wrote: Hi All, We have a database cluster as "db1_data". Under this cluster we have two databases. one is *db1 *and other is *qovr*. I surprised to see as "checkpointer process" is consuming 8.73GB of memory(RSS value as 9158892). Why "checkpointe

Re: Hungarian collation in English Windows server

Durumdara wrote: > CREATE DATABASE yyy > WITH > OWNER = xxx > ENCODING = 'UTF8' > LC_COLLATE = 'Hungarian_Hungary.1250' < > LC_CTYPE = 'Hungarian_Hungary.1250' < > > But we got error that collation doesn't exists in English Windows server. You have to install the col

Hungarian collation in English Windows server

Dear Members! One of the customer preinstalled a 9.6 PGSQL server for us. Today we tried to create and migrate our database. CREATE DATABASE yyy WITH OWNER = xxx ENCODING = 'UTF8' *LC_COLLATE = 'Hungarian_Hungary.1250' <* *LC_CTYPE = 'Hungarian_Hungary.1250' <* But