Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mvfR0-0002pN-N8 for pgsql-admin@arkaria.postgresql.org; Fri, 10 Dec 2021 12:55:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mvfQz-0003F8-2Z for pgsql-admin@arkaria.postgresql.org; Fri, 10 Dec 2021 12:55:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mvfQy-0003Ey-IA for pgsql-admin@lists.postgresql.org; Fri, 10 Dec 2021 12:55:32 +0000 Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mvfQv-0003wF-IO for pgsql-admin@postgresql.org; Fri, 10 Dec 2021 12:55:32 +0000 Received: by mail-wm1-x32a.google.com with SMTP id 133so6791327wme.0 for ; Fri, 10 Dec 2021 04:55:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=iez/mN01biDF6jo1ag2Q1c7jHGyD844ipmuMBF3Jm94=; b=JJj902uZWN6jVesSJUN6QEQKOscee7XzTU7OHZ7x5CkVCXQLcec7u+e1J1UZC6TLk2 dDX2tYda216+kW7eQNofSMWfUsrsb/jG3NBSF7DB7LrkNkJ+n2B1UN3VVnS29oTNXG43 aX3dpyZhvNktFT974f5CKnT7Xl9dxc2r2oR19jDjHk8DSI+CW/1Xcr/vFfrr2EvCvTVg /bfk0UfX2S91l/UnK/CDQ4/z4P0KSdgOr9ngyBUb5h1aqBL0Ri3EAkd//IdkYBwxjUtl eE+vlyYa29b50okaNH+lYzQw0iH3mDdLDhhLjdxRPkXhIH+bXJ4V743DHw6n1GkmOXye eabg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=iez/mN01biDF6jo1ag2Q1c7jHGyD844ipmuMBF3Jm94=; b=a+2ArwrDf1DWbJX92mS7qH6yZOl5Aa0Goo7NFbPo4wz1XAK+OdnA+d2wfCOiTYTBmm DbreUlDnQ8YOH8DUdcZUjjK/K8CPGHoJ7QxGVHpLoIvHhsEwd5P6poLKOEoz4K1SD4gg FTnyxUq/e5MIeWs5n1nq39MdceaEgT60rlAOPtqCwAijIq/yPEGsi8D2dSBqKw3fM0e1 Jc/GM6Rob3AyxGui6o2+9hcm/Vxt0KFLdkcaLlPEbn4H97bamVBG1EYFI2uqD7hyRPtm Hsd5QFnf74Hqg+OM+wizsErcVCxR7Qfk15cMiktSryeQmurnPj4AnpFt4Il4F0yJGWFY K5kQ== X-Gm-Message-State: AOAM533yd9YyafOTjJKdLPQBDudyeyNkVdj2zZV5T8T3fVtqNLOTIeqq KyJOhLJYMoUodTLKLY+Y6/PrNQ== X-Google-Smtp-Source: ABdhPJxgcQKgfD8GQLLHHfMgkOd0LeGYmoFZv2XAuZdx9UOnk0ESinQClDTIjsvLcQykN3VU7bhx9Q== X-Received: by 2002:a05:600c:1548:: with SMTP id f8mr16327234wmg.67.1639140927282; Fri, 10 Dec 2021 04:55:27 -0800 (PST) Received: from localhost.localdomain (dynamic-edcj58i4di7rusf95-pd01.res.v6.highway.a1.net. [2001:871:5e:9b3f:f541:ed11:253b:5639]) by smtp.gmail.com with ESMTPSA id a9sm2565429wrt.66.2021.12.10.04.55.26 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 10 Dec 2021 04:55:27 -0800 (PST) Message-ID: <3b8d0a3fd990fc40a6d7d106e3521cc8c6e2af68.camel@cybertec.at> Subject: Re: Last login time From: Laurenz Albe To: abbas alizadeh , pgsql-admin Date: Fri, 10 Dec 2021 13:55:26 +0100 In-Reply-To: <7CD959B4-4EAC-4CB4-A59D-F43BD21C8D65@yahoo.com> References: <7CD959B4-4EAC-4CB4-A59D-F43BD21C8D65.ref@yahoo.com> <7CD959B4-4EAC-4CB4-A59D-F43BD21C8D65@yahoo.com> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2021-12-10 at 14:29 +0800, abbas alizadeh wrote: > Is there any way to get the last login time for each user in database > (I mean some table ir view not postgresql log file) There is no such facility in PostgreSQL. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com