Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iriHL-0005nc-8w for pgsql-novice@arkaria.postgresql.org; Wed, 15 Jan 2020 13:00:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iriHI-0007Z6-T2 for pgsql-novice@arkaria.postgresql.org; Wed, 15 Jan 2020 13:00:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iriHI-0007Rd-Bk for pgsql-novice@lists.postgresql.org; Wed, 15 Jan 2020 13:00:08 +0000 Received: from mx4.wp.pl ([212.77.101.12]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iriH8-00015R-Si for pgsql-novice@lists.postgresql.org; Wed, 15 Jan 2020 13:00:05 +0000 Received: (wp-smtpd smtp.wp.pl 12757 invoked from network); 15 Jan 2020 13:59:55 +0100 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wp.pl; s=1024a; t=1579093195; bh=uAqHWZvhjboU30hM8w2nt/BUULxlF0WvCrUlbl01m/0=; h=Subject:To:From; b=Cxn48/Vgut9nRegFq4Z098Jhx3vENXe+/UIofpmoDdCQnquBaC20kT8waKkKGdEmO LEqaDFYsxpw5uoKtd3yMwR9WKGIXXeViMCL47MoehgHGaOD6DHuNvsSOaSbEfUEeHl sdaXupv2yVA5cTfZgYPE/OXvKxjpSllEWa9S3Wj0= Received: from 78-11-36-98.cmr.net.pl (HELO [192.168.1.226]) (ipluta@wp.pl@[78.11.36.98]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with ECDHE-RSA-AES256-GCM-SHA384 encrypted SMTP for ; 15 Jan 2020 13:59:55 +0100 Subject: Re: Maintenance solutions To: brian@sqlpro.se, pgsql-novice@lists.postgresql.org References: <2f20111a27716a6236e7eaf0a25d8125@sqlpro.se> From: "Ireneusz Pluta/wp.pl" Message-ID: Date: Wed, 15 Jan 2020 13:59:51 +0100 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:68.0) Gecko/20100101 Thunderbird/68.4.1 MIME-Version: 1.0 In-Reply-To: <2f20111a27716a6236e7eaf0a25d8125@sqlpro.se> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: pl X-WP-MailID: 6e64b40b2cb8acf8772c732557ac4c51 X-WP-AV: skaner antywirusowy Poczty Wirtualnej Polski X-WP-SPAM: NO 0000009 [wOOk] List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk W dniu 2020-01-15 o 10:19, Brian Nielsen pisze: > Im currently an MSSQL DBA and have been for soon 2 decades. However, Im very curious about > PostgreSQL and want to learn more. I have installed it etc but coming from MSSQL where the > community is awesome I fail to find a good community for PG where I can ask these questions. Im > used to free scriptpackages on MSSQL like Ola Hallengrens backup solution or Adam Machanics > sp_whoisactive/Brent Ozar sp_blitz. > > Im guessing (and hoping) that any such tools/scripts are available for PG but I fail to find it. > Can anyone point me to either a nice tool like the ones mentioned above or a PG community that can > help me out, or even better, to both? > Hi Brian, maybe it is not a right anwer to your particular question, but as far as "tooling" is concerned, you as an MSSQL guy might be interested in reading the following blog post https://rob.conery.io/2019/03/04/postgresql-tools-for-the-visually-inclined/ and some other ones linked from there.