Postgresql - Revision history

Nicolas at 22:00, 2 March 2025

2025-03-02T22:00:28Z

@@ Line 3: / Line 3: @@
 ==== Authorize external connection ====
 ** Modify /etc/postgresql/12/main/postgresql.conf
-<pre>listen_addresses = '*'</pre>
+<pre>listen_addresses = '0.0.0.0/0'</pre>
 ** Modify /etc/postgresql/12/main/pg_hba.conf
 <pre>host all all 0.0.0.0/0 md5</pre>
 ==== Change postgres password ====
@@ Line 22: / Line 25: @@
 ** List users
 <pre>select rolname,rolsuper,rolcanlogin FROM pg_roles; </pre>
 === PgAdmin4===

Nicolas at 17:15, 17 April 2022

2022-04-17T17:15:52Z

← Older revision		Revision as of 17:15, 17 April 2022
Line 14:		Line 14:

	=== Manage User ===		=== Manage User ===
	** Create ~~Super User~~		** Create user with login
	<pre>CREATE ~~USER~~ username WITH LOGIN ~~SUPERUSER~~ PASSWORD '~~thesecret~~';</pre>		<pre>CREATE ROLE username WITH LOGIN PASSWORD 'mysecret';</pre>

			** Provide Superuser to a user
			<pre>ALTER ROLE username SUPERUSER </pre>

			** List users
			<pre>select rolname,rolsuper,rolcanlogin FROM pg_roles; </pre>
	=== PgAdmin4===		=== PgAdmin4===

Nicolas at 16:42, 17 April 2022

2022-04-17T16:42:20Z

← Older revision		Revision as of 16:42, 17 April 2022
Line 1:		Line 1:
	=== Postgresql ===		=== Postgresql ===


	==== Authorize external connection ====		==== Authorize external connection ====
Line 13:		Line 12:
	then		then
	<pre>\password postgres</pre>		<pre>\password postgres</pre>

			=== Manage User ===
			** Create Super User
			<pre>CREATE USER username WITH LOGIN SUPERUSER PASSWORD 'thesecret';</pre>


	=== PgAdmin4===		=== PgAdmin4===

Nicolas: /* PgAdmin4 */

2020-10-07T23:24:27Z

PgAdmin4

← Older revision		Revision as of 23:24, 7 October 2020
Line 22:		Line 22:
	* Clear /var/lib/pgamdin folder		* Clear /var/lib/pgamdin folder
	* Reconfigure the web interface		* Reconfigure the web interface
	<pre> dpkg-reconfigure pgamin4-~~apache~~ </pre>		<pre> dpkg-reconfigure pgamin4-apache2 </pre>

Nicolas at 21:16, 8 August 2020

2020-08-08T21:16:01Z

← Older revision		Revision as of 21:16, 8 August 2020
Line 1:		Line 1:
			=== Postgresql ===


			==== Authorize external connection ====
			** Modify /etc/postgresql/12/main/postgresql.conf
			<pre>listen_addresses = '*'</pre>

			** Modify /etc/postgresql/12/main/pg_hba.conf
			<pre>host all all 0.0.0.0/0 md5</pre>

			==== Change postgres password ====
			<pre>sudo -u postgres psql</pre>
			then
			<pre>\password postgres</pre>

	=== PgAdmin4===		=== PgAdmin4===

Nicolas: /* PgAdmin4 */

2020-08-08T20:24:38Z

PgAdmin4

← Older revision		Revision as of 20:24, 8 August 2020
Line 2:		Line 2:

	==== Url ====		==== Url ====
	[http://localhost/pgadmin4]		[http://localhost/pgadmin4 http://localhost/pgadmin4]

	==== Reset Web Password ====		==== Reset Web Password ====
	* Clear /var/lib/pgamdin folder		* Clear /var/lib/pgamdin folder
	* Reconfigure the web interface		* Reconfigure the web interface
	<pre> dpkg-reconfigure pgamin4-apache </pre>		<pre> dpkg-reconfigure pgamin4-apache </pre>

Nicolas: /* PgAdmin4 */

2020-08-08T20:24:00Z

PgAdmin4

← Older revision		Revision as of 20:24, 8 August 2020
Line 1:		Line 1:
	=== PgAdmin4===		=== PgAdmin4===

			==== Url ====
			[http://localhost/pgadmin4]
	==== Reset Web Password ====		==== Reset Web Password ====
	* Clear /var/lib/pgamdin folder		* Clear /var/lib/pgamdin folder
	* Reconfigure the web interface		* Reconfigure the web interface
	<pre> dpkg-reconfigure pgamin4-apache </pre>		<pre> dpkg-reconfigure pgamin4-apache </pre>

Nicolas: Created page with "=== PgAdmin4=== ==== Reset Web Password ==== * Clear /var/lib/pgamdin folder * Reconfigure the web interface

 dpkg-reconfigure pgamin4-apache

2020-08-08T20:22:12Z

Created page with "=== PgAdmin4=== ==== Reset Web Password ==== * Clear /var/lib/pgamdin folder * Reconfigure the web interface <pre> dpkg-reconfigure pgamin4-apache </pre>"

New page

=== PgAdmin4===
==== Reset Web Password ====
* Clear /var/lib/pgamdin folder
* Reconfigure the web interface
<pre> dpkg-reconfigure pgamin4-apache </pre>

Postgresql - Revision history

Nicolas at 22:00, 2 March 2025

Nicolas at 17:15, 17 April 2022

Nicolas at 16:42, 17 April 2022

Nicolas: /* PgAdmin4 */

Nicolas at 21:16, 8 August 2020

Nicolas: /* PgAdmin4 */

Nicolas: /* PgAdmin4 */

Nicolas: Created page with "=== PgAdmin4=== ==== Reset Web Password ==== * Clear /var/lib/pgamdin folder * Reconfigure the web interface dpkg-reconfigure pgamin4-apache "

Nicolas: Created page with "=== PgAdmin4=== ==== Reset Web Password ==== * Clear /var/lib/pgamdin folder * Reconfigure the web interface
dpkg-reconfigure pgamin4-apache
"