PhpPgAdmin - Revision history

Sertonix: replace /etc/init.d with rc-service

2023-11-17T09:43:42Z

replace /etc/init.d with rc-service

← Older revision		Revision as of 09:43, 17 November 2023
Line 9:		Line 9:
	== Configuring postgresql ==		== Configuring postgresql ==

	{{Cmd\|~~/etc/init.d/~~postgresql setup}}		{{Cmd\|rc-service postgresql setup}}

	Starting http service and adding to boot.		Starting http service and adding to boot.

	{{Cmd\|~~/etc/init.d/~~postgresql start && rc-update add postgresql default}}		{{Cmd\|rc-service postgresql start && rc-update add postgresql default}}

	== Installing phpPgAdmin ==		== Installing phpPgAdmin ==

Sertonix: use https where possible

2023-08-07T11:11:53Z

use https where possible

← Older revision		Revision as of 11:11, 7 August 2023
Line 1:		Line 1:
	[~~http~~://phppgadmin.sourceforge.net/doku.php phpPgAdmin] is a web-based administration tool for PostgreSQL.		[https://phppgadmin.sourceforge.net/doku.php phpPgAdmin] is a web-based administration tool for PostgreSQL.

	== Install lighttpd, PHP, and postgresql ==		== Install lighttpd, PHP, and postgresql ==
Line 24:		Line 24:

	{{Cmd\|cd /usr/share/webapps/		{{Cmd\|cd /usr/share/webapps/
	wget ~~http~~://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.4.tar.gz}}		wget https://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.4.tar.gz}}

	Unpack and delete the tar file		Unpack and delete the tar file

Zcrayfish: Removed hyperlinks to hypothetical URLs.

2021-12-20T22:24:42Z

Removed hyperlinks to hypothetical URLs.

← Older revision		Revision as of 22:24, 20 December 2021
Line 49:		Line 49:
	== Log on your phpPgAdmin ==		== Log on your phpPgAdmin ==

	Browse to: http://WEBSERVER_IP_ADDRESS/phppgadmin and logon to phpPgAdmin using postgresql user and password.		Browse to: <nowiki>http://WEBSERVER_IP_ADDRESS/phppgadmin</nowiki> and logon to phpPgAdmin using postgresql user and password.

	{{Note\|If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set.		{{Note\|If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set.
	e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin }}		e.g: if you set the port to 8080, then browse to: <nowiki>http://WEBSERVER_IP_ADDRESS:8080/phppgadmin</nowiki> }}

	[[Category:PHP]]		[[Category:PHP]]
	[[Category:SQL]]		[[Category:SQL]]

Fab: /* Installing phpPgAdmin */

2013-01-22T13:18:32Z

Installing phpPgAdmin

← Older revision		Revision as of 13:18, 22 January 2013
Line 17:		Line 17:
	== Installing phpPgAdmin ==		== Installing phpPgAdmin ==

	~~Make ''~~webapps~~'' folder~~		Create a directory named {{Path\|webapps}}

	{{Cmd\|mkdir -p /usr/share/webapps/}}		{{Cmd\|mkdir -p /usr/share/webapps/}}
Line 26:		Line 26:
	wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.4.tar.gz}}		wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.4.tar.gz}}

	Unpack and delete tar file		Unpack and delete the tar file

	{{Cmd\|tar zxvf phpPgAdmin-5.0.2.tar.gz		{{Cmd\|tar zxvf phpPgAdmin-5.0.2.tar.gz
	rm phpPgAdmin-5.0.4.tar.gz}}		rm phpPgAdmin-5.0.4.tar.gz}}

	Change folder name		Change the folder name

	{{Cmd\|mv phpPgAdmin-5.0.4 phppgadmin}}		{{Cmd\|mv phpPgAdmin-5.0.4 phppgadmin}}
Line 39:		Line 39:
	{{Cmd\|cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php}}		{{Cmd\|cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php}}

	Change folder permissions		Change the folder permissions

	{{Cmd\|chmod -R 777 /usr/share/webapps/}}		{{Cmd\|chmod -R 777 /usr/share/webapps/}}

	~~Make~~ symlink to the phpPgAdmin folder		Create a symlink to the {{Path\|phpPgAdmin}} folder

	{{Cmd\|ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin}}		{{Cmd\|ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin}}

Danieloc: /* Installing phpPgAdmin */

2012-03-29T14:11:53Z

Installing phpPgAdmin

← Older revision		Revision as of 14:11, 29 March 2012
Line 24:		Line 24:

	{{Cmd\|cd /usr/share/webapps/		{{Cmd\|cd /usr/share/webapps/
	wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.2.tar.gz}}		wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.4.tar.gz}}

	Unpack and delete tar file		Unpack and delete tar file

	{{Cmd\|tar zxvf phpPgAdmin-5.0.2.tar.gz		{{Cmd\|tar zxvf phpPgAdmin-5.0.2.tar.gz
	rm phpPgAdmin-5.0.2.tar.gz}}		rm phpPgAdmin-5.0.4.tar.gz}}

	Change folder name		Change folder name

	{{Cmd\|mv phpPgAdmin-5.0.2 phppgadmin}}		{{Cmd\|mv phpPgAdmin-5.0.4 phppgadmin}}

	Copy the sample config file name		Copy the sample config file name

Dubiousjim: Category:SQL

2012-03-25T07:25:13Z

Category:SQL

← Older revision		Revision as of 07:25, 25 March 2012
Line 55:		Line 55:

	[[Category:PHP]]		[[Category:PHP]]
			[[Category:SQL]]

Dubiousjim: Category:PHP

2012-03-12T08:09:29Z

Category:PHP

← Older revision		Revision as of 08:09, 12 March 2012
Line 53:		Line 53:
	{{Note\|If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set.		{{Note\|If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set.
	e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin }}		e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin }}

			[[Category:PHP]]

Fab at 09:14, 28 August 2011

2011-08-28T09:14:53Z

← Older revision		Revision as of 09:14, 28 August 2011
Line 1:		Line 1:
	~~== What is phpPgAdmin? ==~~

	[http://phppgadmin.sourceforge.net/doku.php phpPgAdmin] is a web-based administration tool for PostgreSQL.		[http://phppgadmin.sourceforge.net/doku.php phpPgAdmin] is a web-based administration tool for PostgreSQL.

Line 13:		Line 11:
	{{Cmd\|/etc/init.d/postgresql setup}}		{{Cmd\|/etc/init.d/postgresql setup}}

	~~'''~~Starting http service and adding to boot~~'''~~		Starting http service and adding to boot.

	{{Cmd\|/etc/init.d/postgresql start && rc-update add postgresql default}}		{{Cmd\|/etc/init.d/postgresql start && rc-update add postgresql default}}
Line 23:		Line 21:
	{{Cmd\|mkdir -p /usr/share/webapps/}}		{{Cmd\|mkdir -p /usr/share/webapps/}}

	Download		Download the latest release of phpPgAdmin.

	{{Cmd\|cd /usr/share/webapps/		{{Cmd\|cd /usr/share/webapps/
Line 33:		Line 31:
	rm phpPgAdmin-5.0.2.tar.gz}}		rm phpPgAdmin-5.0.2.tar.gz}}

	Change ~~Folder Name~~		Change folder name

	{{Cmd\|mv phpPgAdmin-5.0.2 phppgadmin}}		{{Cmd\|mv phpPgAdmin-5.0.2 phppgadmin}}

Fab: update

2011-08-28T09:13:47Z

update

← Older revision		Revision as of 09:13, 28 August 2011
Line 1:		Line 1:
	== What is phpPgAdmin? ==		== What is phpPgAdmin? ==

	phpPgAdmin is a web-based administration tool for PostgreSQL~~. It is perfect for PostgreSQL DBAs, newbies and hosting services~~.		[http://phppgadmin.sourceforge.net/doku.php phpPgAdmin] is a web-based administration tool for PostgreSQL.

	~~== Set up phpPgAdmin on Alpine Linux ==~~		== Install lighttpd, PHP, and postgresql ==

	~~This document will be a very quick c/p guide to setup phpPgAdmin on Alpine linux. What we will setup is the following:~~

	* Lighttpd with PHP
	* postgresql
	* [http://phppgadmin.sourceforge.net/doku.php?id=start phpPgAdmin]

	== Install lighttpd, PHP and postgresql ==
	{{:Setting Up Lighttpd With FastCGI}}		{{:Setting Up Lighttpd With FastCGI}}

Line 27:		Line 19:
	== Installing phpPgAdmin ==		== Installing phpPgAdmin ==

	''~~'Install phpPgAdmin'~~''		Make ''webapps'' folder

	~~Make webapps~~ folder

	{{Cmd\|mkdir /usr/share/webapps/ -p}}		{{Cmd\|mkdir -p /usr/share/webapps/}}

	Download		Download

	{{Cmd\|cd /usr/share/webapps/		{{Cmd\|cd /usr/share/webapps/
	wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-4.2.3.tar.gz}}		wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.2.tar.gz}}

	Unpack and delete tar file		Unpack and delete tar file

	{{Cmd\|tar zxvf phpPgAdmin-4.2.3.tar.gz		{{Cmd\|tar zxvf phpPgAdmin-5.0.2.tar.gz
	rm phpPgAdmin-4.2.3.tar.gz}}		rm phpPgAdmin-5.0.2.tar.gz}}

	Change Folder Name		Change Folder Name

	{{Cmd\|mv phpPgAdmin-4.2.3 phppgadmin}}		{{Cmd\|mv phpPgAdmin-5.0.2 phppgadmin}}

	~~Change Config File Name~~		Copy the sample config file name

	{{Cmd\|cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php}}		{{Cmd\|cp /usr/share/webapps/phppgadmin/conf/config.inc.php-dist /usr/share/webapps/phppgadmin/conf/config.inc.php}}

	Change ~~Folder Persmissions~~		Change folder permissions

	{{Cmd\|chmod -R 777 /usr/share/webapps/}}		{{Cmd\|chmod -R 777 /usr/share/webapps/}}

	Make ~~Symlink~~ to the phpPgAdmin folder		Make symlink to the phpPgAdmin folder

	{{Cmd\|ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin}}		{{Cmd\|ln -s /usr/share/webapps/phppgadmin/ /var/www/localhost/htdocs/phppgadmin}}
Line 62:		Line 52:

	Browse to: http://WEBSERVER_IP_ADDRESS/phppgadmin and logon to phpPgAdmin using postgresql user and password.		Browse to: http://WEBSERVER_IP_ADDRESS/phppgadmin and logon to phpPgAdmin using postgresql user and password.
	~~And enjoy this nice and useful tool.~~

	~~'''~~Note~~:'''~~ If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set.		{{Note\|If you are using the Alpine ACF, or if you change the port in the lighttpd.conf file, the go to the port you set.
	e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin		e.g: if you set the port to 8080, then browse to: http://WEBSERVER_IP_ADDRESS:8080/phppgadmin }}

Fab: /* Set up phpPgAdmin on Alpine Linux */ link added

2011-08-27T14:18:26Z

Set up phpPgAdmin on Alpine Linux: link added

← Older revision		Revision as of 14:18, 27 August 2011
Line 9:		Line 9:
	* Lighttpd with PHP		* Lighttpd with PHP
	* postgresql		* postgresql
	* phpPgAdmin		* [http://phppgadmin.sourceforge.net/doku.php?id=start phpPgAdmin]

	== Install lighttpd, PHP and postgresql ==		== Install lighttpd, PHP and postgresql ==