Re: Maintenance solutions - Mailing list pgsql-novice
| From | Lætitia Avrot |
|---|---|
| Subject | Re: Maintenance solutions |
| Date | |
| Msg-id | CAB_COdi94GnJpO-4qEkV14EmVu1XGZGjebUNEgou+Tn9qED0_Q@mail.gmail.com Whole thread Raw |
| In response to | Re: Maintenance solutions (Brian Nielsen <brian@sqlpro.se>) |
| List | pgsql-novice |
Hi Brian,
You will find good scripts here:
- https://github.com/pgexperts/pgx_scripts
- https://github.com/dataegret/pg-utils
- https://wiki.postgresql.org/wiki/Index_Maintenance
For the backup, you have several tools in the community. The tool provided by PostgreSQL core is too raw IMHO. It focuses on backups and I'd rather have a way to restore my data than having a way to backup my data.
Here is a list of some open source backup tools:
- pg_basebackup (https://www.postgresql.org/docs/12/app-pgbasebackup.html)
- barman (https://www.pgbarman.org/)
- pgbackrest (https://pgbackrest.org/)
- probackup (https://postgrespro.com/products/extensions/pg_probackup)
I strongly advise not to develop your own scripts to perform backup and recovery, because there are so many ways this could go wrong...
Have a nice day,
Lætitia
You will find good scripts here:
- https://github.com/pgexperts/pgx_scripts
- https://github.com/dataegret/pg-utils
- https://wiki.postgresql.org/wiki/Index_Maintenance
For the backup, you have several tools in the community. The tool provided by PostgreSQL core is too raw IMHO. It focuses on backups and I'd rather have a way to restore my data than having a way to backup my data.
Here is a list of some open source backup tools:
- pg_basebackup (https://www.postgresql.org/docs/12/app-pgbasebackup.html)
- barman (https://www.pgbarman.org/)
- pgbackrest (https://pgbackrest.org/)
- probackup (https://postgrespro.com/products/extensions/pg_probackup)
I strongly advise not to develop your own scripts to perform backup and recovery, because there are so many ways this could go wrong...
Have a nice day,
Lætitia
Le mer. 15 janv. 2020 à 12:27, Brian Nielsen <brian@sqlpro.se> a écrit :
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ætitiaLe 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.
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.
Paper doesn’t grow on trees. Please print responsibly.
pgsql-novice by date: