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
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! |