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 &lt;<a href=3D"mailto:[email protected]">[email protected]</=
a>&gt; 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 &#39;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&#39;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 &#39;PGADMIN_DEFA=
ULT_EMAIL=3D<a href=3D"mailto:[email protected]" target=3D"_blank">user@domai=
n.com</a>&#39; \<br>=C2=A0 =C2=A0 -e &#39;PGADMIN_DEFAULT_PASSWORD=3DSuperS=
ecret&#39; \<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 &#39;PGADMIN_DEFAULT_EMAIL=
=3D<a href=3D"mailto:[email protected]" target=3D"_blank">zahidr1000@gma=
il.com</a>&#39; =C2=A0 =C2=A0 -e &#39;PGADMIN_DEFAULT_PASSWORD=3D*******&#3=
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&#39;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&#39=
;t maintain those directly though, so I&#39;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--