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 1irgpM-00027d-A0 for pgsql-novice@arkaria.postgresql.org; Wed, 15 Jan 2020 11:27:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1irgpK-0002At-88 for pgsql-novice@arkaria.postgresql.org; Wed, 15 Jan 2020 11:27:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1irgpJ-0002Al-P7 for pgsql-novice@lists.postgresql.org; Wed, 15 Jan 2020 11:27:10 +0000 Received: from mailout7.inleed.net ([2a0b:dc80:cafe:107::1] helo=ns7.inleed.net) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1irgpE-00044m-A1 for pgsql-novice@lists.postgresql.org; Wed, 15 Jan 2020 11:27:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=sqlpro.se; s=x; h=Message-ID:References:In-Reply-To:Reply-To:Subject:Cc:To:From:Date: Content-Type:MIME-Version:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=KSTNpBHTSZ/YUTnJ9n+DmezQB1cYo6vvcBrBlzS8NkY=; b=aymcyMOyNzwaMIccxn2X7V4WWk T0P9yeLcIl+zaNnk+jc9WGpN/8KtX+31trR4/hZBpPywciGFG87cJjavsJWfN8HZl7DmxE9YVgFOi gpAyB1/V/8lPnaJ7UnD+P3UWNGhfnDcY1tQOL0f3aR2rhgyatlDS5eZzmwhu5DWiWnA67PJ8WDdT2 p0fvySbfRFNrQFgUYY/eoYbUOAMGL8sKWw7TpuLHQsLeA/YtM0kvDEKNMhVlxN25TtdiYnvJFFRpQ FtP+3apQ87NK1XxD6yhTaHneOXgFnyug7OpqXTO5/gpSH/8nfYnGoK46GYiPNJafFWgb7pyrRiqjf JQ3blDsw==; Received: from [127.0.0.1] (helo=ns7.inleed.net) by ns7.inleed.net with esmtpa (Exim 4.92.3) (envelope-from ) id 1irgp9-00CoGk-Se; Wed, 15 Jan 2020 12:26:59 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_358df59307903f6e6e922d6597fd5dcd" Date: Wed, 15 Jan 2020 12:26:58 +0100 From: Brian Nielsen To: =?UTF-8?Q?L=C3=A6titia_Avrot?= Cc: pgsql-novice@lists.postgresql.org Subject: Re: Maintenance solutions Reply-To: brian@sqlpro.se In-Reply-To: References: <2f20111a27716a6236e7eaf0a25d8125@sqlpro.se> User-Agent: Roundcube Webmail/1.4.2 Message-ID: X-Sender: brian@sqlpro.se X-Authenticated-Id: brian List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_358df59307903f6e6e922d6597fd5dcd Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=UTF-8; format=flowed Hi! Thanks for you answer. I have now joined Slack (used it before). Which backup-scripts and indexmaintenance-scripts are you guys using in your prod-environments? Kind regards, Brian 2020-01-15 10:28 skrev Lætitia Avrot: > Hi Brian, > > Welcome to Postgres community! > If you want to interact with the community, this mailing list is a great starting point. However, if you'd rather have more interactivity, may I suggest: > > * IRC (https://www.postgresql.org/community/irc/) > * Slack (https://postgres-slack.herokuapp.com/) > * Telegram (https://tgram.io/group/2290/pg_sql) > * Twitter (a lot of people watch the #PostgreSQL hashtag, just ask your question and you should have answers) > * Events (IRL meeting with community is so great, you'l find a list of local user groups and community events all around the world here: https://www.postgresql.org/community/ > > About free scripts and tool, you will find so many of them that your main problem will be to choose the one you want to choose from :-D > > Have a nice day, > > Lætitia > > Le mer. 15 janv. 2020 à 10:19, Brian Nielsen a écrit : > >> Hi! >> >> First post here for me. I wrote the question below on StackOverflow but >> it wasnt allowed and I was directed to these mailinglists. >> >> From Stack: >> ------ >> 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? >> ------ >> >> Big thanks in advance! >> >> Kind regards, >> Brian > > -- > > _Paper doesn't grow on trees. Please print responsibly._ --=_358df59307903f6e6e922d6597fd5dcd Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=UTF-8

Hi!

Thanks for you answer. I have now joined Slack (used it before). 

Which backup-scripts and indexmaintenance-scripts are you guys using in = your prod-environments?

Kind regards,

Brian

2020-01-15 10:28 skrev Lætitia Avrot:

Hi Brian,

Welcome to Postgres community!
If you want to interact with the community, this mailing list is a gre= at starting point. However, if you'd rather have more interactivity, may I = suggest:
About free scripts and tool, you will find so many of them that your m= ain problem will be to choose the one you want to choose from :-D

Have a nice day,

Lætitia





Le mer. 15 janv. 2020 à=  10:19, Brian Nielsen <brian@sqlpro.se> a écrit :
Hi!

First post = here for me. I wrote the question below on StackOverflow but
it wasnt= allowed and I was directed to these mailinglists.


 F= rom Stack:
------
Im currently an MSSQL DBA and have been for soo= n 2 decades. However, Im
very curious about PostgreSQL and want to le= arn more. I have installed
it etc but coming from MSSQL where the com= munity 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 O= zar sp_blitz.

Im guessing (and hoping) that any such tools/scrip= ts 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 t= hat can help me out, or even
better, to both?
------

= Big thanks in advance!

Kind regards,
Brian



 
--
Paper doesn't grow on trees. Please print responsibly= =2E


--=_358df59307903f6e6e922d6597fd5dcd--