Re: Complete PGADMIN4 installation instructions
Dave Page <[email protected]> Wed, 18 Dec 2019 09:14:28 +0000
| Newsgroups | gmane.comp.db.postgresql.admin,gmane.comp.db.postgresql.novice,gmane.comp.db.postgresql.pgadmin |
|---|---|
| Message-ID | <CA+OCxoxBeAVwMu+x82vMeAvgMyHECLXtDPxOwrU+wiGSowwFVg@mail.gmail.com> |
--000000000000dd9dcf0599f6df9b Content-Type: text/plain; charset="UTF-8" On Wed, Dec 18, 2019 at 12:42 AM Zahid Rahman <[email protected]> wrote: > > Software crisis averted. > PGADMIN4 Complete working instructions. > > First I followed these instructions to download and install software > https://www.postgresql.org/download/linux/ubuntu/ > only up to postgresql-server-dev-12. no further. > Not sure what that has to do with pgAdmin? Plus the PostgreSQL APT repo most definitely contains the latest 12.1 release. > > Then I went to this website by googling sudo apt-get install pgadmin4 > apache > https://www.tecmint.com/install-pgadmin-debian-10/ although I have ubuntu. > > > copied and pasted the following code changing the email and password. > To the one I put in when prompted for and while running command line > sudo apt-get install pgadmin4 apache. > > Also if run this command: systemctl status apache2 then you can 'q' > out of it to continue. > THIS MAY NOT WORK: http://SERVER_IP/pgadmin4 OR http://localhost/pgadmin4 > > Don't forget to stop service apache server. sudo systemctl stop apache2 > otherwise you will get a port clash with docker. > > then I went to website > https://www.pgadmin.org/docs/pgadmin4/latest/container_deployment.html > > SO downloaded docker with snap. sudo snap install docker > > sudo docker pull dpage/pgadmin4 > sudo docker run -p 80:80 \ > -e '[email protected]' \ > -e 'PGADMIN_DEFAULT_PASSWORD=SuperSecret' \ > -d dpage/pgadmin4 > > ran sudo docker > sudo docker run -p 80:80 -e 'PGADMIN_DEFAULT_EMAIL= > [email protected]' -e 'PGADMIN_DEFAULT_PASSWORD=*******' -d > dpage/pgadmin4 > > Here is the KICKER. (not http://127.0.0.1/pgadmin4) > go to browser and type http://127.0.0.1 and you will see the blue login > screen prompting you for the > above email and password. > That's certainly how you can deploy a pgAdmin container. Unless you specifically want to use the container though, I would use the Debian/Ubuntu packages, per the article you linked to above. We don't maintain those directly though, so I'm not sure how accurate those instructions are. It would probably help if you posted error messages etc. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company --000000000000dd9dcf0599f6df9b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">= <div dir=3D"ltr" class=3D"gmail_attr">On Wed, Dec 18, 2019 at 12:42 AM Zahi= d Rahman <<a href=3D"mailto:[email protected]">[email protected]</= a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p= x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><d= iv dir=3D"ltr"><div><br></div><div>Software crisis averted.</div><div> PGAD= MIN4 =C2=A0 Complete working instructions.</div><br>First I followed these = instructions to download and =C2=A0install software<br><a href=3D"https://w= ww.postgresql.org/download/linux/ubuntu/" target=3D"_blank">https://www.pos= tgresql.org/download/linux/ubuntu/</a><br>only up to postgresql-server-dev-= 12. no further.<br></div></blockquote><div><br></div><div>Not sure what tha= t has to do with pgAdmin? Plus the PostgreSQL APT repo most definitely cont= ains the latest 12.1 release.</div><div>=C2=A0</div><blockquote class=3D"gm= ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,= 204,204);padding-left:1ex"><div dir=3D"ltr"><br>Then =C2=A0I went to this w= ebsite =C2=A0by googling sudo apt-get install pgadmin4 apache<br><a href=3D= "https://www.tecmint.com/install-pgadmin-debian-10/" target=3D"_blank">http= s://www.tecmint.com/install-pgadmin-debian-10/</a> although I have ubuntu.<= br><br><br>copied and pasted the following code changing the email and pass= word.<br>To the one I put in =C2=A0when prompted for and =C2=A0while runnin= g command line sudo apt-get install pgadmin4 apache.<br><br>Also if =C2=A0r= un this command: =C2=A0systemctl status apache2 =C2=A0then you can 'q&#= 39; =C2=A0out of it to continue.<br>THIS MAY NOT WORK: =C2=A0<a href=3D"htt= p://SERVER_IP/pgadmin4" target=3D"_blank">http://SERVER_IP/pgadmin4</a> OR = <a href=3D"http://localhost/pgadmin4" target=3D"_blank">http://localhost/pg= admin4</a><br><br>Don't forget to stop service apache server. sudo syst= emctl stop apache2 otherwise you will get a port clash with docker.<br><br>= then I went to website <a href=3D"https://www.pgadmin.org/docs/pgadmin4/lat= est/container_deployment.html" target=3D"_blank">https://www.pgadmin.org/do= cs/pgadmin4/latest/container_deployment.html</a><br><br>SO downloaded docke= r with snap. =C2=A0sudo snap install docker<br><br>sudo docker pull dpage/p= gadmin4<br>sudo docker run -p 80:80 \<br>=C2=A0 =C2=A0 -e 'PGADMIN_DEFA= ULT_EMAIL=3D<a href=3D"mailto:[email protected]" target=3D"_blank">user@domai= n.com</a>' \<br>=C2=A0 =C2=A0 -e 'PGADMIN_DEFAULT_PASSWORD=3DSuperS= ecret' \<br>=C2=A0 =C2=A0 -d dpage/pgadmin4<br><br>ran =C2=A0sudo docke= r<br>sudo docker run -p 80:80 =C2=A0 =C2=A0 -e 'PGADMIN_DEFAULT_EMAIL= =3D<a href=3D"mailto:[email protected]" target=3D"_blank">zahidr1000@gma= il.com</a>' =C2=A0 =C2=A0 -e 'PGADMIN_DEFAULT_PASSWORD=3D*******= 9; =C2=A0 =C2=A0 -d dpage/pgadmin4<br><br>Here is the KICKER. (not =C2=A0<a= href=3D"http://127.0.0.1/pgadmin4" target=3D"_blank">http://127.0.0.1/pgad= min4</a>)<br>go to browser and type <a href=3D"http://127.0.0.1" target=3D"= _blank">http://127.0.0.1</a> and you will see the blue login screen prompti= ng you for the<br>above email and password.<br></div></blockquote><div>=C2= =A0<br></div></div>That's certainly how you can deploy a pgAdmin contai= ner. Unless you specifically want to use the container though, I would use = the Debian/Ubuntu packages, per the article you linked to above. We don'= ;t maintain those directly though, so I'm not sure how accurate those i= nstructions are. It would probably help if you posted error messages etc.<b= r clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr" class=3D"gmail_signa= ture">Dave Page<br>Blog: <a href=3D"http://pgsnake.blogspot.com" target=3D"= _blank">http://pgsnake.blogspot.com</a><br>Twitter: @pgsnake<br><br>Enterpr= iseDB UK: <a href=3D"http://www.enterprisedb.com" target=3D"_blank">http://= www.enterprisedb.com</a><br>The Enterprise PostgreSQL Company<br></div></di= v> --000000000000dd9dcf0599f6df9b--