Re: FW: Error!

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Arquimedes Aguirre <puntal8(at)hotmail(dot)com>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: FW: Error!
Date: 2023-04-16 04:24:04
Message-ID: 124f49a3-5f47-de91-7677-59f7c16d5060@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/15/23 16:56, Arquimedes Aguirre wrote:
> Adrian
>
> I am new using this postgres program and pgadmin 4 sorry, I am starting
> to use it.

First to be clear Postgres is the database server and pgAdmin4 is just a
client for that server, a GUI in this case.

>
> In your first question, you mean that in my initial messages I did not
> mention that I can connect using pgadmin 4. I think you mean that I say
> that the postgres and pgadmin 4 programs are running. I have pgadmin 4
> open at the moment that I open the psql shell and I perform the process
> for the password that does not allow me to proceed. When I say that it
> is running, it is that I have it open and I put the password that I
> established from the beginning and it works in pgadmin 4. I attach a
> screen print when I open the pgadmin 4 program.

That is the screen to open the pgAdmin4 program. You need to enter the
password to get into the pgAdmin4 program.

>
> In your second question I tell you that I don't have a user for logging,
> only when I start the pgadmin 4 program it asks me for the password.
> attached the screen print.

Do you have a password that gets you to the pgAdmin4 screen where you
can click on the Servers tab under Browser?

It is a user for login not logging
>
> Three question; Where can I see what connection parameters I am using in
> pgAdmin4? I don't know where I can see that information, please if you
> can tell me, I can locate it and give you that information.

That will be in the Properties for each server when you expand the
Servers tree.

Expand Servers, the right click on a server name to get to Properties.,
You can also Connect Server from the right click menu. Try that and see
if you get a connection to a server.

>
> Four question: I am doing a project and I need the programs working
> correctly, that's it.
>
> Five question: Just a Postgresql 15.
>
> Thanks! for your attention! and collaboration!
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
>
> *From: *Adrian Klaver <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> *Sent: *Saturday, April 15, 2023 5:56 PM
> *To: *Arquimedes Aguirre <mailto:puntal8(at)hotmail(dot)com>; pgsql-general
> list <mailto:pgsql-general(at)lists(dot)postgresql(dot)org>
> *Subject: *Re: FW: Error!
>
> On 4/15/23 15:28, Arquimedes Aguirre wrote:
> > Hi Dear
> >
> > If I have the postgres and admin 4 program running with the password
> > that I set from the beginning, but when I want to start the psql shell
> > and set the same password, it throws me the error, I send the screen I
> > think it's self explanatory .
>
> If it where I would not have asked. Nowhere in your opening messages did
> you mention you could connect using pgAdmin4.
>
> > If I can log in to the pgadmin 4 program, I don't have a problem with
> that.
>
> So what user are you logging in as from pgAdmin4?
>
> Also what connection parameters are you using in pgAdmin4?
>
> >
> > My approach to the problem has always been the same, the password that I
> > established from the beginning when I installed postgres and pgadmin 4
> > is the one that I am using to start in the psql shell and it is not
> > accepted, which is why it does not allow me to move forward, I hope
> > these clarifications help you allow you to understand and attend to the
> > problem that is being presented to me with these tools.
> >
> > *Then you went into the MS dance of reinstalling/rebooting with no *
> >
> > *explanation of what prompted that initial reinstall?* I don’t
> > understand what do you want mean? I have never reinstalling/rebooting,
> > what I said in the email is that I had to install and uninstall it
> > several times due to the errors that were thrown at me, I also sent the
> > screenshot.
>
> Your email said differently:
>
> '... but I got this type of error more than 30 times downloading various
> versions of postgresql that are in the link that you sent me.'
>
> Or did you just download for the fun of it and not actually install.
>
> How many versions of Postgres do you have installed now?
>
> >
> > Thanks!
> >
> > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986
> <https://go.microsoft.com/fwlink/?LinkId=550986>> for Windows
> >
> > *From: *Adrian Klaver <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> > *Sent: *Saturday, April 15, 2023 11:41 AM
> > *To: *Arquimedes Aguirre <mailto:puntal8(at)hotmail(dot)com
> <mailto:puntal8(at)hotmail(dot)com>>; pgsql-general
> > list <mailto:pgsql-general(at)lists(dot)postgresql(dot)org
> <mailto:pgsql-general(at)lists(dot)postgresql(dot)org>>
> > *Subject: *Re: FW: Error!
> >
> > On 4/15/23 07:39, Arquimedes Aguirre wrote:
> >  > Hi Dear!
> >  >
> >  > I was able to install the postgresql program and admin 4, as I
> told you
> >  > before, but I got this type of error more than 30 times downloading
> >  > various versions of postgresql that are in the link that you sent me,
> >
> > This is the part that confuses me. You said you had it working.
> >
> > At that point could you log in using psql with the password?
> >
> > Then you went into the MS dance of reinstalling/rebooting with no
> > explanation of what prompted that initial reinstall?
> >
> > Was it:
> >
> > 1) The password did not work
> >
> > 2) Something else?
> >
> > Can you currently log in via pgAdmin4?
> >
> > Also what version of Postgres are you currently using?
> >
> > Is that different from the one you initially started with?
> >
> >
> >  > that's why I had to ask for help from Microsoft Team team, since
> it is a
> >  > rather weird and odd situation. Now I have this problem with the psql
> >  > shell I can't start the program but it don’t allows me to proceed with
> >
> >   From your previous posts you show you can start the shell script that
> > runs psql and that psql actually starts it just do not connect due to
> > password error.
> >
> >  > the password, which is the same one that I set from the beginning, now
> >  > what should I do to fix this once and for all???.
> >  >
> >  > Thanks!
> >  >
> >
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com
> >
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message FOUTE K. Jaurès 2023-04-16 14:18:23 Call a Normal function inside a Trigger Function
Previous Message Arquimedes Aguirre 2023-04-15 23:56:06 RE: FW: Error!