Re: FW: Error! - Mailing list pgsql-general

From Adrian Klaver
Subject Re: FW: Error!
Date
Msg-id 124f49a3-5f47-de91-7677-59f7c16d5060@aklaver.com
Whole thread Raw
In response to FW: Error!  (Arquimedes Aguirre <puntal8@hotmail.com>)
Responses RE: FW: Error!
List 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.klaver@aklaver.com>
> *Sent: *Saturday, April 15, 2023 5:56 PM
> *To: *Arquimedes Aguirre <mailto:puntal8@hotmail.com>; pgsql-general 
> list <mailto:pgsql-general@lists.postgresql.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.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>>
>  > *Sent: *Saturday, April 15, 2023 11:41 AM
>  > *To: *Arquimedes Aguirre <mailto:puntal8@hotmail.com 
> <mailto:puntal8@hotmail.com>>; pgsql-general
>  > list <mailto:pgsql-general@lists.postgresql.org 
> <mailto:pgsql-general@lists.postgresql.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.klaver@aklaver.com
>  >
> 
> -- 
> Adrian Klaver
> adrian.klaver@aklaver.com
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Arquimedes Aguirre
Date:
Subject: RE: FW: Error!
Next
From: FOUTE K. Jaurès
Date:
Subject: Call a Normal function inside a Trigger Function