Re: How do I enabled Windows 10 to be able to run PSQL etc

--000000000000f2a14a05922025ff
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Sep 9, 2019 at 6:07 AM Karen Goh <[email protected]> wrote:

> Hi Rob,
>
> I refer to your comment -
> I think you need to add =E2=80=9Cmembership=E2=80=9D to your pgadmin conn=
ection string.
>
> How do I add in the pgadmin connection string at pgAdmin4 ?
>
> Before that, I was creating table using the sql script in version 10 and
> there was no problem at all.
>
> So, it really baffled me it is not working out this time.
>
> And tomorrow I have an important demo and it seems that I have to take ou=
t
> this table in my app to show...which will be less impressive in a not so
> impressive app that i have created ....:(
>
> I have made some more screenshots which shows some more error when I trie=
d
> to retrieve the table under the table postgres which is already created n=
ot
> it is not showing the table.
>
> Please help,
>

Your second screenshot seems to indicate your connection between PgAdmin
and Pg 11 Server is broken in some ways. If I were taking over the keyboard
at your workstation and had a critical deadline for tomorrow, here are some
steps I would take:

   - Dump my databases, if I can
   - Backup whatever work I have on a usb stick (create sql files, etc)
   - Uninstall Pg Server and Pg Admin
   - Reinstall and see if things start working better

Then on more detailed level, my understanding of Postgres is that when you
prefix a word in front of a table you are referring to a schema so
create table membership.parents...

Will never work unless you first create the schema
<https://www.postgresql.org/docs/current/sql-createschema.html>that parents
sit within:
create schema membership

Is it possible your problem is that you aren't creating membership schema
in your database? (Postgres treats schemas in much the same way that other
database engines treat actual databases).

Finally, if you are desperate for a working Pg SQL server over the next 24
hours consider spinning up an AWS RDS Pg instance and connecting PgAdmin to
that - that way you know the database is reliable and correctly configured
for sure. There might even be a "free tier" that gives you free service for
that time frame..

Steve

--000000000000f2a14a05922025ff
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 Mon, Sep 9, 2019 at 6:07 AM Karen =
Goh &lt;<a href=3D"mailto:[email protected]">[email protected]</a>&gt=
; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>  =
               Hi Rob,<br><br>I refer to your comment -<br>I think you need=
 to add =E2=80=9Cmembership=E2=80=9D to your pgadmin connection string.<br>=
<br>How do I add in the pgadmin connection string at pgAdmin4 ?<br><br>Befo=
re that, I was creating table using the sql script in version 10 and there =
was no problem at all.<br><br>So, it really baffled me it is not working ou=
t this time.<br><br>And tomorrow I have an important demo and it seems that=
 I have to take out this table in my app to show...which will be less impre=
ssive in a not so impressive app that i have created ....:(<br><br>I have m=
ade some more screenshots which shows some more error when I tried to retri=
eve the table under the table postgres which is already created not it is n=
ot showing the table.<br><br>Please help,<br></div></blockquote><div><br></=
div><div>Your second screenshot seems to indicate your connection between P=
gAdmin and Pg 11 Server is broken in some ways. If I were taking over the k=
eyboard at your workstation and had a critical deadline for tomorrow, here =
are some steps I would take:</div><div><ul><li>Dump my databases, if I can<=
br></li><li>Backup whatever work I have on a usb stick (create sql files, e=
tc)</li><li>Uninstall Pg Server and Pg Admin</li><li>Reinstall and see if t=
hings start working better</li></ul><div>Then on more detailed level, my un=
derstanding of Postgres is that when you prefix a word in front of a table =
you are referring to a schema so <br></div><div style=3D"margin-left:40px">=
create table membership.parents...</div><br></div><div>Will never work unle=
ss you first <a href=3D"https://www.postgresql.org/docs/current/sql-creates=
chema.html">create the schema </a>that parents sit within:</div><div style=
=3D"margin-left:40px">create schema membership</div></div><div class=3D"gma=
il_quote"><br></div><div class=3D"gmail_quote">Is it possible your problem =
is that you aren&#39;t creating membership schema in your database? (Postgr=
es treats schemas in much the same way that other database engines treat ac=
tual databases).</div><div class=3D"gmail_quote"><br></div><div class=3D"gm=
ail_quote">Finally, if you are desperate for a working Pg SQL server over t=
he next 24 hours consider spinning up an AWS RDS Pg instance and connecting=
 PgAdmin to that - that way you know the database is reliable and correctly=
 configured for sure. There might even be a &quot;free tier&quot; that give=
s you free service for that time frame..<br></div><div class=3D"gmail_quote=
"><br></div><div class=3D"gmail_quote">Steve</div><div class=3D"gmail_quote=
"><br></div></div>

--000000000000f2a14a05922025ff--