PgClu - Cronologia

Admin il 09:58, 12 giu 2023

2023-06-12T09:58:57Z

← Versione meno recente		Versione delle 09:58, 12 giu 2023
Riga 39:		Riga 39:

	For Postgres User:		For Postgres User:
	crontab -e
	@reboot /usr/local/bin/pgcluu_collectd -D -i 60 /var/lib/pgsql/log		crontab -e
	/5 /1 * * * /usr/local/bin/pgcluu -o /var/lib/pgsql/output /var/lib/pgsql/log/		@reboot /usr/local/bin/pgcluu_collectd -D -i 60 /var/lib/pgsql/log
			/5 /1 * * * /usr/local/bin/pgcluu -o /var/lib/pgsql/output /var/lib/pgsql/log/

	For Root User:		For Root User:

	yum install httpd -y		yum install httpd -y
	chkconfig httpd on		chkconfig httpd on
	service httpd start		service httpd start

	Da utente root:		Da utente root:

	crontab -e		crontab -e
	/6 /1 * * * mv /var/lib/pgsql/output/* /var/www/html/ -f ; chown apache:apache -R -f /var/www/html/		/6 /1 * * * mv /var/lib/pgsql/output/* /var/www/html/ -f ; chown apache:apache -R -f /var/www/html/

Admin il 09:58, 12 giu 2023

2023-06-12T09:58:12Z

← Versione meno recente		Versione delle 09:58, 12 giu 2023
Riga 17:		Riga 17:
	chown -R postgres:postgres /var/lib/pgsql/log		chown -R postgres:postgres /var/lib/pgsql/log
	chown -R postgres:postgres /var/lib/pgsql/output		chown -R postgres:postgres /var/lib/pgsql/output

			Da Postgres per raccogliere dati:

			pgcluu_collectd -D -i 60 /var/lib/pgsql/log (obbligatorio lancio da user postgres e directory di output accessibile a quest'ultimo).

			Da Remoto:

			pgcluu_collectd -D -i 60 /var/lib/pgsql/log -h 10.245.71.2 -U barman --password=orione -d postgres


			Per generare i report:

			Da utente postgres:

			/usr/local/bin/pgcluu -o /var/lib/pgsql/output /var/lib/pgsql/log/

			Opzioni: -o /var/lib/pgsql/output e' la cartella di output dei file che genera il tool di analyze, mentre /var/lib/pgsql/log/ è la cartella dei dati di pgcluu_collectd Per analizzare i dati non è necessario che il pgcluu_collectd sia running o non running è indifferente.


			Esempio di uso automatico di generazione report webserver locale:

			For Postgres User:
			crontab -e
			@reboot /usr/local/bin/pgcluu_collectd -D -i 60 /var/lib/pgsql/log
			/5 /1 * * * /usr/local/bin/pgcluu -o /var/lib/pgsql/output /var/lib/pgsql/log/

			For Root User:

			yum install httpd -y
			chkconfig httpd on
			service httpd start

			Da utente root:

			crontab -e
			/6 /1 * * * mv /var/lib/pgsql/output/* /var/www/html/ -f ; chown apache:apache -R -f /var/www/html/

Admin: Creata pagina con " cd /opt wget https://github.com/darold/pgcluu/archive/v2.6.tar.gz tar -xvzf v2.6.tar.gz cd pgcluu-2.6/ yum install perl -y yum install perl-ExtUtils* -y yum install sysstat -y #PATCH SI RINGRAZIA: MARIO GUIDI ln -s resources res # ------------------------- grazie --------- perl Makefile.PL make make install mkdir -p /var/lib/pgsql/log mkdir -p /var/lib/pgsql/output chown -R postgres:postgres /var/lib/pgsql/log chown -R postgres:postgres /var/lib/p..."

2023-06-12T08:42:59Z

Creata pagina con " cd /opt wget https://github.com/darold/pgcluu/archive/v2.6.tar.gz tar -xvzf v2.6.tar.gz cd pgcluu-2.6/ yum install perl -y yum install perl-ExtUtils* -y yum install sysstat -y #PATCH SI RINGRAZIA: MARIO GUIDI ln -s resources res # ------------------------- grazie --------- perl Makefile.PL make make install mkdir -p /var/lib/pgsql/log mkdir -p /var/lib/pgsql/output chown -R postgres:postgres /var/lib/pgsql/log chown -R postgres:postgres /var/lib/p..."

Nuova pagina

cd /opt
wget https://github.com/darold/pgcluu/archive/v2.6.tar.gz
tar -xvzf v2.6.tar.gz
cd pgcluu-2.6/
yum install perl -y
yum install perl-ExtUtils* -y
yum install sysstat -y

#PATCH SI RINGRAZIA: MARIO GUIDI
ln -s resources res
# ------------------------- grazie ---------
perl Makefile.PL
make
make install
mkdir -p /var/lib/pgsql/log
mkdir -p /var/lib/pgsql/output
chown -R postgres:postgres /var/lib/pgsql/log
chown -R postgres:postgres /var/lib/pgsql/output