Using PHPPgAdmin - Revision history

Pcy: fix typos

2019-11-10T21:24:07Z

fix typos

← Older revision		Revision as of 23:24, 10 November 2019
Line 1:		Line 1:
	You can access your PostgreSQL databases using PHPPgAdmin. This application can be found on https://phppgadmin.ulyssis.org. To login you need to use your PostgreSQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your PostgreSQL password you can get it from your ~~websites~~ configuration file. This is usually called config.php, wp-config.php, settings.php or something similar. You can change your database passwords through our control panel [https://ucc.ulyssis.org/ UCC], but keep in mind to then also change the password in relevant configuration files, or ~~you~~ applications may stop working correctly.		You can access your PostgreSQL databases using PHPPgAdmin. This application can be found on https://phppgadmin.ulyssis.org. To login you need to use your PostgreSQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your PostgreSQL password you can get it from your website's configuration file. This is usually called config.php, wp-config.php, settings.php or something similar. You can change your database passwords through our control panel [https://ucc.ulyssis.org/ UCC], but keep in mind to then also change the password in relevant configuration files, or your applications may stop working correctly.

	== Basic Usage ==		== Basic Usage ==

Bert: /* Making Backups */

2019-11-01T00:49:44Z

Making Backups

← Older revision		Revision as of 02:49, 1 November 2019
Line 7:		Line 7:
	== Making Backups ==		== Making Backups ==

	{{notice\|Keep in mind\|If you are backing up and/or restoring a larger database, it's advised to use command line tools since they are more performant than webtools and don't have any timeouts that could interrupt your backup/restore. Please refer to [[Making Backups]] for more details}}		{{notice\|Keep in mind\|If you are backing up and/or restoring a larger database, it's advised to use command line tools since they are more performant than webtools and don't have any timeouts that could interrupt your backup/restore. Please refer to [[Making Backups]] for more details.}}
	PHPPgAdmin has an export option which can be used to backup the structure and/or data of databases, schemas and tables, as well as more advanced features such as sequences and functions. When no database, schema or table has been selected, the export tab in the top menu allows to export all databases at the same time. When a specific database or table is selected, that database or table is exported. You can decide whether you wish to export the structure, the data or both, as well as the format and if DROPs need to be included. You can later restore backups by uploading the file through the form on the SQL page (top right corner). To make restoring easier, we suggest you backup individual databases or even individual tables and use the SQL format instead of COPY.		PHPPgAdmin has an export option which can be used to backup the structure and/or data of databases, schemas and tables, as well as more advanced features such as sequences and functions. When no database, schema or table has been selected, the export tab in the top menu allows to export all databases at the same time. When a specific database or table is selected, that database or table is exported. You can decide whether you wish to export the structure, the data or both, as well as the format and if DROPs need to be included. You can later restore backups by uploading the file through the form on the SQL page (top right corner). To make restoring easier, we suggest you backup individual databases or even individual tables and use the SQL format instead of COPY.

	[[Category:Databases]]		[[Category:Databases]]

Bert: /* Making Backups */

2019-11-01T00:49:03Z

Making Backups

← Older revision		Revision as of 02:49, 1 November 2019
Line 7:		Line 7:
	== Making Backups ==		== Making Backups ==

			{{notice\|Keep in mind\|If you are backing up and/or restoring a larger database, it's advised to use command line tools since they are more performant than webtools and don't have any timeouts that could interrupt your backup/restore. Please refer to [[Making Backups]] for more details}}
	PHPPgAdmin has an export option which can be used to backup the structure and/or data of databases, schemas and tables, as well as more advanced features such as sequences and functions. When no database, schema or table has been selected, the export tab in the top menu allows to export all databases at the same time. When a specific database or table is selected, that database or table is exported. You can decide whether you wish to export the structure, the data or both, as well as the format and if DROPs need to be included. You can later restore backups by uploading the file through the form on the SQL page (top right corner). To make restoring easier, we suggest you backup individual databases or even individual tables and use the SQL format instead of COPY.		PHPPgAdmin has an export option which can be used to backup the structure and/or data of databases, schemas and tables, as well as more advanced features such as sequences and functions. When no database, schema or table has been selected, the export tab in the top menu allows to export all databases at the same time. When a specific database or table is selected, that database or table is exported. You can decide whether you wish to export the structure, the data or both, as well as the format and if DROPs need to be included. You can later restore backups by uploading the file through the form on the SQL page (top right corner). To make restoring easier, we suggest you backup individual databases or even individual tables and use the SQL format instead of COPY.

	[[Category:Databases]]		[[Category:Databases]]

Bert at 02:57, 11 September 2019

2019-09-11T02:57:20Z

← Older revision		Revision as of 04:57, 11 September 2019
Line 1:		Line 1:
	You can access your PostgreSQL databases using PHPPgAdmin. This application can be found on https://phppgadmin.ulyssis.org. To login you need to use your PostgreSQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your PostgreSQL password you can get it from your websites configuration file. This is usually called config.php, wp-config.php, settings.php or something similar.		You can access your PostgreSQL databases using PHPPgAdmin. This application can be found on https://phppgadmin.ulyssis.org. To login you need to use your PostgreSQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your PostgreSQL password you can get it from your websites configuration file. This is usually called config.php, wp-config.php, settings.php or something similar. You can change your database passwords through our control panel [https://ucc.ulyssis.org/ UCC], but keep in mind to then also change the password in relevant configuration files, or you applications may stop working correctly.

	== Basic Usage ==		== Basic Usage ==

Bert: /* Making Backups */

2019-09-11T02:10:37Z

Making Backups

← Older revision		Revision as of 04:10, 11 September 2019
Line 7:		Line 7:
	== Making Backups ==		== Making Backups ==

	~~To take a~~ backup of all ~~your~~ databases ~~you simply select "Export" on~~ the ~~main menu~~, ~~define~~ whether you wish to export data~~, structure~~ or both, and ~~press export~~. You can later restore backups by uploading the file to the "SQL" page. To make restoring easier, we suggest ~~however~~ you backup individual databases or even individual tables and use the SQL format instead of COPY.		PHPPgAdmin has an export option which can be used to backup the structure and/or data of databases, schemas and tables, as well as more advanced features such as sequences and functions. When no database, schema or table has been selected, the export tab in the top menu allows to export all databases at the same time. When a specific database or table is selected, that database or table is exported. You can decide whether you wish to export the structure, the data or both, as well as the format and if DROPs need to be included. You can later restore backups by uploading the file through the form on the SQL page (top right corner). To make restoring easier, we suggest you backup individual databases or even individual tables and use the SQL format instead of COPY.

	[[Category:Databases]]		[[Category:Databases]]

Bert at 14:12, 10 September 2019

2019-09-10T14:12:52Z

← Older revision		Revision as of 16:12, 10 September 2019
Line 5:		Line 5:
	You can login by clicking on the only server in the left sidebar ''PostgreSQL voor gebruikers, kringen en organisaties''. Once you've logged in, you will see an overview of all your databases. You can then view databases, schemas and tables by clicking on them or navigating through the sidebar. For each table you can view the records, view and change the structure, add records, take backups, etc. Official documentation of all functionality is sadly lacking, but you can still refer to [http://phppgadmin.sourceforge.net/doku.php?id=faq_docs the official documentation]		You can login by clicking on the only server in the left sidebar ''PostgreSQL voor gebruikers, kringen en organisaties''. Once you've logged in, you will see an overview of all your databases. You can then view databases, schemas and tables by clicking on them or navigating through the sidebar. For each table you can view the records, view and change the structure, add records, take backups, etc. Official documentation of all functionality is sadly lacking, but you can still refer to [http://phppgadmin.sourceforge.net/doku.php?id=faq_docs the official documentation]

	== ~~Taking~~ Backups ==		== Making Backups ==

	To take a backup of all your databases you simply select "Export" on the main menu, define whether you wish to export data, structure or both, and press export. You can later restore backups by uploading the file to the "SQL" page. To make restoring easier, we suggest however you backup individual databases or even individual tables and use the SQL format instead of COPY.		To take a backup of all your databases you simply select "Export" on the main menu, define whether you wish to export data, structure or both, and press export. You can later restore backups by uploading the file to the "SQL" page. To make restoring easier, we suggest however you backup individual databases or even individual tables and use the SQL format instead of COPY.

	[[Category:Databases]]		[[Category:Databases]]

Yoa: /* Taking Backups */

2019-09-09T21:03:06Z

Taking Backups

← Older revision		Revision as of 23:03, 9 September 2019
Line 7:		Line 7:
	== Taking Backups ==		== Taking Backups ==

	To take a backup of all your databases you ~~simple~~ select "Export" on the main menu, define whether you wish to export data, structure or both, and press export. You can later restore backups by uploading the file to the "SQL" page. To make restoring easier, we suggest however you backup individual databases or even individual tables and use the SQL format instead of COPY.		To take a backup of all your databases you simply select "Export" on the main menu, define whether you wish to export data, structure or both, and press export. You can later restore backups by uploading the file to the "SQL" page. To make restoring easier, we suggest however you backup individual databases or even individual tables and use the SQL format instead of COPY.

	[[Category:Databases]]		[[Category:Databases]]

Bert: Created page with "You can access your PostgreSQL databases using PHPPgAdmin. This application can be found on https://phppgadmin.ulyssis.org. To login you need to use your PostgreSQL password,..."

2019-09-09T15:46:18Z

Created page with "You can access your PostgreSQL databases using PHPPgAdmin. This application can be found on https://phppgadmin.ulyssis.org. To login you need to use your PostgreSQL password,..."

New page

You can access your PostgreSQL databases using PHPPgAdmin. This application can be found on https://phppgadmin.ulyssis.org. To login you need to use your PostgreSQL password, this password is different from your account password for security reasons as well as convenience. In case you've forgotten your PostgreSQL password you can get it from your websites configuration file. This is usually called config.php, wp-config.php, settings.php or something similar.

== Basic Usage ==

You can login by clicking on the only server in the left sidebar ''PostgreSQL voor gebruikers, kringen en organisaties''. Once you've logged in, you will see an overview of all your databases. You can then view databases, schemas and tables by clicking on them or navigating through the sidebar. For each table you can view the records, view and change the structure, add records, take backups, etc. Official documentation of all functionality is sadly lacking, but you can still refer to [http://phppgadmin.sourceforge.net/doku.php?id=faq_docs the official documentation]

== Taking Backups ==

To take a backup of all your databases you simple select "Export" on the main menu, define whether you wish to export data, structure or both, and press export. You can later restore backups by uploading the file to the "SQL" page. To make restoring easier, we suggest however you backup individual databases or even individual tables and use the SQL format instead of COPY.

[[Category:Databases]]