script libraries?

čt 30. 4. 2020 v 15:54 odesílatel Chris Stephens <cstephens16@gmail.com>
napsal:

as another Oracle DBA trying to pick up Postgresql one thing i haven't
come across are script libraries such as there are for Oracle (
https://github.com/tanelpoder/tpt-oracle and
https://oracle-base.com/dba/scripts as examples).

Does anything like that exist for PG? Would be nice to see how people
navigate through PG on the command line.

There is not too much - Postgres is significantly compact and needs less
admin work

There are some query set's

https://github.com/gsusrafael/postgres-psql-for-dba
https://github.com/NikolayS/postgres_dba
https://wiki.postgresql.org/wiki/Category:Performance_Snippets
https://wiki.postgresql.org/wiki/Category:Snippets

Regards

Pavel

Chris Stephens schrieb am 30.04.2020 um 15:54:

as another Oracle DBA trying to pick up Postgresql one thing i
haven't come across are script libraries such as there are for Oracle
(https://github.com/tanelpoder/tpt-oracle and
https://oracle-base.com/dba/scripts as examples).

Does anything like that exist for PG? Would be nice to see how people
navigate through PG on the command line.

The Postgres Wiki has some scripts:

https://wiki.postgresql.org/wiki/Category:Snippets

Then there is a collection from pgExperets:

https://github.com/pgexperts/pgx_scripts